Learn Metabase

Tutorials and guides on Metabase, analytics, data modeling, and more.

Tutorials and guides

  1. Topic

    Getting Started

    Get up and running by asking questions, creating dashboards, and sharing your work.

    6 articles
    1. Getting started with Metabase

      Get to know your way around Metabase and create your first question using the sample database.

    2. Sharing your work with others

      Create a dashboard with saved questions, and set up an alert to get notified when your question returns something interesting.

    3. Exploring data with Metabase's data browser

      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.

    4. Next steps: advanced Metabase features for data analysts

      Set up alerts, annotate charts with events, model data, templatize SQL queries, customize click behavior, and more.

    5. Beyond BI: other problems you can solve with Metabase

      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.

    6. A tour of Metabase

      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.

    Explore this topic
  2. Topic

    Data fundamentals

    Learn the basics of data and databases.

    9 articles
    1. A guide to the data landscape

      A guide to the data world for beginners via a tour of the data stack.

    2. A short overview of databases

      How tables, rows, columns, and keys work together to make a database.

    3. Data types and metadata

      Why data types matter and how metadata can help you better understand your data.

    4. Database table relationships

      Understanding how tables in a database can relate to each other.

    5. Measures and dimensions

      How to work with quantitative and qualitative fields in your queries.

    6. Data normalization

      What a normalized database looks like and why table structure matters.

    7. Types of databases

      What to know about different types of database and how they work.

    8. Data warehouse vs data lake vs data mart

      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.

    9. Data cubes

      Thinking about your data in more than two dimensions.

    Explore this topic
  3. Topic

    Asking questions

    How to use Metabase's query builder to ask better questions.

    6 articles
    1. Create interactive charts

      Build charts that people can explore by using the query builder, building models, or adding custom destinations.

    2. Custom expressions in the notebook editor

      When you should use custom expressions and why you should take advantage of them in Metabase's notebook editor.

    3. Joins in Metabase

      How to join tables in Metabase using the notebook editor in simple and custom questions.

    4. Multi-level aggregation

      How to ask questions with multiple parts using the query builder.

    5. Searching your tables and questions

      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.

    6. Cleaning and formatting text

      How to use custom expressions to clean up text that's inconsistent, unstructured, or blank.

    Explore this topic
  4. Topic

    Working with SQL

    Using SQL in Metabase.

    11 articles
    1. Best practices for writing SQL queries

      SQL best practices: a brief guide to writing better SQL queries.

    2. Create filter widgets for charts using SQL variables

      How to create filter widgets in native SQL queries using basic input variables for text, numbers, and dates.

    3. Field Filters: create smart filter widgets for SQL questions

      Learn how to use Metabase Field Filters in SQL queries to build filter widgets.

    4. Working with dates in SQL

      Use SQL to group results by a time period, compare week-over-week totals, and find the duration between two dates.

    5. SQL snippets: reuse and share SQL code

      Learn everything you need to know about using snippets in SQL code.

    6. Simplify complex queries with Common Table Expressions (CTEs)

      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.

    7. SQL Snippets vs. Saved Questions vs. Views

      Learn about the Metabase features you can use to keep your SQL code organized.

    8. Combining tables with joins

      How to combine information from two tables with a join.

    9. SQL join types

      Learn everything you need to know about using different SQL join types.

    10. SQL trick: ordering bars in a chart

      A simple trick to preserve the order you want the bars to appear in a chart.

    11. How to calculate customer lifetime value (LTV) with SQL

      Learn how to use SQL to calculate customer lifetime value in Metabase.

    Explore this topic
  5. Topic

    Debugging SQL

    Finding the root cause of common SQL query problems.

    4 articles
    1. Debugging SQL syntax errors

      What to do when your query returns an error message.

    2. Debugging SQL query logic

      What to do when your query returns data that looks wrong.

    3. Debugging duplicated data in SQL query results

      What to do when your query returns data with duplicated rows or columns.

    4. Debugging missing data in SQL query results

      What to do when your query returns data that's missing rows or columns.

    Explore this topic
  6. Topic

    Visualizing data

    Charts, maps, gauges, funnels, tables, numbers, and more.

    8 articles
    1. Which chart should you use?

      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.

    2. Guide to line charts

      What we talk about when we talk about line charts: time series, trend lines, alerts, and more.

    3. Master the bar chart visualization

      Create a bar chart and customize it with visualization settings.

    4. Visualize your data as a histogram

      Learn when to use a histogram, and how Metabase makes it easy to create histograms.

    5. Visualizing data with maps

      How to use pin maps, region maps, and grid maps to visualize data in Metabase.

    6. Almost everything you can do with the table visualization

      Learn how to set up conditional formatting, mini bar charts, value formatting, and more.

    7. Creating pivot tables

      Learn how to create pivot tables using different databases in Metabase.

    8. Funnel charts

      Use funnel charts to show progression through steps.

    Explore this topic
  7. Topic

    Building dashboards

    How to build interactive dashboards.

    8 articles
    1. BI dashboard best practices

      Learn how to make great business intelligence dashboards.

    2. Linking filters in dashboards

      Link filters in dashboards to limit the choices available in one filter based on the current selection of another filter.

    3. Custom destinations: choose what happens when people click on charts in your dashboard

      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.

    4. Cross-filtering: using a chart to update a dashboard filter

      With just a few clicks, you can configure any chart or table to update a dashboard filter.

    5. Adding filters to dashboards with SQL questions

      How to add filter widgets to dashboards and connect them to Field Filter variables in a SQL question.

    6. Build a record lookup tool with Metabase

      How to use Metabase to build an internal lookup tool to quickly find details about your customers, orders, or other data.

    7. Why you should regularly edit your dashboards

      Editing dashboards is more than just maintaining your tools; it helps keep you focused on the right priorities.

    8. Fun with Markdown in your dashboards

      How to use Markdown in your dashboards for fun and profit.

    Explore this topic
  8. Topic

    Time series analysis

    How to put all that historical data to good use.

    4 articles
    1. Getting insights from time series data

      An overview of methods you can use to track progress, estimate impact, and more.

    2. Comparing time periods

      How to measure the change in a metric over time by comparing two or more time periods.

    3. Visualizing time series comparisons

      Tell a story by organizing time series charts on the same dashboard.

    4. Measuring rates of change

      How to get the rate of change or percentage change across an entire dataset at once.

    Explore this topic
  9. Topic

    Data modeling

    How to make building blocks for analytics.

    2 articles
    1. Models in Metabase

      Create models to give people good starting datasets for new questions.

    2. Analytics engineering for fact tables

      How to model data for a fact table, based on real analytics use cases.

    Explore this topic
  10. Topic

    Actions

    Using actions to write back to databases, create forms, and more.

    1 articles
    1. Build a basic CRUD app with actions

      How to turn a dashboard into a basic CRUD app using actions.

    Explore this topic
  11. Topic

    Analytics with Metabase

    Guidance on data analysis, modeling, and making better data-driven decisions.

    8 articles
    1. Which data warehouse should you use?

      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.

    2. Managing your information budget

      Wanting more data on something can sometimes become an excuse to avoid making any decisions at all.

    3. Don't use "data" as a crutch for lazy thinking

      Figure out what you really mean when you talk about data.

    4. Common data model mistakes made by startups

      Data modeling is hard. Here are some missteps to avoid when you're developing your models.

    5. Ten common analytics mistakes startups make

      You're going to make mistakes when bootstrapping your analytics. Here's how to make fewer mistakes.

    6. The five stages of embedding grief

      So you want to put data in front of your customers... but at what cost?

    7. The push and pull of analytics

      How to foster a culture that uses data to inform its decisions.

    8. ETLs, ELTs, and Reverse ETLs

      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.

    Explore this topic
  12. Topic

    Administration and operation

    Guidance on running and administering Metabase at scale.

    11 articles
    1. Admin overview

      An overview and list of resources for Metabase admins.

    2. How to run Metabase in production

      If you're self-hosting Metabase, here are some benchmarks and best practices.

    3. Managing people in Metabase

      How to go from managing dozens of users to thousands.

    4. Guide to sharing data

      Inside or outside your organization, what are your options for sharing your data or analysis, and when should you use one method over another?

    5. Keeping your analytics organized

      How to keep your analytics organized as the numbers of users, questions, and dashboards inevitably increases.

    6. Multiple environments

      Options for spinning up dev, staging, or test environments.

    7. Serialization: preloading dashboards in a new Metabase instance

      How to use Metabase's serialization feature to copy questions, dashboards, collections, settings, and more from one Metabase instance to a new Metabase instance.

    8. Setting up a git-based workflow

      Create models, questions, and dashboards in a staging Metabase, commit your changes to a repository, and push those changes to your production Metabase.

    9. Making dashboards faster

      How to make your dashboards load faster.

    10. Metabase at scale

      Best practices for scaling Metabase to support more people and databases.

    11. Working with the Metabase API

      An introduction to Metabase's API.

    Explore this topic
  13. Topic

    Permissions

    Permissions, groups, data sandboxing, and auditing.

    11 articles
    1. Permissions strategies

      How to think about structuring groups and permissions in Metabase.

    2. Guide to data permissions

      Learn about how Metabase handles data permissions by setting up permissions on the Sample Database included with Metabase.

    3. Working with collection permissions

      Set up collections with permissions to help people organize and share the work that's relevant to them.

    4. Basic sandboxes: setting row-level permissions

      Learn how to set row-level permissions based on people's user attributes.

    5. Custom sandboxes: limiting access to columns

      Learn how to use a saved SQL query to display specific rows and columns to different people.

    6. Data sandboxes: personalizing the data that people can see in Metabase

      Pair sandboxes with user attributes to customize data for almost any situation.

    7. Use Impersonation to get row-level permissions with both GUI and SQL queries

      Create roles in your database, and have Metabase impersonate those roles when querying your database.

    8. Configuring multi-tenant data permissions

      Learn how to restrict customer access to rows, columns, or schemas for secure self-serve analytics.

    9. How to keep tabs on your data

      Set up alerts on usage analytics to get notified about when people change settings, download data, or make data public.

    10. Auditing your users and data

      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.

    11. Using LDAP for authentication and access control

      Learn about using LDAP to authenticate people and manage their access to data.

    Explore this topic
  14. Topic

    Customer-facing analytics

    How to share data with people outside your organization.

    6 articles
    1. Strategies for delivering customer-facing analytics

      Compare the development effort, customizability, and security of different approaches to data sharing.

    2. Publishing data visualizations to the web

      Share standalone charts and dashboards with the good people of the internet.

    3. A Metabase mystery

      What's the difference between public links, public embeds, and signed embeds?

    4. Multi-tenant self-service analytics

      Embed the entire Metabase app (including the query builder) to give people secure, personalized access to data.

    5. Brand your Metabase

      Customize your Metabase's name, color palette, logo, favicon, and home page.

    6. Securing embedded Metabase

      How to hide and protect sensitive data in different types of embeds.

    Explore this topic