Skip to content

Metabase: Business intelligence from existing data

business-intelligence-from-existing-data

When you are working on growing your business, it is important to ask questions about it. Your data has a lot of ways to give you insights on how much impact your decisions are having in your business. There are several tools that allow you to do this. I will show you one of these: Metabase. The objective of Metabase is to enable the users to easily extract information from the data you have access to, making the process of cleaning up and processing the information intuitive and fast.

Metabase can connect to several data sources, including popular databases like Postgresql and MySql. You can add several data sources directly from the web interface, and mix them into a single view to have a top level overview of your whole business data. Also, it is an open source project so you can try it for free!. You can even configure it to send you email or slack notifications based on whatever metric you define. Talk about business intelligence!

Setting up Metabase is covered in their getting started guides, so we won’t discuss those topics in this blog post. Instead, we will focus on how to ask basic questions that give us information about our business and how to create a dashboard that gives us insights quickly.
For this exercise, we will use the sample dataset that comes preinstalled with metabase.

In the navigation bar (top right) you can click Ask a question, to create a simple question. After this, you select one of the tables. In this case, after selecting Orders you should be able to see the table information:

Orders from the sample database

The table view is the most basic view available, but not the only one (as we will see later). We can add filters as we require by clicking the Filter button.

Filter sidebar

When you try to filter, a sidebar will open up to the right. You will be able to select the field you want to use to filter the data, and the constraint for said filter. In this case you could, for example, check what orders have the Discount field empty, so you can extract information about those specific orders. Go ahead and try it, getting that information takes only a couple clicks!

In many cases, having too much information can be overwhelming. Table views with too many columns are hard to read, and often fail to convey useful information. You can select the columns you want, including related tables, by clicking in the Settings button at the bottom left:

Settings sidebar

You can remove columns, rename them, add new columns, conditionally format them (i.e. color values depending on ranges of values), etc.

Let’s say that we want more specific information, like the total discount we have offered in all of our orders per month. We start by going to Summarize (top right) and changing the criteria to Sum and select the Discount field. Remember to clear the filter of discount, we had set previously.

Total amount discounted

This total is not what we want yet. We want to extract the monthly amount, not the total amount the database has registered. To do this, in the Group by section, you can select the Created At field, with which the page will change to:

Monthly discount per month

Metabase automatically tries to set the visualization to something that makes sense. In this case, it uses a line chart. We can change that back to a table, or switch to a bar graph, by clicking the Visualization button at the bottom left.

Bar chart for total discounts in order per month

Easy, right? This information can be something that you want to be aware of. So let’s save it by clicking on the Save button next to Filter. Rename it as you see fit.

Save question modal

When you save it, you can attach it to a dashboard. Feel free to create one so you can see it in action. You can pin dashboards to your main page, to easily access useful insights.

Dashboard sample

It is easy to get creative and add new useful metrics to the dashboard, to stay on top of your business and make informed decisions to help it grow. Metabase can do much more than what a blog post can cover, so if you are curious about the capabilities of this tool, go ahead and give it a try. You will certainly be impressed by how quickly you can be productive with it.