v0.39.0.1 / Users Guide / 01 What Is Metabase

MetaBase The MetaBase API provides you access to MetaBase ™, which is the knowledge base behind all systems biology products of Clarivate Analytics, including MetaCore ™, MetaDrug ™, Key Pathway Advisor, and others. Metabase School Motivation. Almost a year ago (around Jan, 2020), some folks from my company (Arc & Codementor), who are good at writing SQL, decided to start an entry-level SQL class for everyone. Metabase data reference, which acts like a dictionary, is updated with relevant information about DW facts & dimensions. Also, a best practices’ guide to work with Metabase & columnar store (Redshift) is published.

What is Metabase?

Metabase is an open source business intelligence tool. It lets you ask questions about your data, and displays answers in formats that make sense, whether that’s a bar graph or a detailed table.

Your questions can be saved for later, making it easy to come back to them, or you can group questions into great looking dashboards. Metabase also makes it easy to share questions and dashboards with the rest of your team.

Finding your way around

So, you’ve gotten Metabase up and running and connected it to your data. It’s time to give you the lay of the land.

The home page

Fresh out of the box, Metabase will show you a few things on the home page:

• Some automatic explorations of your tables that you can look at and save as a dashboard if you like any of them. (Administrators can permanently hide this section by clicking the X that appears on hover.)
• An area where things you or your teammates create will show up, along with a link to see all the dashboards, questions, and pulses you have.
• A list of the databases you’ve connected to Metabase. (As with x-rays, administrators can permanently hide this section by clicking the X that appears on hover. You can always click on “Browse Data” from the main nav bar to see your databases and tables.)

Once you’ve created some dashboards, any of them that you pin in the main “Our analytics” collection will show up on the homepage for all of your teammates, so that when they log in to Metabase they’ll know right where to go.

Browse your data

If you connected your database to Metabase during setup, you’ll see it listed at the bottom of the homepage along with the sample dataset that Metabase comes with. Click on a database to see its contents. You can click on a table to see its rows, or you can also click on the bolt icon to x-ray a table and see an automatic exploration of it, or click on the book icon to go to the data reference view for that table to learn more about it.

Explore your analytics

As you and your team create dashboards and collections, they’ll start to show up on the homepage. Click on a collection in the “Our analytics” section to see its contents, or click “browse all items” to see everything you and your team have made. More about exploring

Ask a question or write a query

Click the Ask a question button in the top-right of Metabase to start a new simple exploration of one of your tables, ask a more detailed custom question using the notebook editor, or write a new SQL query if you want to really dig in.

Make a new dashboard or pulse

Metabase Vs Tableau

In Metabase, dashboards are made up of saved questions that you can arrange and resize as you please. They’re a great way to track important metrics and stats that you care about. Pulses are what regularly scheduled reports are called in Metabase. They can be sent out either via email, Slack, or both.

To make a dashboard or pulse, click the plus (+) icon in the top-right of the main navigation bar.

Use search to quickly find things

The search bar at the top of the screen helps you find tables, dashboards, collections, saved questions, metrics, segments, and pulses in an instant.

Metabase Bi

A primer on databases

To fully understand how to use Metabase, it’s useful to have at least a high-level understanding of databases, so we’ll discuss the basics of databases next.