“So quick bright things come to confusion.” William Shakespeare, A Midsummer Night’s Dream

It’s mid-Summer where we are, and if you’re dealing with analytics on a daily basis, confusion is probably the order of the day. In this release, we’ll give you tools to at least corral the chaos somewhat.

New Data Model Reference

Don’t you love getting asked why DAU’s went down by 2% in October of last year? Don’t you love getting asked again by the next person? Assuming you want the “fun” to end, document it in the data model reference, and point people there. …


One of the most common feature requests we get is to “support Joins”. We’ve had a long and semi-sordid relationship with joins in Metabase since the project’s inception. We’ve often alluded to how we think relational data should be used in Metabase in GitHub issues, our discussion forum, and on Twitter. Given how often the topic comes up, we figured now is as good a time as any to pull those conversations together.

So what’s a join?

Most right-thinking people have no idea what a join is, aside from maybe that thing a welder did to a couple pipes when they were setting up…


Summer is here! That means it’s time to break out the sandals, fire up the grill, stock up on sunscreen and upgrade to the latest version of Metabase. In this month’s installment, we bring you lots of features that will make you the star of your company’s next BBQ.

Dashboard filters

You’ve asked. We’ve delivered. Now you can add a filter to a dashboard. Want to have a KPI dashboard where users can filter down to the last 7 or 30 days? Want to be able to see KPIs by country? Want to have a dashboard for an individual account? Now you…


If you’ve been spending time using Metabase and are starting to get itchy about doing some house keeping, we have just the thing. Our newest release gives you tools for organizing the reports and questions, as well as reducing the number of situations you need to reach for SQL. Get your dusting caps on!

Tags + Search for Saved Questions

Once you’ve been using Metabase for a few months, you’ve created lots of useful reports, common segments to look at, as well as metrics you want to keep an eye on. As the number of saved questions builds up, it’s important to make it easy for…


When setting up an analytics system for a company or project, there is often the question of where data should live. There is no one-size-fits-all solution here, as your budget, the amount of data you have, and what performance you want will determine the feasible candidates. This post will go over the categories of databases available, and hopefully give you a rough map of the choices.

Your application database

The simplest option by far is to just use whatever is currently storing your application data.

Common Examples:

Pros:

  • It’s already up
  • You don’t need to manage another database…

After helping build out a few startup’s analytics stacks, one starts to see some patterns. Sometimes these patterns are happy ones. Just about everyone loves the moment when you go from having no idea what’s going on, to a foggy idea of what happened last week.

Some, not so awesome. We’ve written previously about ways that organizations misuse data. For most working analysts or anyone charged with setting up analytics at a company, there is a much more fertile source of PTSD — data models or schemas! …


It’s that time again. In keeping with our commitment to give you new presents once a month, your friendly neighborhood Metabase team is excited to present you with…

Fullscreen (and fabulous) dashboards

  • Dashboards have gotten a major overhaul to make them easier to read, better looking and much less of a pain to arrange.
  • Questions update as you resize them to make sure your data looks good no matter how big or small it is on a dashboard.
  • While we were at it we figured why not add fullscreen mode and auto refresh? Fire up your Metabase on a TV or large monitor and…

While a little exaggerated, anyone who’s been involved with analytics in any capacity will have some story that pretty closely matches the above story. While few people talk about it, Institutional Memory, or more typically Institutional Alzheimer’s, is one of the biggest ongoing problems in analytics at scale.

What is institutional memory?

Institutional memory is a company’s collective knowledge of what things mean, how they’ve changed, and who changed them.

Institutional Memory, or more typically Institutional Alzheimer’s, is one of the biggest ongoing problems in analytics at scale

Examples include, “how do we define an active user?,” “Do we recognize revenue on the day…


There’s a lot of hype around microservices, and monolith-bashing seems to be all the rage on HackerNews and Reddit. It’s good to hear DHH bringing some sanity back into the conversation.

Large companies often have very good reason to aggressively break up applications into Centi, Milli and Micro services. For teams that number in the single or double digits of engineers, this is little short of nuts.

What (Micro)Services solve

Microservices fundamentally solve the coordination problem in large teams of engineers.

They make it easy to independently deploy different portions of a larger application. They also break up the problem into small units…


Analytics. Business intelligence. Operational insights. Customer profiling. CRM reporting. At some point all the words blur together and all you’re left with is a kind of rattled hope that if you pay a vendor $Xk/month, they’ll figure out what your CMO wants graphed and leave you alone. Oh, and if you pay for a year upfront, they’ll even make sure support requests are sent to someone else’s email.

One of the interesting parts of building Metabase has been seeing how many different problems it can alleviate that don’t necessarily look like “Business Intelligence”. …

Metabase

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store