Video coming soon…
📈 Setup Lightdash — Business Intelligence on Your dbt Models
Deploy Lightdash on Ubuntu with Docker — an open-source BI tool that turns your dbt models into explorable charts and dashboards, so your whole team can self-serve analytics, on port 8232.
⚠️ This script is provided for demo and testing purposes only. Not intended for production use.
📦 Resources & Setup Scripts
Grab the automated bash script from GitHub to follow along with the video.
Quick Install:
wget https://raw.githubusercontent.com/mhmdali94/Docker/main/analytics/lightdash/lightdash-ubuntu.sh
chmod +x lightdash-ubuntu.sh
sudo bash lightdash-ubuntu.shTutorial Steps
1 Download the Script
wget https://raw.githubusercontent.com/mhmdali94/Docker/main/analytics/lightdash/lightdash-ubuntu.sh2 Make it Executable
chmod +x lightdash-ubuntu.sh3 Run the Installer
The script installs Docker if needed and starts Lightdash with its own PostgreSQL (for app metadata) on port 8232. It generates a secret and DB password; the first user to register becomes the admin, then connects a dbt project.
sudo bash lightdash-ubuntu.sh4 Open the Web UI and Connect dbt
Open Lightdash, register the first user, then connect your dbt project so Lightdash can turn its models and metrics into explorable charts:
http://<your-server-ip>:8232Ports Used
| Port | Purpose |
|---|---|
| 8232 | Web UI (host → container 8080) |
| first user | The first user to register becomes the admin |
| dbt + warehouse | Connect your dbt project and data warehouse; PostgreSQL for metadata |