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
- Defining Apache Superset
- The function of Superset within modern Business Intelligence (BI)
- Contrasting Superset with conventional BI platforms
- Core features and functional capabilities
- Common use cases and commercial applications
- An overview of the Superset ecosystem
2. Apache Superset Architecture and Environment Setup
- Architectural overview of Apache Superset
- Essential components:
- Web application layer
- Metadata database
- Visualization layer
- Security layer
- Installation procedures for Apache Superset
- Deployment via containers
- Configuration for development and production contexts
- User interface walkthrough
- Navigating the Superset workspace
3. Managing Users, Roles, and Security
- User administration
- Role-based access control (RBAC)
- Security models and permission structures
- Controlling access to datasets and dashboards
- Establishing secure BI environments
- Best practices for enterprise-grade deployments
4. Connecting Data Sources
- Overview of supported data origins
- Linking relational databases:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Integration with cloud-based databases
- Configuring database connections
- Dataset management strategies
- Testing and diagnosing data connections
5. Working with Datasets and Data Preparation
- Conceptual understanding of Superset datasets
- Generating datasets from database tables
- Defining columns and business metrics
- Creating derived columns
- Utilizing SQL-based datasets
- Best practices for data preparation
- Optimizing datasets for analytical purposes
6. Exploring and Analyzing Data
- Utilizing the Explore interface
- Filtering and slicing data views
- Formulating custom queries
- Selecting suitable visualization formats
- Conducting exploratory data analysis
- Understanding the distinction between metrics and dimensions
- Handling large datasets effectively
7. Creating Data Visualizations
- Survey of Superset's visualization suite
- Chart creation:
- Bar charts
- Line charts
- Pie charts
- Tabular views
- Heatmaps
- Geographic visualizations
- Time-series graphs
- Adjusting visualization parameters
- Formatting charts for business stakeholders
- Enhancing data storytelling techniques
8. Advanced Visualization Techniques
- Developing interactive visual elements
- Implementing filters and control widgets
- Utilizing calculated metrics
- Advanced chart configuration options
- Integrating multiple analytical perspectives
- Optimizing visualization performance
9. Building Dashboards
- Principles of effective dashboard design
- Assembling dashboards from individual charts
- Structuring dashboard layouts
- Incorporating interactive filters
- Designing dashboards focused on business KPIs
- Distributing dashboards to users
- Exporting and presenting reports
10. SQL Integration with Apache Superset
- Introduction to SQL Lab
- Composing SQL queries
- Generating virtual datasets
- Leveraging SQL for advanced analytics
- Optimizing query performance
- Handling joins and complex query structures
- Orchestrating SQL-based analytical workflows
11. Advanced Analytics and Reporting
- Establishing KPIs and business metrics
- Conducting trend analysis
- Performing comparative analysis
- Time-based reporting methods
- Designing executive-level dashboards
- Scheduling and distributing reports
- Facilitating data-driven decision processes
12. Performance Optimization
- Managing large-scale datasets
- Optimizing query execution speed
- Database-side optimization techniques
- Implementing caching strategies
- Improving dashboard load times
- Best practices for scalable architecture
13. Troubleshooting and Administration
- Resolving common installation challenges
- Addressing database connection issues
- Diagnosing visualization errors
- Managing Superset configuration files
- Monitoring system performance
- Maintaining production environments
14. Hands-on Workshop and Summary
- Connecting Apache Superset to a live database
- Creating operational datasets
- Constructing interactive visualizations
- Building a comprehensive dashboard
- Applying security protocols and sharing rules
- Reviewing key best practices
- Q&A Session
- Recommendations for advanced Apache Superset usage
Requirements
- Professional experience in 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
