Pros and cons
What Metabase does especially well — and the limits to anticipate.
Pros
- Open source and free when self-hosted
- Build dashboards and ask questions without writing SQL
- Gives data access to non-technical profiles
- Connects to most databases (Postgres, MySQL, BigQuery...)
Cons
- Free self-hosting requires admin time and a bit of infrastructure
- The Cloud version is expensive (from $100/month, $575 on Pro)
- Less powerful than Looker or Tableau on very complex models
- For purely Google reporting, free Looker Studio is enough
Metabase: when it makes sense.
Excellent and free when self-hosted to give a team access to data. If you don't want to manage infra or everything is on Google, Looker Studio is simpler.
Keep if
You want to give data access to non-technical profiles. Your data lives in a real database and you can self-host for free
Challenge if
You mostly do Google reporting (GA4, Ads): free Looker Studio is enough. You want neither to manage hosting nor to pay for the Cloud version

