Metabase
The one non-technical colleagues actually use without training.
Metabase's defining quality is that people who do not write SQL get answers from it unaided — a question builder that reads like English, sensible defaults, and dashboards that assemble in minutes. AGPL-3.0 open-source edition, self-hostable in a single JAR, with paid cloud and enterprise tiers above it. Around 48k stars. For the very common case where a company needs a hundred people to read dashboards and five to build them, this removes the per-viewer bill entirely and is often better received than the tool it replaces.
Strengths
- +Non-technical staff genuinely use it without training
- +No per-viewer cost when self-hosted — the main saving
- +Single JAR deployment; very simple to run
- +Question builder plus full SQL when you need it
Trade-offs
- −Weaker than Tableau for complex statistical and geospatial work
- −Some governance features sit in the paid enterprise tier
- −Performance depends heavily on the underlying warehouse
- −AGPL-3.0 needs reading if you embed it in a product