LightdashLightdash empowers dbt users with a unified BI layer for metric definition and exploration, fostering data trust and accessibility across organizations.

Lightdash is an open-source business intelligence solution that directly integrates with dbt projects, enabling teams to define, curate, and share critical business metrics.

Lightdash suits teams and individuals with the following needs:

• Centralized Metric Management: Define and document key business metrics once in dbt, then easily access and visualize them in Lightdash across your organization.
• Self-Serve Data Exploration: Empower business users to explore data and build their own reports using curated metrics, reducing reliance on data teams.
• Data Governance and Consistency: Ensure everyone is using the same definitions and calculations for critical KPIs, improving data accuracy and trust.
• Enhanced dbt Workflow: Bridge the gap between data transformation in dbt and data consumption, making your dbt investments more valuable.

Lightdash works through a set of core capabilities:

• dbt metric integration
• Customizable dashboards
• Data exploration tools
• Metric catalog and documentation
• Access control and permissions
• SQL query builder

Lightdash offers these pricing plans:

• Best suited for dbt-centric workflows
• May require technical expertise for advanced setup

• Metabase
• Superset
• Looker

1. Install dbt and create your data models.
2. Install Lightdash and connect it to your dbt project.
3. Define your business metrics in dbt and start exploring and building dashboards in Lightdash.

SynaBot's AI assistants and prompt library pair naturally with tools like Lightdash. Use SynaBot to draft the strategy or content, then move the output into Lightdash for execution — or automate the flow with our AI consultancy service.