Apache Superset: Understanding Datasets (Your First Step to Powerful Dashboards)

  

In this part of the Apache Superset learning series, we dive into one of the most fundamental building blocks of data visualization, i.e, Datasets. Before creating charts and dashboards, it’s essential to understand how Superset structures and prepares data for analysis.

 

What is a Dataset?

In simple terms, a dataset in Superset is a table, view, or a SQL query result that acts as a source for building charts and dashboards. Dataset sit between your raw database and your visualizations, making it easier to analyze and present data.

 

How to Create a Dataset?

Before creating a dataset, ensure your database is already connected to Superset (e.g., PostgreSQL). Once that’s ready, go to Datasets tab from the top menu.

 

Click on “+ Dataset” (top-right corner).

 

Here:

·      Select your Database connection

·      Choose the Schema (e.g., public in PostgreSQL)

·      Pick the Table (e.g., orders)

 

Click on ‘Create dataset’ button available at bottom right corner.

 

Upon successful creation of the dataset, you will be navigated to the Datasets listing page.

 

You can reuse it to build multiple charts and dashboards. This means, one dataset and multiple visualizations.

 

Datasets are not just a technical step, they are a design layer that shapes how effectively you can build insights.

Previous                                                    Next                                                    Home