Visualisation & BI Plane · BI & Dashboards

Lightdash

BI built natively on dbt, taking metrics from the dbt project as the semantic layer. Open source to self-host, with a cloud tier priced per month rather than per seat.

Overview

Lightdash's defining choice is that it does not have a semantic layer of its own. The dbt project is the semantic layer: metrics and dimensions are defined in dbt YAML, and Lightdash reads them. For a team already running dbt that removes a whole category of work, and a whole category of drift between two competing definitions of a metric.

That is also the constraint. Without dbt there is nothing for Lightdash to read, so it is not a general-purpose BI tool in the way Metabase or Superset are. It supports dbt 1.4.0 and above, and documents five different ways to sync a project, which differ in where the code comes from, where compilation happens and which target governs the result.

Because definitions live in the project, lineage falls out of the design: any query can be traced back to the official definition behind it, and charts and dashboards can themselves be managed as code.

The 2026 positioning is agentic: conversational analytics for people who will not write SQL, AI agents, an MCP server, and data apps built on the same model. The pitch is that the shared understanding of the business gets richer the more the team uses it.

Pricing is the clearest departure from the category. Cloud Pro is $3,000 a month for unlimited users, stated directly against per-seat licensing, and the self-hosted open-source edition is free. That makes it unusually easy to cost for a wide readership audience, where per-seat tools get expensive precisely when a dashboard succeeds.

Key features and capabilities

The same headings are used for every bi & dashboards entry, so two tools can be read side by side.

Data modelling and semantic layer
  • The dbt project is the semantic layer; metrics and dimensions are defined in dbt YAML, not in the BI tool
  • Requires dbt 1.4.0 or above, so it is not usable without dbt
  • Five documented ways to sync a dbt project, differing in source of code, compilation location and target
  • A metrics catalog and explorer expose the definitions for governed self-service
Charts, dashboards and interactivity
  • Charts and dashboards, with unlimited visualisations on the paid cloud tier
  • Dashboards and charts can be managed as code rather than only through the interface
  • Custom data apps built on the same model
Calculations, AI and natural language
  • Conversational analytics aimed at people who will not write SQL
  • AI agents, with an MCP server so external agents can query the same definitions
  • Every query traceable back to the official definition behind it
Publishing, embedding and collaboration
  • Scheduled reports and alerting
  • Embedding through an iframe or a React SDK, sold as an add-on
  • Unlimited users on the paid cloud tier, so sharing is not rationed by licence count
Security, lineage and certification
  • Governance comes from the dbt project: one definition, version-controlled, reviewed in the usual way
  • Lineage for every data asset as a consequence of definitions living upstream
  • Advanced security and customisation are reserved for the Enterprise tier
Integrations
  • dbt is the integration that matters; the tool is built around it
  • MCP server and AI agents for agent-facing access
  • Automated migration from an existing BI provider is offered on the paid tier
Where it runs and what it costs
  • Open-source edition self-hosted on your own infrastructure, with community Slack support only
  • Cloud Pro hosted by Lightdash, with guided onboarding and human support
  • Enterprise adds deployment flexibility

Pricing

SubscriptionFree self-hosted; Cloud Pro $3,000 a month

The open-source edition is free to self-host, with community support and no managed infrastructure. Cloud Pro is $3,000 a month for unlimited users, positioned explicitly against per-seat pricing. Enterprise is quote-only, adding advanced security, support and deployment flexibility.

Vendor pricing page →

Demos and videos

About Lightdash

Lightdash develops the open-source BI tool of the same name and sells a hosted edition of it. The product is open source on GitHub and can be self-hosted at no cost, with support through a community Slack; the commercial offering is Cloud Pro at a flat monthly price and an Enterprise tier negotiated directly. The company publishes its pricing openly, including the headline number, which is uncommon among its competitors — Sigma, Omni and ThoughtSpot all route pricing enquiries to sales.

lightdash.com

Other bi & dashboards tools

Apache Superset

Visualisation & BI Plane · BI & Dashboards

Open-source data exploration and visualisation platform.

  • Open source

Domo

Visualisation & BI Plane · BI & Dashboards

Cloud analytics platform spanning connectors, transformation, dashboards, workflow automation and AI, priced by consumption credits with unlimited users rather than per seat.

  • Commercial

Looker

Visualisation & BI Plane · BI & Dashboards

BI platform on Google Cloud with a modelling layer, LookML, for governed metrics.

  • Cloud service

Metabase

Visualisation & BI Plane · BI & Dashboards

Open-source BI tool for questions, dashboards and embedded analytics.

  • Open core

Omni

Visualisation & BI Plane · BI & Dashboards

BI that pairs a shared data model with raw SQL, building the model progressively out of the analysis people actually do rather than requiring it up front.

  • Commercial

Power BI

Visualisation & BI Plane · BI & Dashboards

Microsoft's BI platform for semantic models, reports and dashboards, integrated with Fabric.

  • Commercial

Qlik Sense

Visualisation & BI Plane · BI & Dashboards

Analytics platform with an associative engine for exploring data.

  • Commercial

Sigma

Visualisation & BI Plane · BI & Dashboards

Spreadsheet-style analytics that queries the cloud warehouse directly, covering ad hoc analysis, dashboards, data apps and embedded analytics without extracting data.

  • Commercial

Tableau

Visualisation & BI Plane · BI & Dashboards

Visual analytics and BI platform for building interactive dashboards.

  • Commercial

ThoughtSpot

Visualisation & BI Plane · BI & Dashboards

Search and AI-driven analytics on cloud data, sold as an analytics product and an embedded SDK, with LLM usage included in the subscription rather than metered.

  • Commercial

Drafted with AI assistance and checked against the vendor’s own documentation.

Lightdash: BI & Dashboards · UDP