Advanced Apache Superset
Overview:
Introduction
Apache Superset is an open-source, enterprise-ready business intelligence platform for data exploration and data visualization. Apache Superset is similar to enterprise business intelligence solutions, such as Power BI and Tableau, as opposed to other dashboarding software. This is due to its emphasis on data analytics and exploration, so bear this in mind if you are looking for a simple real-time dashboard solution.
Course Objectives
At the end of this course, participants will be able to:
- Install and configure Apache Superset.
- Implement advanced data analysis and visualization using Apache Superset.
- Customize and share dashboards and reports.
- Managing security in Apache Superset.
Targeted Audience
- Data analysts
- Data scientists
- Data engineers
Course Outline
Unit 1: Installing and Configuring Cloud-Native Apache Superset
- Using Docker to initialize development environment
- Using Python's setup tools and pip
Connecting Data to Apache Superset
- Configuring data input
- Improving the input process
Unit 2: Overview of Basic Features and Architecture of Apache Superset
- Rich visualizations
- Easy-to-navigate user interface
- Integration with most databases
Unit 3: Conducting Advanced Data Analytics
- Getting a rolling average of the time series
- Working with Time Comparison
- Resampling the data using various methods
- Scheduling queries in SQL Lab
Unit 4: Performing Advanced Visualization
- Creating a Pivot Table
- Exploring different visualization types
- Building a visualization plugin
Creating and Sharing Dynamic Dashboards
- Adding Annotations to Your Chart
- Using REST API
Unit 5:Integrating Apache Superset with Databases
- Apache Druid
- BigQuery
- SQL Server
Managing Security in Apache Superset
- Understanding provided roles and creating new roles
- Customizing permissions