What you'll learn:
- Grasp what Superset is, its key components, and how it fits into the modern BI ecosystem.
- Learn how to install and run Superset locally with Docker, managing containers, networks, and volumes.
- Explore the UI, Integrate Superset with databases like Snowflake, and design insightful dashboards.
- Configure themes, Implement Row-Level Security, Jinja templating, and CSS, and layouts to align Superset’s appearance with your organisation’s identity.
- Configure and launch Superset on AWS using ECS, RDS, and Redis for production use.
Welcome to "Apache Superset: From Zero to Hero with Docker and AWS"!
This hands-on course is designed to take you from your very first dashboard to a fully deployed production environment in the cloud.
Apache Superset is one of the fastest-growing open-source BI platforms used by data teams worldwide. Whether you're a Data Analyst, BI Developer, or Data Engineer, this course will guide you step by step through installation, configuration, dashboard building, customization, and enterprise-grade deployment.
By the end of the course, you’ll be able to:
Install and run Superset locally using Docker
Build interactive dashboards and visualizations
Connect to databases like PostgreSQL and Snowflake
Customize Superset to match your brand
Implement advanced features such as Jinja templating, Row Level Security, and custom styling
Set up alerts, reports, and background task processing
Deploy your Superset environment on AWS with production-ready components
This course focuses on real-world examples, clear explanations, and practical demonstrations - no unnecessary theory, just the knowledge you need to become confident with Apache Superset.
Section 1: Introduction
Get to know the course, its audience, and what tools we’ll use.
Meet your instructor and understand course goals
Learn who this course is for and what to expect
Review the setup and tools required
Section 2: Overview
Understand Superset’s architecture and how it compares with other BI tools.
Explore Superset’s core components and data flow
Compare Superset with Tableau, Power BI, and Looker
Learn about different installation options
Section 3: Docker Introduction
Build the foundation to run Superset locally using Docker.
Learn what containers, images, and volumes are
Understand Docker Compose and how services interact
Section 4: Getting Started with Superset
Dive into the Superset UI and learn its core capabilities.
Explore dashboards, datasets, and visualizations
Understand the navigation and main features
Discover how Superset organizes data sources
Section 5: Building the COVID-19 Dashboard
Create your first interactive dashboard using real data.
Connect Superset to a database
Build and configure visualizations step by step
Assemble and publish your first dashboard
Section 6: Superset 5.0 & 6.0 Updates
A newly added chapter that introduces key updates from newer versions of Superset.
Configure newer superset versions
Dive into AntD theming for in-depth customisation
Learn new Jinja capabilities and visualisations
Section 7: Customization
Make Superset reflect your brand and style.
Change logos, colors, and themes
Section 8: Snowflake Dashboard
Work with a cloud data source and advanced filters.
Connect Superset to Snowflake
Explore datasets and build a new dashboard
Learn Superset filtering in detail
Section 9: Advanced Features
Unlock Superset’s most powerful capabilities.
Use Jinja templating for dynamic queries
Implement Row Level Security (RLS)
Manage roles and permissions
Add custom CSS styling
Section 10: Alerts & Reports
Enable automated reports and notifications in Superset.
Set up Celery and Redis for async tasks
Configure email alerts and report scheduling
Understand production-level configuration needs
Section 11: AWS Deployment
Deploy Superset in the cloud like a pro using IaC approach.
Set up Superset on AWS ECS Fargate
Integrate with RDS PostgreSQL and Redis
Ensure scalability, reliability, and secure access