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
- Defining Apache Superset
- The role of Superset in contemporary Business Intelligence (BI)
- Differentiating from traditional BI platforms
- Highlighting key features and capabilities
- Common use cases and business scenarios
- A glimpse into the Superset ecosystem
2. Apache Superset Architecture and Environment Setup
- Understanding the Apache Superset architecture
- Core components:
- Web application
- Metadata database
- Visualization layer
- Security layer
- Installing Apache Superset
- Operating Superset via containers
- Setting up development and production environments
- Familiarizing with the user interface
- Navigating through Superset workspaces
3. Managing Users, Roles, and Security
- User management strategies
- Implementing Role-based access control (RBAC)
- Understanding permissions and security models
- Controlling access to datasets and dashboards
- Establishing secure BI environments
- Adhering to best practices for enterprise deployments
4. Connecting Data Sources
- Gathering insights on supported data sources
- Connecting relational databases:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Linking cloud-based databases
- Configuring database connections
- Managing datasets effectively
- Testing and troubleshooting data connections
5. Working with Datasets and Data Preparation
- Comprehending datasets within Superset
- Generating datasets from databases
- Defining columns and metrics
- Developing calculated columns
- Leveraging SQL-based datasets
- Adopting data preparation best practices
- Optimizing datasets for analysis
6. Exploring and Analyzing Data
- Navigating the Explore interface
- Filtering and slicing data efficiently
- Formulating custom queries
- Selecting suitable visualization types
- Conducting exploratory data analysis
- Gaining clarity on metrics and dimensions
- Handling large datasets proficiently
7. Creating Data Visualizations
- Overview of Superset's visualization options
- Constructing charts:
- Bar charts
- Line charts
- Pie charts
- Tables
- Heatmaps
- Geographic visualizations
- Time-series charts
- Tailoring visualization settings
- Formatting charts for business users
- Enhancing data storytelling techniques
8. Advanced Visualization Techniques
- Developing interactive visualizations
- Utilizing filters and controls
- Working with calculated metrics
- Tweaking advanced chart configurations
- Integrating multiple analytical perspectives
- Optimizing visualization performance
9. Building Dashboards
- Principles of dashboard design
- Assembling dashboards from charts
- Arranging dashboard layouts creatively
- Incorporating interactive filters
- Designing business-focused dashboards
- Distributing dashboards to users
- Exporting and presenting reports
10. SQL Integration with Apache Superset
- Overview of SQL Lab
- Writing SQL queries effectively
- Creating virtual datasets
- Leveraging SQL for advanced analysis
- Omitting query optimization
- Mastering joins and complex queries
- Overseeing SQL-based analytics workflows
11. Advanced Analytics and Reporting
- Developing KPIs and business metrics
- Conducting trend analysis
- Performing comparative analysis
- Executing time-based reporting
- Constructing executive dashboards
- Scheduling and sharing reports seamlessly
- Fostering data-driven decision-making
12. Performance Optimization
- Handling large datasets efficiently
- Optimizing query performance
- Implementing database-side optimization
- Employing caching strategies
- Reducing dashboard loading times
- Following best practices for scalable deployments
13. Troubleshooting and Administration
- Addressing common installation issues
- Solving database connection problems
- Debugging visualization errors
- Superset configuration management
- Monitoring Superset performance
- Maintaining production environments robustly
14. Hands-on Workshop and Summary
- Connecting Apache Superset to a database
- Establishing datasets
- Constructing interactive visualizations
- Developing a comprehensive dashboard
- Applying security and sharing settings
- Reviewing established best practices
- Addressing questions and answers
- Identifying next steps for advanced Apache Superset usage
Requirements
- Proficiency in business intelligence and data visualization.
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
