Lightdash is a business intelligence platform built around dbt projects.
It turns dbt models into a self-service analytics environment where data teams can define business metrics and dimensions in code, while other users can explore governed data, build charts and dashboards, and answer questions without writing SQL. It also focuses on developer-friendly workflows, with support for validation, preview environments, and version-controlled analytics content.
This is free and open source software.
Key Features
- Uses dbt projects as the foundation for a semantic BI layer.
- Lets teams declare metrics and dimensions in YAML alongside dbt models.
- Automatically creates dimensions from dbt models and syncs dbt descriptions and metadata.
- Provides drill-down access to underlying chart records and supports table calculations.
- Includes lineage views for understanding upstream and downstream model dependencies.
- Offers a data visualisation library for building charts and dashboards.
- Supports preview BI environments, automated content validation, and CI/CD workflows.
- Lets users share work by URL or schedule deliveries through Slack or email.
- Cross-platform support – runs under Linux and macOS.
Website: github.com/lightdash/lightdash
Support:
Developer: Lightdash
License: MIT License (core code); enterprise components are separately licensed.
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 |
| Pentaho | Enterprise reporting, analysis, dashboard, data mining, workflow |
| Redash | Explore, query, visualize, and share data |
| Knowage | (formerly SpagoBI) Flexible business intelligence suite |
| JasperReports | A widely used reporting engine |
| KNIME | Konstanz Information Miner |
| ReportServer | Modern and versatile business intelligence platform |
| Rill | Operational BI tool |
| BIRT Project | Eclipse-based reporting system |
| Gephi | Visualization and exploration software for all kinds of graphs and networks |
| RapidMiner | Data analysis, knowledge discovery, data mining, predictive analytics |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |