Skip to main content

How to make a simple Dashboard with Apache Superset (Part 2)

Son Nguyen
Software Engineer

In the previous article How to make a simple Dashboard with Apache Superset (Part 1), I instructed how to connect your Datasource to Superset. In today's article, I will start exploiting data from my data source by designing vivid Charts and Dashboards.

1. Create Dataset from Datasource

After successfully connecting from Superset to our data source, we need to create Dataset.

Select the Datasets menu right above the main screen

When opened, you will see all the current Datasets in the system. Click on the + Dataset button to add a new dataset.

The Superset's dataset must come from a table, view under your Datasource, or you can also create a Dataset from a test query on SQLab. Then click Create dataset and create chart

2. Create a Dashboard and chart from the dataset

After creating a Dataset, the system will transfer you to the page to create charts. Here, you will choose a chart that is suitable for your data source. The simplest way is to choose Table. After selecting, click Create new chart

Next, for any chart, you must select Dimension and Metric, depending on each chart, there are mandatory requirements. Here I will choose to list a table with the desired fields.

Finally, click Save, and select the Dashboard you want to display the chart on (if the Dashboard does not exist, the system will create a Dashboard and embed the Chart). Click Save & Go to Dashboard

So, you have created a professional Dashboard.