Business Intelligence

Lightdash – developer-friendly business intelligence platform

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 in action
Click image for full size

Lightdash is written in TypeScript. Learn TypeScript with our recommended free books and free tutorials.


Related Software

Business Intelligence Software
MetabaseBusiness intelligence and analytics software
GrafanaPlatform for monitoring and observability
SupersetData visualization and data exploration platform
RedashExplore, query, visualize, and share data
Knowage(formerly SpagoBI) Flexible business intelligence suite
ReportServerModern and versatile business intelligence platform
Apache ZeppelinInteractive notebooks for data analytics and visualisation
KNIMEKonstanz Information Miner
JasperReportsA widely used reporting engine
RillOperational BI tool
BIRT ProjectEclipse-based reporting system
QuerybookCollaborative SQL editor for querying and exploring large datasets
LightdashLooker alternative
evidenceCode-based alternative to drag-and-drop business intelligence tools
ShaperSQL-first analytics and dashboard platform
Frappe InsightsSelf-service business intelligence with interactive dashboards

Read our verdict in the software roundup.


Best Free and Open Source Software 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.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted