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.
Duration 14 hours
Course Outline
1. Introduction to Apache Superset
- Definition of Apache Superset
- The role of Superset in contemporary Business Intelligence (BI)
- Comparison against traditional BI platforms
- Core features and capabilities
- Typical use cases and business scenarios
- Overview of the Superset ecosystem
2. Apache Superset Architecture and Environment Setup
- Understanding Apache Superset architecture
- Core components:
- Web application
- Metadata database
- Visualization layer
- Security layer
- Installation of Apache Superset
- Running Superset via containers
- Configuration of development and production environments
- User interface overview
- Navigating Superset workspaces
3. Managing Users, Roles, and Security
- User management
- Role-based access control (RBAC)
- Permissions and security models
- Controlling access to datasets and dashboards
- Establishing secure BI environments
- Best practices for enterprise deployments
4. Connecting Data Sources
- Reviewing supported data sources
- Connecting to relational databases:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Connecting to cloud-based databases
- Database connection setup
- Dataset management
- Testing and troubleshooting data connections
5. Working with Datasets and Data Preparation
- Understanding datasets within Superset
- Creating datasets from existing databases
- Defining columns and metrics
- Generating calculated columns
- Utilizing SQL-based datasets
- Best practices for data preparation
- Optimizing datasets for analysis
6. Exploring and Analyzing Data
- Using the Explore interface
- Filtering and slicing data
- Developing custom queries
- Selecting suitable visualization types
- Conducting exploratory data analysis
- Understanding metrics and dimensions
- Handling large datasets
7. Creating Data Visualizations
- Overview of Superset visualization options
- Creating charts:
- Bar charts
- Line charts
- Pie charts
- Tables
- Heatmaps
- Geographic visualizations
- Time-series charts
- Customizing visualization settings
- Formatting charts for business audiences
- Enhancing data storytelling
8. Advanced Visualization Techniques
- Developing interactive visualizations
- Implementing filters and controls
- Utilizing calculated metrics
- Advanced chart configuration
- Combining multiple analytical perspectives
- Optimizing visualization performance
9. Building Dashboards
- Dashboard design principles
- Assembling dashboards from charts
- Structuring dashboard layouts
- Incorporating interactive filters
- Creating business-centric dashboards
- Sharing dashboards with users
- Exporting and presenting reports
10. SQL Integration with Apache Superset
- Overview of SQL Lab
- Writing SQL queries
- Generating virtual datasets
- Leveraging SQL for advanced analysis
- Query optimization
- 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
- Building executive dashboards
- Scheduling and distributing reports
- Supporting data-driven decision-making
12. Performance Optimization
- Handling large datasets
- Optimizing query performance
- Database-side optimizations
- Caching strategies
- Managing dashboard load times
- Best practices for scalable deployments
13. Troubleshooting and Administration
- Common installation challenges
- Database connection issues
- Debugging visualization errors
- Managing Superset configuration
- Monitoring Superset performance
- Maintaining production environments
14. Hands-on Workshop and Summary
- Linking Apache Superset to a database
- Creating datasets
- Building interactive visualizations
- Developing a complete dashboard
- Applying security and sharing configurations
- Reviewing best practices
- Questions and answers
- Next steps for advanced Apache Superset usage
Requirements
- Prior experience with business intelligence and data visualization.
Target Audience
- Data analysts
- Data scientists
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
