Apache Superset Administrators Training in Copenhagen, Denmark

This course provides administrators with in-depth knowledge of Apache Superset, an open-source data exploration and visualization platform. It focuses on the administrative tasks involved in deploying, configuring, securing, and maintaining Superset in production environments. Participants will learn to integrate Superset with databases, manage users and roles, configure authentication mechanisms, and monitor system performance to ensure seamless BI operations.

Introduction and Architecture

• Introduction to Apache Superset and its ecosystem

• Use cases in enterprise and public BI

• Superset architecture: frontend, backend, metadata database

• Overview of supported databases and data engines

Installation and Configuration

• Superset installation using Python virtualenv and Docker

• Initial configuration and setting up the metadata DB

• Understanding superset_config.py

• Superset CLI and basic commands

Database Integration and Data Sources

• Connecting to SQL databases (PostgreSQL, MySQL, etc.)

• Working with SQLAlchemy connection strings

• Creating and managing datasets

• Troubleshooting connectivity issues

Security and User Management

• User and role management (RBAC)

• Authentication methods: DB, OAuth, LDAP, SAML

• Permission management: dashboards, slices, datasets

• Customizing user onboarding workflows

Customization and Performance

• Theming Superset for branding

• Performance tuning and caching strategies

• Setting up Celery and Redis for async operations

• Log files, error handling, and troubleshooting

Monitoring, Scaling, and Maintenance

• Monitoring metrics (Prometheus, Grafana)

• Backup strategies for metadata database

• Scaling Superset with Docker Compose and Kubernetes

• High availability considerations

Hands-on Exercises

Summary and Conclusion