Metabase gets dashboards in front of people fast
Metabase earned its place as a default first BI tool because it is easy to stand up and easy to use. There is no license fee for the open-source build if you run it on your own servers, and a hosted version is available for teams that prefer not to run it. Non-technical users build questions with a visual query builder, analysts drop into a mature native SQL editor, and dashboards can be embedded in your own product through an SDK. Admins get mature permission settings, and AI features are available through Metabot.
Where it strains is depth and scale. Once a question needs more than a simple aggregate, someone usually has to write SQL, and that someone is on the data team, and metric definitions can drift across dashboards as more people build them. Self-hosting also means someone owns upgrades and uptime.