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. Overview of Apache Superset
- Defining Apache Superset
- The function of Superset in contemporary Business Intelligence (BI)
- Benchmarking against conventional BI platforms
- Principal features and capabilities
- Standard use cases and commercial applications
- Survey of the Superset ecosystem
2. Superset Architecture and Environment Configuration
- Architectural overview of Apache Superset
- Essential components:
- Web application
- Metadata database
- Visualization layer
- Security layer
- Installation procedures for Apache Superset
- Executing Superset via containerized environments
- Setting up development and production contexts
- Introduction to the user interface
- Navigating Superset workspaces
3. Administration of Users, Roles, and Security
- User management protocols
- Role-based access control (RBAC)
- Permission structures and security frameworks
- Regulating access to datasets and dashboards
- Establishing secure BI environments
- Optimal practices for enterprise-scale deployments
4. Establishing Data Source Connections
- Identification of supported data sources
- Linking relational databases:
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- Connecting to cloud-hosted databases
- Configuring database connections
- Dataset administration
- Verification and troubleshooting of data links
5. Dataset Management and Data Preparation
- Comprehending datasets within Superset
- Generating datasets from database sources
- Specifying columns and metrics
- Developing calculated columns
- Leveraging SQL-based datasets
- Best practices for data preparation
- Optimizing datasets for analytical purposes
6. Data Exploration and Analysis
- Utilizing the Explore interface
- Data filtering and slicing techniques
- Formulating custom queries
- Selection of suitable visualization types
- Conducting exploratory data analysis
- Distinguishing between metrics and dimensions
- Handling large-scale datasets
7. Developing Data Visualizations
- Survey of Superset visualization options
- Chart creation:
- Bar charts
- Line charts
- Pie charts
- Tables
- Heatmaps
- Geographic visualizations
- Time-series charts
- Adjusting visualization parameters
- Formatting charts for business stakeholders
- Enhancing data storytelling
8. Sophisticated Visualization Methods
- Development of interactive visualizations
- Implementation of filters and controls
- Application of calculated metrics
- Advanced chart configurations
- Integration of multiple analytical viewpoints
- Optimization of visualization performance
9. Dashboard Construction
- Principles of dashboard design
- Assembling dashboards from individual charts
- Structuring dashboard layouts
- Incorporation of interactive filters
- Creating dashboards oriented toward business objectives
- Distribution of dashboards to users
- Export and presentation of reports
10. SQL Integration with Apache Superset
- Introduction to SQL Lab
- Composition of SQL queries
- Creation of virtual datasets
- Application of SQL for advanced analysis
- Query optimization techniques
- Utilization of joins and complex queries
- Oversight of SQL-driven analytical workflows
11. Advanced Analytics and Reporting
- Formulation of KPIs and business metrics
- Trend analysis
- Comparative analysis
- Time-based reporting
- Construction of executive dashboards
- Scheduling and dissemination of reports
- Facilitating data-driven decision-making
12. Performance Optimization
- Management of large-scale datasets
- Optimization of query performance
- Database-side optimization strategies
- Implementation of caching techniques
- Regulation of dashboard loading durations
- Best practices for scalable deployments
13. Troubleshooting and System Administration
- Resolution of frequent installation challenges
- Addressing database connection issues
- Debugging visualization anomalies
- Oversight of Superset configuration
- Performance monitoring of Superset
- Maintenance of production environments
14. Practical Workshop and Conclusion
- Linking Apache Superset to a database
- Dataset creation
- Construction of interactive visualizations
- Development of a comprehensive dashboard
- Application of security and sharing settings
- Assessment of best practices
- Question and answer session
- Pathways for advanced usage of Apache Superset
Requirements
- Familiarity with business intelligence and data visualization practices.
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
