Lightdash is a business intelligence platform built around a governed semantic layer and developer-friendly analytics workflows.
Teams can define metrics, dimensions, and relationships using dbt projects or standalone Lightdash YAML connected to their data warehouse. This separates business definitions from individual charts and helps maintain consistent metrics across dashboards and analysis.
Lightdash combines self-service exploration with charts, dashboards, SQL querying, lineage, Git integration, and content-as-code workflows. Changes can be previewed and validated before deployment, making it particularly attractive to teams that want analytics development to follow similar review and version-control practices to software development.
This is free and open source software.
Key Features
- Works with dbt projects or standalone Lightdash YAML.
- Semantic layer for defining reusable dimensions, metrics, and relationships.
- Automatically derives metadata from dbt projects.
- Interactive charts and dashboards.
- SQL Runner for querying warehouse data directly.
- Drill-down access to underlying records.
- Table calculations for deriving additional values.
- Lineage tools for understanding relationships between analytics content and models.
- Supports multiple data connections within a project.
- Preview environments for testing changes before deployment.
- Validation tools for detecting problems in analytics projects.
- Content-as-code workflows suitable for Git and CI/CD.
Website: github.com/lightdash/lightdash
Support:
Developer: Lightdash
License: MIT License

Lightdash is written in TypeScript. Learn TypeScript with our recommended free books and free tutorials.
Related Software
| Business Intelligence Software | |
|---|---|
| Metabase | Business intelligence and analytics software |
| Grafana | Platform for monitoring and observability |
| Superset | Data visualization and data exploration platform |
| Redash | Explore, query, visualize, and share data |
| Knowage | (formerly SpagoBI) Flexible business intelligence suite |
| ReportServer | Modern and versatile business intelligence platform |
| Apache Zeppelin | Interactive notebooks for data analytics and visualisation |
| KNIME | Konstanz Information Miner |
| JasperReports | A widely used reporting engine |
| Rill | Operational BI tool |
| BIRT Project | Eclipse-based reporting system |
| Querybook | Collaborative SQL editor for querying and exploring large datasets |
| Lightdash | Looker alternative |
| evidence | Code-based alternative to drag-and-drop business intelligence tools |
| Shaper | SQL-first analytics and dashboard platform |
| Frappe Insights | Self-service business intelligence with interactive dashboards |
Read our verdict in the software roundup.
LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |


Please read our Comment Policy before commenting.