Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
1. Introduction to Apache Superset
- An overview of Apache Superset
- The role of Superset in modern Business Intelligence (BI)
- Comparison with conventional BI platforms
- Core features and capabilities
- Common use cases and business scenarios
- Introduction to the Superset ecosystem
2. Apache Superset Architecture and Environment Setup
- Architectural overview of Apache Superset
- Core components:
- Web application
- Metadata database
- Visualisation layer
- Security layer
- Installing Apache Superset
- Executing Superset via containers
- Setting up development and production environments
- Overview of the user interface
- Navigating Superset workspaces
3. Managing Users, Roles, and Security
- User administration
- Role-Based Access Control (RBAC)
- Permission structures and security models
- Controlling access to datasets and dashboards
- Establishing secure BI environments
- Best practices for enterprise-grade deployments
4. Connecting Data Sources
- Understanding supported data sources
- Linking to relational databases:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Connecting to cloud-based databases
- Configuring database connections
- Managing datasets
- Testing and troubleshooting data links
5. Working with Datasets and Data Preparation
- Understanding datasets within Superset
- Creating datasets from databases
- Defining columns and metrics
- Creating calculated columns
- Utilising SQL-based datasets
- Data preparation best practices
- Optimising datasets for analysis
6. Exploring and Analyzing Data
- Utilising the Explore interface
- Filtering and slicing data
- Writing custom queries
- Selecting appropriate visualisation types
- Conducting exploratory data analysis
- Understanding metrics and dimensions
- Handling large datasets
7. Creating Data Visualizations
- Overview of Superset visualisation options
- Creating charts:
- Bar charts
- Line charts
- Pie charts
- Tables
- Heatmaps
- Geographic visualisations
- Time-series charts
- Customising visualisation settings
- Formatting charts for business stakeholders
- Enhancing data storytelling
8. Advanced Visualization Techniques
- Building interactive visualisations
- Applying filters and controls
- Working with calculated metrics
- Advanced chart configurations
- Combining multiple analytical perspectives
- Optimising visualisation performance
9. Building Dashboards
- Dashboard design principles
- Creating dashboards from charts
- Arranging dashboard layouts
- Adding interactive filters
- Creating business-focused dashboards
- Sharing dashboards with users
- Exporting and presenting reports
10. SQL Integration with Apache Superset
- Overview of SQL Lab
- Writing SQL queries
- Creating virtual datasets
- Utilising 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
- Managing large datasets
- Query performance optimisation
- Database-side optimisation
- Caching strategies
- Managing dashboard load 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
Requirements
- Familiarity with business intelligence and data visualisation concepts.
Target Audience
- Data analysts
- Data scientists
14 Hours
Testimonials (7)
Gunnar was a great trainer. He pitched the training at the right level given the varying levels of experience and expertise of the attendees. He was very personable and injected as much as excitement and humour as he could across the 2 days. He made sure that we were engaged throughout and tried to ensure that all our questions were answered in an open and honest manner.
Seaman - PowerX Technology Ltd
Course - Getting Started with Apache Superset
Trainer cukup terbuka dalam sharing
Wilianto Wilianto - PT. Supra Matra Abadi
Course - Getting Started with Apache Superset
I like the exploration and visualisation
Vincent Kwenady - PT. Supra Matra Abadi
Course - Getting Started with Apache Superset
Instalasi dan Visualisasi data
Raihan Ahmad Bangun - PT. Supra Matra Abadi
Course - Getting Started with Apache Superset
I like how the trainer is very interactive with the audience and answers every question. He is also very helpful with aiding the audience.
Parnika Kaur - PT. Supra Matra Abadi
Course - Getting Started with Apache Superset
Flexibility and approach to different topics and questions addressed.
Marcin Bochniak - Nokia Solutions and Networks Sp. z o.o.
Course - Getting Started with Apache Superset
possibility to answer own questions, free discussion
