Getting Started with Apache Superset Training Course

1. Introduction to Apache Superset

• What is Apache Superset?
• The role of Superset in contemporary Business Intelligence (BI)
• Contrasting Superset with legacy BI platforms
• Primary features and functionalities
• Common use cases and business contexts
• An overview of the Superset ecosystem

2. Apache Superset Architecture and Environment Setup

• Summary of Apache Superset architecture
• Core components:
  • Web application
  • Metadata database
  • Visualisation layer
  • Security layer
• Installing Apache Superset
• Running Superset via containers
• Configuring development and production environments
• User interface walkthrough
• Navigating Superset workspaces

3. Managing Users, Roles, and Security

• User administration
• Role-based access control (RBAC)
• Permissions and security frameworks
• Controlling access to datasets and dashboards
• Establishing secure BI environments
• Best practices for enterprise-grade deployments

4. Connecting Data Sources

• Understanding supported data sources
• Connecting to relational databases:
  • PostgreSQL
  • MySQL
  • SQL Server
  • Oracle
• Linking cloud-based databases
• Database connection settings
• Dataset management
• Testing and resolving data connection issues

5. Working with Datasets and Data Preparation

• Understanding datasets within Superset
• Creating datasets from database sources
• Defining columns and metrics
• Generating calculated columns
• Utilising SQL-based datasets
• Best practices for data preparation
• Optimising datasets for analytical purposes

6. Exploring and Analysing Data

• Utilising the Explore interface
• Filtering and slicing data
• Authoring custom queries
• Selecting suitable visualisation types
• Conducting exploratory data analysis
• Understanding metrics and dimensions
• Handling large datasets

7. Creating Data Visualisations

• Overview of Superset visualisation options
• Creating charts:
  • Bar charts
  • Line charts
  • Pie charts
  • Tables
  • Heatmaps
  • Geographic visualisations
  • Time-series charts
• Tailoring visualisation settings
• Formatting charts for business audiences
• Enhancing data storytelling

8. Advanced Visualisation Techniques

• Building interactive visualisations
• Implementing filters and controls
• Utilising calculated metrics
• Advanced chart configurations
• Combining multiple analytical views
• Optimising visualisation performance

9. Building Dashboards

• Dashboard design principles
• Constructing dashboards from charts
• Organising dashboard layouts
• Adding interactive filters
• Developing business-oriented dashboards
• Sharing dashboards with users
• Exporting and presenting reports

10. SQL Integration with Apache Superset

• SQL Lab overview
• Writing SQL queries
• Creating virtual datasets
• Leveraging SQL for advanced analysis
• Query optimisation
• Working with joins and complex queries
• Managing SQL-based analytics workflows

11. Advanced Analytics and Reporting

• Defining KPIs and business metrics
• Trend analysis
• Comparative analysis
• Time-based reporting
• Creating executive dashboards
• Scheduling and distributing reports
• Supporting data-driven decision-making

12. Performance Optimisation

• Handling large datasets
• Optimising query performance
• Database-side optimisation
• Caching strategies
• Managing dashboard loading speeds
• Best practices for scalable deployments

13. Troubleshooting and Administration

• Common installation challenges
• Database connection difficulties
• Debugging visualisation errors
• Managing Superset configuration
• Monitoring Superset performance
• Maintaining production environments

14. Hands-on Workshop and Summary

• Connecting Apache Superset to a database
• Creating datasets
• Building interactive visualisations
• Developing a complete dashboard
• Applying security and sharing settings
• Reviewing best practices
• Questions and answers
• Next steps for advanced Apache Superset usage