Tutorials and guides on Metabase, analytics, data modeling, and more.
Start here to get the basics of how to install, set up, and find your way around Metabase.
Get up and running by asking questions, creating dashboards, and sharing your work.
Get to know your way around Metabase and ask your first question.
Create a dashboard with saved questions, and set up an alert to get notified when your question returns something interesting.
Discover the tools Metabase provides for learning about your data. These tools include a customizable data dictionary, as well as editing tools for curating your metadata.
Use Metabase as a database browser, or a publishing platform, or a lookup tool, or a quick business intelligence tool, or as just a way to field frequently asked questions.
Metabase is a deep product with a lot of tools to simplify business intelligence, from embeddable charts and interactive dashboards, to GUI and SQL editors, to auditing and data sandboxing, and more.
Learn the basics of data and databases.
A guide to the data world for beginners via a tour of the data stack.
How tables, rows, columns, and keys work together to make a database.
Why data types matter and how metadata can help you better understand your data.
Understanding how tables in a database can relate to each other.
How to work with quantitative and qualitative fields in your queries.
What a normalized database looks like and why table structure matters.
What to know about different types of database and how they work.
You'll probably hear these terms thrown around, so here's some context on the differences between a data warehouse, a data lake, and a data mart.
Thinking about your data in more than two dimensions.
How to use Metabase's query builder to ask better questions.
Build charts that people can explore by using the query builder, building models, or adding custom destinations.
When you should use custom expressions and why you should take advantage of them in Metabase's notebook editor.
How to join tables in Metabase using the notebook editor in simple and custom questions.
How to ask questions with multiple parts using the query builder.
Learn how to search within your SQL questions and simple questions using filters and custom expressions. Finding words or phrases in your tables is now easier than ever.
How to use custom expressions to clean up text that's inconsistent, unstructured, or blank.
Using SQL in Metabase.
SQL best practices: a brief guide to writing better SQL queries.
How to create filter widgets in native SQL queries using basic input variables for text, numbers, and dates.
Learn how to use Metabase Field Filters in SQL queries to build filter widgets.
Use SQL to group results by a time period, compare week-over-week totals, and find the duration between two dates.
Learn everything you need to know about using snippets in SQL code.
CTEs are named sets of results that help keep your code organized. They allow you to reuse results in the same query, and perform multi-level aggregations.
Learn about the Metabase features you can use to keep your SQL code organized.
How to combine information from two tables with a join.
Learn everything you need to know about using different SQL join types.
A simple trick to preserve the order you want the bars to appear in a chart.
Learn how to use SQL to calculate customer lifetime value in Metabase.
Finding the root cause of common SQL query problems.
What to do when your query returns an error message.
What to do when your query returns data that looks wrong.
What to do when your query returns data with duplicated rows or columns.
What to do when your query returns data that's missing rows or columns.
Charts, maps, gauges, funnels, tables, numbers, and more.
Which type of charts and graphs should you use to best communicate insights from data? This guide will help you pick the right visualization for the job.
What we talk about when we talk about line charts: time series, trend lines, alerts, and more.
Create a bar chart and customize it with visualization settings.
Learn when to use a histogram, and how Metabase makes it easy to create histograms.
How to use pin maps, region maps, and grid maps to visualize data in Metabase.
Learn how to set up conditional formatting, mini bar charts, value formatting, and more.
Learn how to create pivot tables using different databases in Metabase.
Use funnel charts to show progression through steps.
How to build interactive dashboards.
Learn how to make great business intelligence dashboards.
Link filters in dashboards to limit the choices available in one filter based on the current selection of another filter.
You can set up dashboard cards to send people to dashboards, saved questions, and URLs, and use values from the card to update filters at the destination, or parameterize links to external sites.
With just a few clicks, you can configure any chart or table to update a dashboard filter.
How to add filter widgets to dashboards and connect them to Field Filter variables in multiple SQL questions.
How to use Metabase to build an internal lookup tool to quickly find details about your customers, orders, or other data.
Editing dashboards is more than just maintaining your tools; it helps keep you focused on the right priorities.
How to use Markdown in your dashboards for fun and profit.
How to put all that historical data to good use.
An overview of methods you can use to track progress, estimate impact, and more.
How to measure the change in a metric over time by comparing two or more time periods.
Tell a story by organizing time series charts on the same dashboard.
How to get the rate of change or percentage change across an entire dataset at once.
How to make building blocks for analytics.
Create models to give people good starting datasets for new questions.
How to model data for a fact table, based on real analytics use cases.
Using actions to write back to databases, create forms, and more.
How to turn a dashboard into a basic CRUD app using actions.
Guidance on data analysis, modeling, and making better data-driven decisions.
Which data warehouse you choose depends on how much data you're wrangling. This guide walks you through your options, whether you're a small startup or a large enterprise.
Wanting more data on something can sometimes become an excuse to avoid making any decisions at all.
Figure out what you really mean when you talk about data.
Data modeling is hard. Here are some missteps to avoid when you're developing your models.
You're going to make mistakes when bootstrapping your analytics. Here's how to make fewer mistakes.
So you want to put data in front of your customers... but at what cost?
How to foster a culture that uses data to inform its decisions.
How to bring data from multiples sources into your data warehouse, then how to operationalize that data by pushing your insights to where you can make use of them.
Guidance on running and administering Metabase at scale.
An overview and list of resources for Metabase admins.
How to go from managing dozens of users to thousands.
Inside or outside your organization, what are your options for sharing your data or analysis, and when should you use one method over another?
How to keep your analytics organized as the numbers of users, questions, and dashboards inevitably increases.
Options for spinning up dev, staging, or test environments.
How to use Metabase's serialization feature to copy questions, dashboards, collections, settings, and more from one Metabase instance to a new Metabase instance.
How to make your dashboards load faster.
Best practices for scaling Metabase to support more people and databases.
An introduction to Metabase's API.
Permissions, groups, data sandboxing, and auditing.
How to think about structuring groups and permissions in Metabase.
Learn about how Metabase handles data permissions by setting up permissions on the Sample Database included with Metabase.
Set up collections with permissions to help people organize and share the work that's relevant to them.
Learn how to set row-level permissions based on people's user attributes.
Learn how to use a saved SQL query to display specific rows and columns to different people.
Pair sandboxes with user attributes to customize data for almost any situation.
Learn how to restrict customer access to rows, columns, or schemas for secure self-serve analytics.
Metabase's auditing tools are an essential feature for monitoring and compliance, but they can also help you make the most of your Metabase instance.
Learn about using LDAP to authenticate people and manage their access to data.
How to share data with people outside your organization.
Compare the development effort, customizability, and security of different approaches to data sharing.
Share standalone charts and dashboards with the good people of the internet.
What's the difference between public links, public embeds, and signed embeds?
Embed the entire Metabase app (including the query builder) to give people secure, personalized access to data.
Customize your Metabase's name, color palette, logo, favicon, and home page.
How to hide and protect sensitive data in different types of embeds.