How to Set Up Apache Superset Dashboards

Apache Superset is a free, open-source business intelligence platform that connects to over 60 databases and lets teams build interactive dashboards through a no-code visual interface. Setting it up takes about 30 minutes using Docker, and once it is running, anyone on the team can build charts and dashboards through a browser without writing SQL or code.

What Apache Superset Is

Apache Superset was originally built at Airbnb to replace expensive commercial BI tools. It is now maintained by the Apache Software Foundation and used by thousands of companies worldwide. The platform connects to PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, Redshift, DuckDB, and more than 50 other databases. Once connected, it offers a drag-and-drop chart builder, a SQL editor for custom queries, and a full dashboard layout system.

The main reason teams choose Superset over paid tools like Tableau or Power BI is cost. Superset is free to run. The only real expense is the server it runs on, which can be as small as a $5 per month cloud instance or an idle office computer for small teams.

Before You Start

You need two things installed before setting up Superset:

• Docker Desktop: download from docker.com/products/docker-desktop
• Git: download from git-scm.com

Both are free and take about 10 minutes to install. Docker is the container platform that runs Superset in an isolated environment, so you do not need to worry about Python versions or system dependencies. If you are on Windows, enable WSL2 before installing Docker Desktop (the Docker installer will prompt you to do this automatically on modern Windows versions).

You will also want a database to connect to. If you do not have one, Superset includes sample datasets that work fine for learning the interface before connecting real data.

Step 1: Download and Start Superset

Open a terminal (Command Prompt on Windows, Terminal on Mac or Linux) and run these two commands in order:

git clone https://github.com/apache/superset
cd superset
docker compose -f docker-compose-image-tag.yml up

The first run downloads several container images, which takes 5 to 15 minutes depending on your internet speed. When the terminal shows messages about the web server starting, Superset is ready.

Open a browser and go to http://localhost:8088. You will see the login screen.

Default credentials are username admin and password admin. Log in and immediately change your password by going to the top-right user menu and selecting Reset Password.

Step 2: Connect a Database

The first real task after logging in is connecting Superset to your data source.

1. Click Settings in the top navigation bar
2. Select Database Connections
3. Click + Database in the top right
4. Choose your database type from the dropdown
5. Enter your connection string

For PostgreSQL, the connection string format is:

postgresql://username:password@host:port/database_name

For example, a local PostgreSQL database would look like:

postgresql://myuser:mypassword@localhost:5432/mydb

Click Test Connection before saving. If it passes, click Connect. If it fails, the most common causes are an incorrect host or port, or the database not accepting connections from the Docker network. For a local PostgreSQL setup, change localhost to host.docker.internal since Superset runs inside a Docker container.

Step 3: Register a Dataset

After connecting a database, you register the specific table you want to visualize.

1. Go to Data in the top navigation bar
2. Select Datasets
3. Click + Dataset
4. Choose your database, schema, and table
5. Click Add

Superset reads your column names and data types automatically. If a date column is not recognized as a time field, click the edit icon on the dataset and set the Main Datetime Column manually. This enables time-based filtering across all charts built from this dataset.

Step 4: Build Your First Chart

With a dataset registered, you can build a chart.

1. Go to Charts in the top navigation bar
2. Click + Chart
3. Select your dataset
4. Choose a visualization type

Superset ships with 40 plus chart types. For most business dashboards, the most useful starting options are:

• Bar Chart: comparing categories (e.g., revenue by region or orders by product line)
• Line Chart: trends over time (e.g., weekly signups or monthly churn rate)
• Big Number with Trendline: a single KPI with directional context
• Table: sortable and searchable raw data with column formatting

After selecting a chart type, the Explore view opens. The left panel has two sections. The Query section controls what data is shown: dimensions (the columns to group or filter by), metrics (the calculation to display such as SUM of revenue or COUNT of orders), and the time range. The Customize section controls how the chart looks: colors, labels, axis scales, and legend placement.

Click Update Chart after each change to see the result. Once the chart looks right, click Save and give it a clear name such as "Monthly Revenue by Region" or "Weekly Active Users."

A study from the Apache Superset community found that teams connecting real production databases typically spend 15 to 20 minutes building their first usable chart, with subsequent charts taking 5 minutes or less once the dataset is registered and the Explore interface is familiar.

Step 5: Build a Dashboard

A dashboard assembles multiple charts into a single shareable page.

1. Go to Dashboards in the top navigation bar
2. Click + Dashboard
3. Give it a descriptive name
4. Click Edit Dashboard
5. Drag charts from the right-side Charts panel into the dashboard canvas

Resize each chart by dragging its bottom-right corner. A practical layout for a business dashboard puts KPI numbers at the top row, trend charts in the middle, and detail tables at the bottom. This mirrors how executives scan reports: the headline number first, context second, and the full dataset available for drill-down.

Add a Filter Box component by dragging it in from the right panel. Filters let viewers slice the whole dashboard by date range, region, product, or any other dimension without knowing SQL. This is the feature that separates a useful team dashboard from a static screenshot.

When the layout is ready, click Save and change the status from Draft to Published. Anyone with viewer access to your Superset instance can now open the live dashboard in their browser.

Step 6: Manage Team Access

Superset has a built-in user management system. Go to Settings > Security > List Users to add teammates. Three roles cover most team setups:

• Viewer: can see published dashboards but cannot create or edit anything
• Alpha: can create and edit charts and dashboards using registered datasets
• Admin: full access including database connections, dataset registration, and user management

For dashboards that need to be accessible outside the Superset login (embedded in an internal portal or a company website), Superset supports iframe embedding. Open a dashboard, click Share, and copy the embed code. The embedded view is read-only and does not require visitors to have a Superset account.

If your team regularly works with uploaded CSV or Excel files rather than a live database connection, and you want analysis results without any server configuration, VSLZ generates charts and insights from file uploads through a single text prompt with no setup required.

Summary

Apache Superset is one of the most capable free BI tools available in 2026. The Docker-based setup takes about 30 minutes from first download to a published dashboard. The biggest practical decisions are which database to connect and which metrics actually matter for your team's goals. Once running, the no-code Explore interface lets analysts build, test, and iterate on visualizations without waiting on engineering support.