Getting Started with Apache Superset Training Course

1. Introduction to Apache Superset

• Defining Apache Superset.
• The position of Superset in modern Business Intelligence (BI).
• Comparing Superset with traditional BI platforms.
• Highlighting key features and capabilities.
• Exploring typical use cases and business scenarios.
• An overview of the Superset ecosystem.

2. Apache Superset Architecture and Environment Setup

• Understanding the architecture of Apache Superset.
• Core components:
  • Web application
  • Metadata database
  • Visualisation layer
  • Security layer
• Installing Apache Superset.
• Running Superset via containers.
• Configuring development and production environments.
• Overview of the user interface.
• Navigating Superset workspaces.

3. Managing Users, Roles, and Security

• User management.
• Role-Based Access Control (RBAC).
• Permissions and security frameworks.
• Controlling access to datasets and dashboards.
• Establishing secure BI environments.
• Best practices for enterprise-level deployments.

4. Connecting Data Sources

• Identifying supported data sources.
• Connecting relational databases:
  • PostgreSQL
  • MySQL
  • SQL Server
  • Oracle
• Linking cloud-based databases.
• Configuring database connections.
• Managing datasets.
• Testing and resolving data connection issues.

5. Working with Datasets and Data Preparation

• Concepts of datasets within Superset.
• Generating datasets from databases.
• Defining columns and metrics.
• Creating calculated columns.
• Utilising SQL-based datasets.
• Best practices for data preparation.
• Optimising datasets for analytical purposes.

6. Exploring and Analyzing Data

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

7. Creating Data Visualizations

• Overview of Superset’s visualisation options.
• Creating charts:
  • Bar charts
  • Line charts
  • Pie charts
  • Tables
  • Heatmaps
  • Geographic visualisations
  • Time-series charts
• Customising visualisation settings.
• Formatting charts for business users.
• Enhancing data storytelling.

8. Advanced Visualization Techniques

• Building interactive visualisations.
• Utilising filters and controls.
• Working with calculated metrics.
• Advanced chart configurations.
• Combining multiple analytical perspectives.
• Optimising visualisation performance.

9. Building Dashboards

• Principles of dashboard design.
• Creating dashboards from charts.
• Arranging dashboard layouts.
• Adding interactive filters.
• Designing business-focused dashboards.
• Sharing dashboards with users.
• Exporting and presenting reports.

10. SQL Integration with Apache Superset

• Introduction to SQL Lab.
• Writing SQL queries.
• Creating virtual datasets.
• Using SQL for advanced analysis.
• Query optimisation.
• Working with joins and complex queries.
• Managing SQL-based analytics workflows.

11. Advanced Analytics and Reporting

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

12. Performance Optimization

• Working with large datasets.
• Query performance optimisation.
• Database-side optimisation.
• Caching strategies.
• Managing dashboard loading times.
• Best practices for scalable deployments.

13. Troubleshooting and Administration

• Common installation issues.
• Database connection problems.
• 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.