Lightdash vs Whatagraph
Side-by-side trajectory, velocity, and editorial themes.
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.
Whatagraph adds Data Storage and a Snowflake source — agency reports stop waiting on live API calls.
Whatagraph is moving from 'report builder over live API connections' to 'managed data layer plus report builder.' Two recent releases anchor the shift: Data Storage lets Whatagraph store customer data on its own infrastructure with a 24-month default backfill, and Snowflake has been added as a first-party data source so warehouse tables can sit alongside paid media and web analytics in the same report. Around that, the company is filling in standard reporting depth — GeoMap widget, conditional formatting, Gauge and Heatmap widget types — plus broader integration coverage like bol. Retailer and Advertising for Benelux retail media and a rebuilt event-level CallTrackingMetrics.
The product is pushing toward becoming an agency-grade marketing reporting platform that also owns the data plumbing. Historically agencies had to choose between Whatagraph-style report builders (fast but live-API constrained) and BigQuery-based stacks (flexible but heavyweight). Whatagraph's managed Storage destination collapses that choice, and the Snowflake source pulls customer-warehouse data directly into the reporting surface — both moves widen the addressable customer set into mid-market and larger agencies.
Expect the next quarter to deepen the data layer: a SQL-style transformation interface on stored data, more warehouse sources (likely Databricks or Redshift), and a billing change that splits the storage layer from the report-builder seat licenses. The GeoMap widget will exit beta with continent-grouped drill-downs.
See more alternatives to Lightdash →
See more alternatives to Whatagraph →