Apache Superset

An Apache-licensed platform for exploring data and turning it into dashboards, connecting to SQL and non-SQL databases through a straightforward interface for ad hoc analysis. It combines a SQL editor, a dataset model for reusable queries, chart and dashboard builders, and scheduled reports, with role-based access so teams see different things.

Analysts use it to answer questions without waiting on a request, and product teams publish the metrics dashboards that end up on screens in the office.

Hosting it internally means query results and business metrics stay on your servers, you avoid per-dashboard BI pricing, and the metadata database is standard, so backup is routine. The service can it.