Holistics vs Lightdash
Side-by-side trajectory, velocity, and editorial themes.
Holistics turns the BI dashboard into a conversational AI surface, on customer-owned models.
Holistics is well into a BI-meets-AI productization phase, layering conversational analytics on top of its existing modeling and dashboard core. Recent releases mix consumer-grade dashboard polish (auto-run filters, K/M/B number formatting, percentile calculations) with deeper AI plumbing: bring-your-own Claude and Gemini keys, per-user AI access controls, and now an Ask AI that asks clarifying questions back. The GitHub App integration also signals enterprise-readiness work alongside the AI push.
The product is being repositioned from a self-service BI tool to an AI-mediated analytics workspace where natural-language exploration is the headline interaction. Crucially, the team is pushing AI as an infrastructure layer customers can own — BYO LLM keys, granular access policies — rather than locking customers into a vendor-managed model. The dashboard improvements look incremental, but read as ground prep for AI agents to consume and manipulate dashboards more reliably.
Expect the next quarter to bring agentic dashboard editing — Ask AI not just answering but proposing dashboards and saving them — plus expanded BYO LLM coverage (likely Azure OpenAI or open-weights via OpenRouter) to widen procurement options for enterprise buyers.
Lightdash chips away at the SQL barrier with NL-to-formula table calcs and metric-tree visualization.
The release cadence is high and the work spans three areas: lowering the technical barrier (spreadsheet-style formulas in table calculations, plain references to grand totals), enriching what a chart and dashboard can express (color palettes at every scope, row/column limits, rich-text table cells), and self-serve operability (default user spaces, expiring preview projects, dashboard-version rollbacks that include chart configs). The Canvas now hosts persistent metric trees, hinting at a heavier semantic-layer story.
Lightdash is positioning between a dbt-native semantic layer (where SQL-fluent analysts live) and a self-serve BI tool (where business users live). The intent-driven formula editor and reference-total functions chip away at the SQL prerequisite for table calculations, while Saved Trees push the metric model into something visually editable. Underneath, the platform is doing the unglamorous self-serve work — personal spaces, palette hierarchies, preview hygiene — that BI products need to survive in larger orgs.
Expect the formula editor to grow into broader AI-assisted authoring (filters, joins, custom dimensions) and Saved Trees to evolve into a more general semantic-layer view that consumes from dbt and produces governance artifacts. Color and palette work suggests embedded/customer-facing BI ambitions next.
See more alternatives to Holistics →
See more alternatives to Lightdash →