Course Code: apasupsetonedaybesp
Duration: 7 hours
Course Outline:

1. Installation and Configuration of Apache Superset 

◦ Docker versus installation from source

◦ Apache Superset Building blocks and configuration options

◦ How to build a good development environment (e.g., git, versioning, assets as code)

◦ Superset for high-loads and many tenants

2. Architecture and Functions of Apache Superset 

◦ Detailed examination of the architecture

◦ Main Libraries and where to find information

◦ Overview of the user interface and the main components

3. Connecting and Managing Data Sources 

◦ Physical- vs virtual datasets

◦ Connecting a local data store (CSV) for ad hoc examination and data viewing

◦ Connecting other data sources (SQL databases, Google sheets, cloud storage, etc.)

◦ Setting permissions and abilities on data sources

◦ Metrics and Calculated Columns (the semantic layer)

4. Data Exploration and Visualization Techniques 

◦ Creation and customization of charts

◦ Interactive dashboards. Filtering and Drill-Downs

◦ Automation of reports and notifications

◦ Design- and Customisation aspects

◦ Embedding Superset

5. Analysis Functions and SQL Integration

◦ Using SQL Lab functions for complex queries

◦ Integration of SQL analyses into dashboards

◦ Jinja Templating

◦ Scheduled queries

6. User- and Data Access management

◦ Role-based access control

◦ Row-level security

7. REST-API and the CLI

◦ programmatic access to Superset assets

◦ managing superset assets as code - the Superset CLI

◦ templating inside YAML-files

◦ some aspects regarding the separation of development- and production environments