Most BI tools expect you to model your data their way. Lightdash flips that: it reads your dbt project directly, which means if you've already done the hard work of modeling your data for transformation, you get instant dashboards with zero additional configuration. Their AI lets you ask questions in plain English and get charts back, and since everything is Git-backed, your analytics are version-controlled and code-reviewable for the first time.

Main Features

• Deep dbt Integration: Reads your dbt project directly for automatic dimensional modeling and lineage. If your data is already modeled in dbt, you're done.
• AI-Powered Chart Creation: Ask questions in natural language and get visualizations instantly. No SQL required for ad-hoc exploration.
• Semantic Layer: Define metrics once in YAML and they're consistent across every dashboard. No more arguing about what 'revenue' actually means.
• Interactive Dashboards: Drill-downs, cross-filtering, and real-time collaboration on dashboards. Explore data dynamically instead of staring at static reports.
• Version-Controlled BI: Git-backed dashboard definitions with CI/CD for analytics code. Review, test, and deploy dashboards like software.
• Self-Serve Exploration: Non-technical users create charts and explore data without writing SQL. Business teams get answers without waiting for analyst bandwidth.
• Alerting and Scheduled Deliveries: Alerts to Slack, email, and webhooks when metrics cross thresholds. Scheduled report deliveries to stakeholders on their preferred cadence.
• Open-Source Core: Open-source with cloud hosting option. SSO and SAML for enterprise deployments. No vendor lock-in for your analytics infrastructure.

Who Should Use It?

• Data Analysts at dbt Shops: Analysts at organizations using dbt who want BI that respects their existing transformation logic.
• Analytics Engineers: Engineers building governed, version-controlled reporting layers for large data teams.
• Startup Data Teams: Data teams replacing legacy BI tools with a modern, developer-friendly alternative that integrates with their stack.
• Enterprise Organizations: Companies standardizing metrics across departments with a single source of truth for all reporting.
• Product Managers: PMs self-serving insights from modeled data without waiting for analyst bandwidth.
• Data Leaders: Heads of data evaluating open-source BI solutions that integrate with the modern data stack.
• Consulting Agencies: Consultants building client dashboards with repeatable, code-first analytics patterns.