#Metabase open source how to#

Using the Action Menu to zoom in on a chart, then view the rows that make up an aggregate value. Query builder questions automatically get an action menu applied to their visualizations, allowing people to click on a table or chart to drill through the data. Plus, people who don’t know SQL can duplicate your question and use it as a starting point for another question. With custom expressions, you can accomplish pretty much anything you’d be able to do with SQL: join tables, create custom columns, filter and group results, compare time series, and more. Use the Notebook editor to ask more sophisticated questions. You can use Metabase’s query builder to filter and summarize data.

And once you’ve connected your data sources, Metabase gives you a lot of tools to explore them. Metabase supports a lot of different databases, and ships with a Sample Database for you to play around with. Metabase also makes it easy to share questions and dashboards with the rest of your team.Īt a high level, we’ll walk through the features that let you: You can save your questions, and group questions into handsome dashboards. Metabase lets you ask questions about your data, and displays answers in formats that make sense, whether that’s a bar chart or a detailed table. Metabase is an open-source business intelligence tool. The Metabase home page.īut first, what is Metabase? What is Metabase?

Metabase has a lot of tools in its toolkit (and we can’t cover everything here), but even seasoned Metabasers will benefit from a tour of its feature set - especially since we add major new features at a regular clip. This is the “what comes in the box when you install Metabase” article.

Group permissions for data and collections.

#Metabase open source how to#

How to embed charts and share your results.

Create models to use as starting data for new questions.