Apache Superset
Apache Superset is an open-source data exploration and visualization platform, originally built at Airbnb and now an Apache top-level project, positioned as a free, self-hosted alternative to commercial BI tools like Tableau or Looker. It connects to any SQL-speaking database (Postgres, MySQL, ClickHouse, Snowflake, BigQuery, Presto/Trino, and dozens more via SQLAlchemy) and provides both a no-code chart builder and a full SQL Lab interface for writing and visualizing raw queries.
Superset exposes a REST API for programmatically managing dashboards, charts, datasets, and database connections, making it possible to automate dashboard provisioning as part of a deployment pipeline. Dashboards can be embedded in external applications via the Embedded SDK, and row-level security rules can restrict what data different user roles see — useful for multi-tenant reporting.
Being open-source and self-hosted (Docker Compose or Kubernetes deployment), there is no licensing cost, only infrastructure cost — a meaningful advantage for Nigerian startups and public-sector data teams operating with constrained budgets and where data residency requirements make sending data to a foreign SaaS BI vendor undesirable. The tradeoff versus Tableau or Metabase is a steeper setup and maintenance burden: someone on the team needs to own the deployment, upgrades, and performance tuning.