Apache Superset Masterclass: Build Modern Bi Dashboards
Published 5/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.81 GB | Duration: 6h 33m
Create powerful, interactive dashboards and visualizations with the open-source Apache Superset BI platform
What you'll learn
Set up connections to databases like PostgreSQL, MySQL, Snowflake, BigQuery, etc., and understand dataset management.
Design and build dynamic dashboards with cross-filtering, tabs, custom layouts, and filters for business storytelling.
Leverage SQL Lab to write, save, and reuse SQL queries for more advanced data analysis.
Build a complete, interactive dashboard project that simulates a real business scenario in sales, marketing, or finance.
Step-by-step instructions to install Superset using Docker and alternative methods, with full configuration walkthroughs.
Requirements
Familiarity with tables, rows, columns, and basic SQL concepts
Description
Mastering Apache Superset: Build Modern BI DashboardsAre you looking for a fast, modern, and open-source alternative to expensive BI tools like Tableau or Power BI?Welcome to "Mastering Apache Superset" - your complete guide to building beautiful, interactive dashboards and unlocking insights with data, using one of the most popular open-source business intelligence platforms available today.Whether you're a data analyst, developer, data engineer, or just someone passionate about working with data, this course will help you turn raw data into meaningful, visual stories-without needing to be a coding expert.What This Course Covers:Module 1: Getting StartedWhat is Apache Superset and why it's gaining popularity in data teams globallyHow it fits into a modern data stackInstalling Superset using Docker (and alternatives if needed)Module 2: Connecting to Your DataSetting up connections to PostgreSQL, MySQL, DuckDB, etc.Creating and managing datasetsWriting SQL queries and building virtual datasetsModule 3: Visualizing Your DataExplore 30+ built-in chart typesConfigure filters, tooltips, custom metrics, and drilldownsBest practices for building clean and effective visualizationsModule 4: Dashboards That Tell a StoryCombine multiple charts into dynamic dashboardsCross-filtering, interactivity, and layout customizationSharing, exporting, and embedding dashboards in other platformsModule 5: SQL Lab for AnalystsUse SQL Lab to write, save, and reuse queriesAnalyze large datasets directly in the browserIntegrate SQL Lab outputs into dashboardsModule 6: User Access & SecurityRole-based access control (RBAC)Implementing row-level security (RLS)Managing users, permissions, and team collaborationModule 7: Superset AdministrationUnderstanding Superset's architectureConfiguring performance and cachingDeployment options for production environmentsBy the End of This Course, You'll Be Able To:Confidently install, configure, and use Apache Superset for business intelligenceCreate visually compelling dashboards that tell clear, actionable storiesWork with real databases and datasets in a highly interactive environmentShare your insights with decision-makers or clients through intuitive visuals
Overview
Section 1: Introduction
Lecture 1 Introduction to Apache Superset
Lecture 2 What is Apache Superset?
Lecture 3 Key Features and Capabilities
Lecture 4 Superset vs Other BI Tools
Section 2: Installation and Setup
Lecture 5 Installing Superset using Docker (Recommended)
Lecture 6 Installing Superset using Python
Lecture 7 Understanding Superset Architecture
Section 3: Superset UI Walkthrough
Lecture 8 Navigating the Superset Interface
Lecture 9 Understanding Roles and Permissions
Section 4: Data Connection and Dataset Creation
Lecture 10 Connecting to Databases (PostgreSQL)
Lecture 11 Connecting to Databases (DuckDB)
Lecture 12 Connecting to Databases (MySQL)
Lecture 13 Base Table Introduction
Lecture 14 Course Materials
Section 5: SQL Basics
Lecture 15 Installation on Mac
Lecture 16 Installation on Windows
Lecture 17 Database & Schema
Lecture 18 Create Base Tables
Lecture 19 Insert into Tables
Lecture 20 Create and Drop Tables
Lecture 21 Select Columns
Lecture 22 Experiments: Select (Without Tables)
Lecture 23 Experiments: Mathematical Expression
Lecture 24 Distinct
Lecture 25 Experiments: Distinct
Lecture 26 Aggregate Functions
Lecture 27 String Functions
Lecture 28 Sub-Strings
Lecture 29 Concat
Lecture 30 Limit & Offset
Lecture 31 Alias
Lecture 32 Filters with Numeric
Lecture 33 Filters with String
Lecture 34 Filters with Date
Lecture 35 IN Clause
Lecture 36 Cast: Decimal & Integers
Lecture 37 Like
Lecture 38 Default Values
Lecture 39 Inner Queries
Lecture 40 Inner Queries: Any & ALL
Lecture 41 Union
Lecture 42 Union All
Lecture 43 Intersect
Lecture 44 Group By
Lecture 45 Group By with Having
Lecture 46 Group By with Filters
Lecture 47 Order By
Lecture 48 Order By with Filters
Section 6: SQL Lab
Lecture 49 Writing and Saving SQL Queries
Lecture 50 Creating Datasets
Lecture 51 Save Custom Datasets
Section 7: Exploring and Visualizing Data
Lecture 52 Charts Architecture
Lecture 53 Charts GUI walk through
Lecture 54 First Chart on Big Number
Lecture 55 Create Table using Charts
Lecture 56 Active Products using Big Number
Lecture 57 Applying Ordering on Chart
Lecture 58 Customization on Charts
Lecture 59 Create Virtual Dataset
Lecture 60 Line Line Chart with Virtual Dataset
Section 8: Applying Filters & Conditions
Lecture 61 Filter Introduction Screen
Lecture 62 Applying Filters on Integer
Lecture 63 Appying Filters on String Fields
Lecture 64 Like Filtering on String Fields
Lecture 65 IN Clause Filtering
Lecture 66 Between Clause Filtering
Lecture 67 Chart Customization and Formatting
Lecture 68 Number Formatting on Charts
Section 9: Dashboards
Lecture 69 Adding Filters, Tabs, and Layouts
Lecture 70 Cross-filtering Between Charts
Lecture 71 Filters with Dividers on Dashboard
Lecture 72 Pagination in Table using Dashboard
Lecture 73 Human Readable Column Names
Lecture 74 Assign Permissions to new User
Section 10: Advanced Features
Lecture 75 Row-level Security (RLS)
Lecture 76 Row-level Security (RLS)
Section 11: Superset Administration
Lecture 77 Config File and Environment Variables
Lecture 78 Installation of Production Environment
Lecture 79 Performance Optimization
Lecture 80 Backup and Restore
Lecture 81 Logging and Monitoring
Data Analysts and Business Intelligence Professionals,Data Engineers and Developers,Anyone Exploring Alternatives to Tableau, Power BI, or Looker
Screenshots
Download link
rapidgator.net:
https://rapidgator.net/file/f649406692d ... 1.rar.html
https://rapidgator.net/file/1e6cf6d1125 ... 2.rar.html
nitroflare.com:
https://nitroflare.com/view/25FCABC3829 ... .part1.rar
https://nitroflare.com/view/BB7F0727C5F ... .part2.rar