Lightdash vs Fulcrum
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.
Field-data captures grow a BI layer while mobile coasts on fixes.
Fulcrum continues steady weekly shipping across web, iOS, and Android, but the substance is concentrated on the web. Recent releases add a freehand lasso selection on maps, a Power BI connector, and time-aware Insights (Beta) queries. Mobile cadence is dominated by single-issue stability fixes rather than new capabilities.
The product is widening from pure field-data capture into the analyze-and-share layer above it. Web work is going into bulk-action ergonomics, BI tooling integration, and growing the Insights surface. Mobile platforms are tracking a maintenance pattern, with versioned releases shipping one or two narrow fixes at a time and no new user-facing capabilities.
Expect Insights to gain depth toward general availability, with more BI-side integrations and richer bulk operations on web selections. Mobile is unlikely to see significant new capabilities in the next cycle.
See more alternatives to Lightdash →
See more alternatives to Fulcrum →