/lightdash

Open source BI for teams that move fast ⚡️

Primary LanguageTypeScriptMIT LicenseMIT

The open-source Looker alternative.


WebsiteWatch demoDocsJoin Slack Community

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

If you're a fan, star the repo ⭐️ (we plant a tree for every GitHub star we get 🌱).

Come join the team, we're hiring.

Features:

  • 🙏 Familiar interface for your users to self-serve using pre-defined metrics
  • 👩‍💻 Declare dimensions and metrics in yaml alongside your dbt project
  • 🤖 Automatically creates dimensions from your dbt models
  • 📖 All dbt descriptions synced for your users
  • 🧮 Table calculations make it easy to dig into your data, on the fly
  • 🕵️‍♀️ Lineage lets you see the upstream and downstream dependencies of a model
  • 📊 Simple data visualisations for your metrics
  • 👷‍♂️ Save charts & build dashboards to share your insights with your team
  • 🚀 Share your work as a URL or export results to use in any other tool

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

1-click deploy

Deploy Lightdash with 1-click on Render for free.

Deploy to Render

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.

Sign up to Lightdash Cloud

You can avoid the hassle of hosting and configuring Lightdash yourself by signing up for Lightdash Cloud . We'll let you know once we're ready to bring you on board 🙂

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 elsewhere:

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 some tutorials, reference docs, FAQs and more.

Reporting bugs and feature requests

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

The Lightdash Forest

We're planting trees with the help of the Lightdash community.

Tree planting is one of the simplest and most cost-effective means of mitigating climate change, by absorbing CO2 from the atmosphere. So we thought it would be pretty neat to grow a forest while we grow Lightdash.

Want to help us grow our forest?

Just star this repo! We plant a tree for every star we get on Github. ⭐️ ➡️ 🌱

We plant trees with TIST, you can read all about them here: https://program.tist.org/.

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
Rahul Jain

📖
Oliver Laslett
Oliver Laslett

💻 📖 🐛 🎨 🚇
Katie Hindson
Katie Hindson

🐛 📖 🎨 💻 🤔
Hamzah Chaudhary
Hamzah Chaudhary

📖 💻 🤔 🐛
Harry Grieve
Harry Grieve

📖
Dominik Dorfmeister
Dominik Dorfmeister

🎨
amin-nejad
amin-nejad

🐛
Mitja Potočin
Mitja Potočin

💻
Jose Rego
Jose Rego

💻 🎨 📖 🐛 ⚠️ 🚇
Rahul
Rahul

🐛 🎨 💻 📖
Jeshua Maxey
Jeshua Maxey

🐛
Sreejith Madhavan
Sreejith Madhavan

🐛
skame
skame

🐛 🎨
sgoley
sgoley

📖
djayatillake
djayatillake

🎨 💻 🤔
Mukesh
Mukesh

🔣 🐛
Andreia Freitas
Andreia Freitas

⚠️ 📖
jb
jb

💻 🐛 🎨
Amy Chen
Amy Chen

📖
John Keech
John Keech

🚇
Dr. Ernie Prabhakar
Dr. Ernie Prabhakar

🐛 🤔
PriPatel
PriPatel

🎨 🐛 🤔
NaomiJohnson
NaomiJohnson

🎨 🐛
Rich Shen
Rich Shen

💻 ⚠️ 🐛
David Gasquez
David Gasquez

🤔 🎨
xjaner
xjaner

🤔
Chris Bol
Chris Bol

🤔
Anil V
Anil V

🤔
rlebrao
rlebrao

🤔 🐛
philcarr-tsl
philcarr-tsl

🐛 🔣
HashimsGitHub
HashimsGitHub

🚇
Nathalia Buitrago Jurado
Nathalia Buitrago Jurado

📖 💻 🐛 🎨
norbag
norbag

🐛
Shrpp
Shrpp

🐛
Cuong Vu
Cuong Vu

🐛
Takaaki Yoshikawa
Takaaki Yoshikawa

🤔
nkotlyarov
nkotlyarov

🐛
kim monzon
kim monzon

🤔
rverheijen
rverheijen

⚠️ 🐛
Spencer Carrucciu
Spencer Carrucciu

🤔
Mark Olliver
Mark Olliver

🐛
gary-beautypie
gary-beautypie

🐛
André Claudino
André Claudino

💻 🚇
Jim Park
Jim Park

🚇
gc-p
gc-p

🐛
Michał Łazowik
Michał Łazowik

💻
Chun Wei
Chun Wei

🤔
snyh-paulhenderson
snyh-paulhenderson

🤔
Frank Hoffsümmer
Frank Hoffsümmer

🐛
Sarah Moens
Sarah Moens

📖
Abhishek K M
Abhishek K M

💻
Javier Rengel Jiménez
Javier Rengel Jiménez

💻 🐛 ⚠️ 🚇 📖
Fisa
Fisa

🐛
JoelAlander
JoelAlander

🐛
Chad Floyd
Chad Floyd

🤔
André Claudino
André Claudino

🤔
12ian34
12ian34

📖 🐛 💻
raphaelauv
raphaelauv

🐛 📖
BA-CY
BA-CY

🤔
John Romanski
John Romanski

🐛
Jamie Davenport
Jamie Davenport

🐛
Marcus Windmark
Marcus Windmark

🤔
Shruti Kuber
Shruti Kuber

📖
Fszta
Fszta

📖
Mohamed Muhsin
Mohamed Muhsin

💻
magants
magants

🤔
Martin Carlsson
Martin Carlsson

🤔 🐛
Tomas Čerkasas
Tomas Čerkasas

🤔
TiFaBl
TiFaBl

🤔
Eric Cecchi
Eric Cecchi

💻
KristyMayer
KristyMayer

🐛
rahulstomar08
rahulstomar08

🤔
Charles Picowski
Charles Picowski

🐛
Matt Machczynski
Matt Machczynski

🐛
Irakli Janiashvili
Irakli Janiashvili

💻 🐛 🎨 ⚠️
Gordon Lee
Gordon Lee

🤔 📖
Olly
Olly

🤔 🐛
gautamdoulani
gautamdoulani

📖
David Peitinho
David Peitinho

🐛
Istvan Meszaros
Istvan Meszaros

🤔
Rif
Rif

📖
Phillip W.
Phillip W.

🤔
XiaozhouWang85
XiaozhouWang85

🤔
Rebecca Sanjabi
Rebecca Sanjabi

🐛
Kailin L
Kailin L

🤔
Metin Karakus
Metin Karakus

💻
Yasmine
Yasmine

💻 🐛 🤔 🎨
Piotr Pilis
Piotr Pilis

💻
Judah Rand
Judah Rand

🐛
Annebelle Olminkhof
Annebelle Olminkhof

📖
Victor Apolonio
Victor Apolonio

💻
Rodolfo Ferreira
Rodolfo Ferreira

💻
Patrick Brusven
Patrick Brusven

💻
Thomas Purchas
Thomas Purchas

💻 🐛
Adrian Letchford
Adrian Letchford

🤔
Collins
Collins

💻
Paul van der Linden
Paul van der Linden

🐛
Chris
Chris

💻
Mike Thoun
Mike Thoun

💻
Leon Kozlowski
Leon Kozlowski

💻
Nathan Coleman
Nathan Coleman

💻
Nicolas Frati
Nicolas Frati

💻
Fred
Fred

📖
Victor Lindell
Victor Lindell

💻
stellar-ahmed
stellar-ahmed

🐛
Cooper Williams
Cooper Williams

💻
Lokeswaran Aruljothi
Lokeswaran Aruljothi

💻
João Viana
João Viana

📖 💻 🐛
Muhammad Jufry
Muhammad Jufry

🐛
Patrik Braborec
Patrik Braborec

📖 🐛
David Flanagan
David Flanagan

💻 🚇
Moulik Aggarwal
Moulik Aggarwal

💻
Chandaluri Vamsi Krishna
Chandaluri Vamsi Krishna

💻
Elton Okawa
Elton Okawa

💻
JAY ANAND
JAY ANAND

💻
Yu Ishikawa
Yu Ishikawa

💻 🤔
magnew
magnew

💻

This project follows the all-contributors specification. Contributions of any kind welcome!