The open-source Looker alternative.

    <a target="_blank" href="https://www.loom.com/share/c0805a236a994de397ac5142fdfe4b7f"><img align="center" style="max-width:300px;" src="https://github.com/lightdash/lightdash/raw/0.3309.0/static/screenshots/lightdash_preview_chart_animation.gif"> </a>









<a href="http://www.lightdash.com"><b>Website</b></a> •
<a href="https://www.loom.com/share/c0805a236a994de397ac5142fdfe4b7f"><b>Watch demo</b></a> •
<a href="http://docs.lightdash.com/"><b>Docs</b></a> •
<a href="https://join.slack.com/t/lightdash-community/shared_invite/zt-2wgtavou8-VRhwXI%7EQbjCAHQs0WBac3w"><b>Join Slack Community</b></a>

Enable everybody in your company to answer their own questions using data

connect your dbt project --> add metrics into dbt --> share insights with your team

Come join the team, we're hiring.

Features:

• [x] 🙏 Familiar interface for your users to self-serve using pre-defined metrics
• [x] 👩‍💻 Declare dimensions and metrics in yaml alongside your dbt project
• [x] 🤖 Automatically creates dimensions from your dbt models
• [x] 📖 dbt descriptions and metadata synced for your users
• [x] 🔍 Easily access to underlying records of charts as well as ability to data drill-down
• [x] 🧮 Table calculations make it easy to dig into your data, on the fly
• [x] 🕵️‍♀️ Lineage lets you see the upstream and downstream dependencies of a model
• [x] 📊 Comprehensive and intuitive data visualisation library for your metrics
• [x] 👷‍♂️ Save charts & build dashboards to share your insights with your team
• [x] 💻 Powerful developer experience including Preview BI Environments and automated content validation via CI/CD
• [x] 🔄 Explore version history of all your charts and roll-back at any point
• [x] 🚀 Easily share your work via URL or schedule deliveries via Slack or Email

Something missing? Check out our open issues to see if what you're looking for already exists (and give it a 👍). Otherwise, we'd love it if you'd open a new issue with your request 😊

Demo

Play with our demo app!

Quick start

Start with Lightdash Cloud

You can avoid the hassle of hosting and configuring Lightdash yourself by signing up for a free trial of Lightdash Cloud. More details on pricing available.

1-click deploy

Deploy Lightdash with 1-click on Render for free.

Run locally

Take advantage of our installation script to easily run Lightdash locally.

git clone https://github.com/lightdash/lightdash
cd lightdash
./scripts/install.sh

Deploy to production

Follow our kubernetes guide to deploy Lightdash to production using our community helm charts.

Getting started

Step 1 - ⚡️ Self-host Lightdash (optional)

Step 2 - 🔌 Connect a project

Step 3 - 👩‍💻 Create your first metric

Community Support

📣 If you want something a bit more, then head on over to our Slack Community where you’ll be able to chat directly with all of us at Lightdash and all the other amazing members of our community. We’re happy to talk about anything from feature requests, implementation details or dbt quirks to memes and SQL jokes!

You can also keep up to date with Lightdash by following us here:

• Twitter
• LinkedIn

About Lightdash

🗂 Keep all of your business logic in one place.

We let you define your metrics and dimensions directly in your dbt project, keeping all of your business logic in one place and increasing the context around your analytics.

No more deciding which of the four different values for total revenue is the right one (you can thank us later 😉).

🤝 Build trust in your data.

We want everyone at your company to feel like they can trust the data. So, why not show them that they can?

We bring the context you want around data quality into your BI tool so people know that they can trust the data.

🧱 Give users meaningful building blocks to answer their own data questions.

With Lightdash, you can leave the SQL to the experts. We give your data team the tools they need to build metrics and dimensions that everyone else can use.

So, anybody in the business can combine, segment, and filter these metrics and dimensions to answer their own questions.

📖 Open source, now and forever

Lightdash is built with our community, for our community.

We think that a BI tool should be affordable, configurable, and secure - and being open source lets us be all three 🙂

🤑 Affordable analytics

Love Looker, but don't love Looker's price tag?

With Lightdash, we offer a free self-hosted service (it's all just open source!), or an affordable cloud-service option if you're looking for an easy analytics set up.

Docs

Have a question about a feature? Or maybe fancy some light reading? Head on over to our Lightdash documentation to check out our tutorials, reference docs, FAQs and more.

Reporting bugs and feature requests

Want to report a bug or request a feature? Open an issue.

Developing locally & Contributing

We love contributions big or small, check out our guide on how to get started.

See our instructions on developing Lightdash locally.

Contributors ✨

Thanks goes to these wonderful people (emoji key):

Rahul Jain 📖	Oliver Laslett 💻 📖 🐛 🎨 🚇	Katie Hindson 🐛 📖 🎨 💻 🤔	Hamzah Chaudhary 📖 💻 🤔 🐛	Harry Grieve 📖	Dominik Dorfmeister 🎨	amin-nejad 🐛
Mitja Potočin