Apache Superset Analytics

Build BI dashboards with Apache Superset. Generates dataset YAMLs, chart configs, dashboard exports, Jinja-templated SQL, RBAC roles, and Helm/Docker deployments for production analytics platforms.

This skill writes Superset assets: dataset YAML definitions managed via the CLI, Jinja-templated SQL Lab queries with macros and filters, dashboard YAML exports for git-based promotion across environments, RBAC role definitions, async query setup with Celery and Redis, and Helm chart values for Kubernetes deployments. Covers Preset Cloud and self-hosted setups.

When to use

Use when deploying self-hosted BI at scale, managing dashboards as code via git, building advanced Jinja-templated SQL, or configuring Superset for multi-tenant analytics.

Examples

Dashboards as code

Export, version, and promote dashboards across envs

Set up a Superset workflow that exports dashboards to YAML, stores them in git, and imports to staging then prod via the superset CLI in CI

Jinja-templated SQL with filters

Reusable parameterized queries

Write a Superset SQL Lab query using Jinja macros that accepts a date_range filter and a list of country codes, with safe SQL injection handling