Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Apache Superset - Explore, Visualize ,Analyze - From Scratch

Name: Apache Superset - Explore, Visualize ,Analyze - From Scratch
Rating: 3.3 (6 reviews)

Installing and explore Apache Superset on both your local (with Docker) ,Kubernetes and Python-Production environment

Created byKaushik Thakkar

Last updated 12/2025

English

English [Auto],

What you'll learn

The core concepts of Data Engineering i.e. Difference between Data Exploration vs Data Visualization vs Data Analytics. With focus on Data Exploration
What is Apache Superset and how it is different from the paid BI tools like Tableau, Power BI and Looker
Understanding the Apache Superset Architecture in detail, focusing on the end to end flow between the components
Exploring Apache Superset in Detail understanding what is Dashboard, Charts, DataSets,SQLLabs,
Installing Superset on both Docker and Kubernetes

Course content

13 sections • 46 lectures • 8h 11m total length

Introduction to Data Exploration, Data Visualization and Data Analytics2:47
Data Exploration vs Data Visualization vs Data Analytics6:28
Explore how data exploration, visualization, and analytics interrelate in Apache Superset, using EDA and charts to understand data, communicate insights, and drive predictive and prescriptive decisions.
What is Business Intelligence2:10
Learn what business intelligence means and how software analyzes raw data through data mining, OLAP, and reporting to help businesses make intelligent decisions.
What is Apache Superset and its prominent features3:26
The history of Apache Superset3:36
Trace the history of Apache Superset from a hackathon project through incubation to a top-level Apache project, noting Panoramix and Caravelle, and highlighting Maxime Beauchemin, Airbnb, Lyft, and Dropbox.

UI Layout of the Superset -> Home Section1:33
UI Layout of the Superset -> The 4 tabs > Dashboards | Charts | Datasets | SQL4:38
Explore the Apache Superset user interface layout, including dashboards, charts, data sets, and sql lab, with preloaded examples, saved queries, and query history.
UI Layout of the Superset -> The "+" icon3:00
Discover how the plus icon in Apache Superset enables quick creation of data sets, charts, dashboards, and SQL queries, including uploading csv or Excel files and navigating between data views.
UI Layout of the Superset - > The Settings Section2:54

Working with Dashboards19:37
This section first explains you the Dashboard concept in general , and then explains how to create a Dashboard in Superset, what are the different options available when you create the Dashboard, how to customize your Dashboard in Superset
Working with Charts (1 chart will be made in this lecture, others covered later)26:27
This lecture first explains you the basic of the Charts, what are the Charts and what are the categories of the chart.It then walks you through the Charts section of Superset, how to create your first chart what are the different options available and how to send your chart to the Dashboard. It also shows you how to edit your first chart.
Working with Datasets16:34
Learn how datasets fuel Apache Superset, with each table serving as a dataset, and distinguish physical from virtual datasets while exploring them in SQL Lab.
Working with SQL (SQL Lab, Saved Queries and Queries History)16:30
How Dashboards, Charts, Datasets and SQL work End to End20:00

Understanding the Categories of Charting18:47
Making Evolution Charts in Superset - Bar Chart (Line Chart already covered)17:04
Create a bar chart in Apache Superset’s evolution charts from the birth names dataset, filter by year and state, and display boys and girls totals.
Making Correlation Charts in Superset (Heatmap)17:49
Making Map charts in Superset (deck.gl charts)21:17
How to make any chart of any category by just watching this video11:09
Explore how Apache Superset lets you learn, create and analyze charts and dashboards from free datasets, including covid vaccine dashboards, using bar, sunburst, treemap, heat map and world map visuals.

MySQL setup on Docker - Get image, Run Container, Make DB on mysql using CLI23:41
Install MySQL on docker, pull the latest image, and run a container to connect Apache Superset to a database. Use docker exec to create databases and tables via the cli.
Connecting Superset to MySQL which we have just setup on Docker10:04
Connect superset to mysql on docker, using the container ip, host, and port 3306 with root credentials. Verify the connection in sql lab and enable file uploads.
Connecting to Postgres (includes Postgres setup on Docker)19:47
Learn to connect Apache Superset to Postgres, set up Postgres on Docker, run containers, and verify connections using the sql lab and basic queries.
Uploading the Dataset through CSV (includes creating the csv file)16:03
Create a csv file, enable file uploads in superset, upload the csv to your database, name the table, and begin exploring the data with charts.

Making your own Custom Metrics (The first computed data of Superset Semantic Lay20:14
Create custom metrics in Apache Superset to compute data from your dataset using aggregations like average, count, distinct, max, min, and sum.
Making your own Calculated Columns (The 2nd computed data of the Semantic Layer)11:42
Create calculated columns in Apache Superset's semantic layer using a SQL case expression to classify tickets as costly or not, then apply the new column in charts to drive insights.
Notes0:23

Advanced Analytics > Rolling Mean6:56
Advanced Analytics > Time Comparison11:52
Advanced Analytics > Resampling the Data7:41
Explore advanced analytics in Apache Superset with resampling the data, using line charts and time grain to analyze weekly and calendar day totals, filtering October data and adjusting fill methods.
Adding the Annotation Layers20:03
Learn how to create and configure annotation layers in Apache Superset, apply event-based annotations to time series charts, and visualize why specific data points are highlighted.

Requirements

No programing experience needed. You will learn everything you need to know

Description

This course starts with the basics of Data Analytics world i.e. what is Data Exploration, Data Visualization and Data Analytics , how these 3 are closely related and what is the thin line between them. We explain what is Business Intelligence because Superset is widely used for Business Intelligence.

Then it shows how to install the superset with the help of Docker Desktop . We learn Docker Desktop installation steps as well.

We load the already available Examples in Superset, by following simple commands.

Once we are in Superset this course walks through each and every UI element in detail , explaining the end to end flow as well i.e. how Dashboarding <>Charting<>Dataset<>SQL work in tandem

We Learn the different charts in detail (first learning the categorization of charts)

We also learn how to connect to other Databases like Postgres and MySQL

We also upload our own dataset in form of Excel

We learn what is semantic layer and what are custom metrics and calculated columns.

We learn the Role Based Access System in Detail (with the local setup of Superset)

We learn how to setup some config settings, especially around how to enable the MapBox API and also how to setup the Max Row Limit.

Towards the end , I have also included how to setup Apache Superset on Kubernetes.

Finally a major block, if you are a DevOps or Tech Lead or anyone who wants to build a production like Environment , I have put the section on how to create a Superset - Production like environment using Python (and on Linux)

Who this course is for:

Data Enthusiasts, Freshers, Data Engineers, Data Scientists, Data Analysts, Business Analysts, Software Developers, Project Managers, Test Managers, Scrum Masters,Accountants, Share brokers, DevOps, Anybody who wants to learn a new subject

Apache Superset - Explore, Visualize ,Analyze - From Scratch

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 18min

Apache Superset - Features ,Architecture and the E2E flow of Data in Superset3 lectures • 19min

Apache Superset Setup2 lectures • 27min

Walkthrough of the Apache Superset which we have just setup4 lectures • 12min

In Detail understanding of Dashboards | Charts | Datasets | SQL5 lectures • 1hr 39min

Making Different Charts5 lectures • 1hr 26min

Connecting Apache Superset to Different Databases4 lectures • 1hr 10min

Making your own Custom Metrics, Calculated Columns and Custom Queries3 lectures • 32min

Advanced Analytics in Superset4 lectures • 47min

RBAC - Role Based Access Control in Superset2 lectures • 24min

Requirements

Description

Who this course is for: