Superset

Superset is the open-source BI dashboard that engineering teams actually like using. SQL-first, highly customizable, and backed by Apache with 71K+ stars. It connects to virtually any database and lets you build dashboards without a Tableau license.

If you have data engineers or analysts comfortable with SQL, Superset gives them a playground with 40+ visualization types and no per-seat pricing. Metabase is the friendlier alternative — faster setup, better for non-technical users with its visual query builder. Redash is the lightweight option for quick SQL dashboards. Commercially, Looker, Tableau, and Power BI are what you're avoiding.

The semantic layer and role-based access control make it enterprise-capable. The chart library is extensive, and the dashboard caching handles decent query loads.

The catch: Superset assumes SQL fluency. Your marketing team won't self-serve the way they would with Metabase's point-and-click builder. Self-hosting requires Redis, a metadata database, and careful configuration. The initial setup is heavier than expected. And while it's improving, the embedded analytics story is weaker than Metabase's — embedding dashboards in your product takes work.