senn-techSelf-Hosted Business Intelligence with Metabase
Business Intelligence sounds like Power BI, Tableau, cloud subscriptions, and consultants. Metabase shows it can be different: an open-source tool that points to your existing databases and delivers answers.
Directly on Your Own Data
Metabase connects to PostgreSQL, MySQL, SQL Server, MongoDB, and dozens of other sources. No data extraction, no separate data warehouse — it queries where the data already lives.
docker run -d --name metabase -p 3000:3000 metabase/metabase
The deployment is a Docker container. Metabase’s built-in H2 database suffices for testing; for production, it connects to a PostgreSQL running in the same infrastructure.
Questions Without SQL
The query builder interface lets users filter, group, and aggregate via mouse clicks. A click on “Summarize” and Metabase suggests what makes sense — Count, Sum, Average, Group by month.
Of course, there’s also a SQL editor. For those who want it. For everyone else, the graphical interface is enough.
Dashboards and Embedding
Questions become dashboards, dashboards get embedded into internal web pages — an iframe on the internal portal, and sales sees live what the regions deliver. No license fees, no API limits.
What Metabase Is Not
Not an ETL tool, not a data warehouse, not a replacement for Power BI’s data modeling features. Who needs complex star schemas and cross-dimensional modeling is better off with the big platforms. Metabase sits on existing tables and shows what’s there.
Conclusion
For the 80% of BI questions that can be answered simply, Metabase is the right tool. It reduces BI from a year-long project to a Docker container and an afternoon.
Further Reading
What does self-hosting Metabase cost?+
Metabase is open source and runs as a Docker container on your own hardware — no cloud subscription and no license fee. For testing, the bundled H2 database is enough; for production you connect Metabase to a PostgreSQL already running in your infrastructure. The cost is pure compute time on existing hardware, with no per-user license.
Do our staff need to know SQL to use Metabase?+
No. The graphical query builder lets users filter, group, and aggregate via mouse clicks — one click on Summarize suggests Count, Sum, or Average. The interface handles most everyday BI questions. A SQL editor exists for those who want it, but it is not a requirement for general use.
When is Metabase the wrong tool?+
When you need complex star schemas, elaborate data modeling, or a real data warehouse. Metabase is not an ETL tool and does not replace Power BI’s modeling features — it sits on existing tables and shows what is there. For most BI questions it is plenty; for heavily dimensional models, the big platforms are the better choice.