Apache Superset
Business intelligenceExplore your data and build shared dashboards without writing code.
Superset gives a business one shared place to explore data and publish dashboards, on top of the databases it already has. Analysts can work in SQL while other staff build charts by picking fields, so not every question has to wait for a specialist. Because you run it yourself, the data stays in your own databases and you decide who can see what.
- Connects to SQL databases such as PostgreSQL, ClickHouse, Databricks and Redshift.
- Builds charts by drag and drop, or from SQL written in SQL Lab.
- Sends alerts and scheduled reports to email or Slack.
What people use it for
Build a self-serve dashboard for a team
Connect a database, then create a physical dataset from a table or a virtual dataset from a SQL query. Build charts in the no-code chart builder and arrange them on a dashboard with filters, cross-filters and drill-by. Colleagues with the right role can then explore the data themselves.
Answer one-off questions with SQL
Open SQL Lab to write queries, browse database metadata and use Jinja templating. The sql_lab role controls who can use the editor, and Alpha and Gamma users must be given access to each database. This keeps analysts to the data sources they are allowed to query.
Send a weekly report or a threshold alert
Turn on alerts and reports in the configuration and install a headless browser, as the docs describe. Schedule a report to send a dashboard or chart to email or a Slack channel as a PDF or PNG, or a chart as CSV or Excel. Alerts use the same delivery but are sent when a SQL condition is met.