Product
Overview
What's Metabase?

Help everyone explore and learn from data—no SQL required.

Platform Data Sources Icon Data Sources Security Icon Security Cloud Icon Cloud
Use Cases Self-Service Analytics Icon
Self-service Analytics

Business intelligence for everyone

Interactive Dashboards Icon
Interactive Dashboards

Share insights with anyone, anywhere

Embedded Analytics Icon
Embedded Analytics

Create seamless in-product analytics

Metabase Plans Small Teams Icon
Starter and Open Source

Self-service BI in 5 minutes

Growing Businesses Icon
Pro

Advanced tools and controls

Enterprise Icon
Enterprise

White glove treatment

Watch 6-minute demo

to see how to set up and publish a dashboard

Dashboard Image
Documentation
Resources
Learn Icon
Learn

Guides on working with data

Blog Icon
Blog

News, updates and ideas

Customers Icon
Customers

Real companies, real data, real stories

Discussion Icon
Discussion

Share and connect with other users

Partners Icon
Metabase Experts

Find an expert partner

Community Stories Icon
Community Stories

Practical advice from our community

Recent Blog Posts
Resources Image
How to improve data literacy
You don't need a data warehouse
The hidden costs of the data stack
4 steps to turn your support tickets into an automated dashboard
How to create and analyze an NPS survey the right way
Pricing
Log in Get started
Overview What's Metabase? Watch 6-minute demo Use Cases Self-Service Analytics Icon
Self-service Analytics

Business intelligence for everyone

Interactive Dashboards Icon
Interactive Dashboards

Share insights with anyone, anywhere

Embedded Analytics Icon
Embedded Analytics

Create seamless in-product analytics

Metabase Plans Enterprise Icon Enterprise Growing Businesses Icon Pro Small Teams Icon Starter and Open Source Platform Data Sources Icon Data Sources Security Icon Security Cloud Icon Cloud
Documentation
Learn Icon Learn Blog Icon Blog Customers Icon Customers Discussion Icon Discussion Partners Icon Partners Community Stories Icon Community Stories
Pricing Log in
  1. Getting Started
    1. Getting started with Metabase
    2. Sharing your work with others
    3. Exploring data with Metabase's data browser
    4. Beyond BI: other problems you can solve with Metabase
    5. A tour of Metabase
  2. Data fundamentals
    1. A guide to the data landscape
    2. A short overview of databases
    3. Data types and metadata
    4. Database table relationships
    5. Measures and dimensions
    6. Data normalization
    7. Types of databases
    8. Data warehouse vs data lake vs data mart
    9. Data cubes
  3. Asking questions
    1. Create interactive charts
    2. Custom expressions in the notebook editor
    3. Joins in Metabase
    4. Multi-level aggregation
    5. Searching your tables and questions
    6. Cleaning and formatting text
  4. Working with SQL
    1. Best practices for writing SQL queries
    2. Create filter widgets for charts using SQL variables
    3. Field Filters: create smart filter widgets for SQL questions
    4. Working with dates in SQL
    5. SQL snippets: reuse and share SQL code
    6. Simplify complex queries with Common Table Expressions (CTEs)
    7. SQL Snippets vs. Saved Questions vs. Views
    8. Combining tables with joins
    9. SQL join types
    10. SQL trick: ordering bars in a chart
    11. How to calculate customer lifetime value (LTV) with SQL
  5. Debugging SQL
    1. Debugging SQL syntax errors
    2. Debugging SQL query logic
    3. Debugging duplicated data in SQL query results
    4. Debugging missing data in SQL query results
  6. Visualizing data
    1. Which chart should you use?
    2. Guide to line charts
    3. Master the bar chart visualization
    4. Visualize your data as a histogram
    5. Visualizing data with maps
    6. Almost everything you can do with the table visualization
    7. Creating pivot tables
    8. Funnel charts
  7. Building dashboards
    1. BI dashboard best practices
    2. Linking filters in dashboards
    3. Custom destinations: choose what happens when people click on charts in your dashboard
    4. Cross-filtering: using a chart to update a dashboard filter
    5. Adding filters to dashboards with SQL questions
    6. Build a record lookup tool with Metabase
    7. Why you should regularly edit your dashboards
    8. Fun with Markdown in your dashboards
  8. Time series analysis
    1. Getting insights from time series data
    2. Comparing time periods
    3. Visualizing time series comparisons
    4. Measuring rates of change
  9. Data modeling
    1. Models in Metabase
    2. Analytics engineering for fact tables
  10. Actions
    1. Build a basic CRUD app with actions
  11. Analytics with Metabase
    1. Which data warehouse should you use?
    2. Managing your information budget
    3. Don't use "data" as a crutch for lazy thinking
    4. Common data model mistakes made by startups
    5. Ten common analytics mistakes startups make
    6. The five stages of embedding grief
    7. The push and pull of analytics
    8. ETLs, ELTs, and Reverse ETLs
  12. Administration and operation
    1. Admin overview
    2. Managing people in Metabase
    3. Guide to sharing data
    4. Keeping your analytics organized
    5. Multiple environments
    6. Serialization: preloading dashboards in a new Metabase instance
    7. Making dashboards faster
    8. Metabase at scale
    9. Working with the Metabase API
  13. Permissions
    1. Permissions strategies
    2. Guide to data permissions
    3. Working with collection permissions
    4. Basic sandboxes: setting row-level permissions
    5. Custom sandboxes: limiting access to columns
    6. Data sandboxes: personalizing the data that people can see in Metabase
    7. Configuring multi-tenant data permissions
    8. Auditing your users and data
    9. Using LDAP for authentication and access control
  14. Customer-facing analytics
    1. Strategies for delivering customer-facing analytics
    2. Publishing data visualizations to the web
    3. A Metabase mystery
    4. Multi-tenant self-service analytics
    5. Brand your Metabase
    6. Securing embedded Metabase
  • Learn
  • Data modeling

Topic

Data modeling

How to make building blocks for analytics.

Articles

Article 1

Models in Metabase

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

Read more

Article 2

Analytics engineering for fact tables

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

Read more

Product
Why Metabase Data Sources RoadmapSecurity
Pricing
Plans Open Source
Use Cases
Self-Service Business Analytics Interactive Dashboards Embedded Analytics
Metabase Plans
Starter and Open Source Pro Enterprise
Support
Documentation Discussion Help
Status
Company
Jobs
We're hiring!
Terms of Service License Privacy Policy Contact Us
Resources
Case Studies Blog Learn Community Stories Data and Business Intelligence Glossary Partners More Resources
Example Dashboards SQL Best Practices Choosing a Data Warehouse How to Create Pivot Tables Types of SQL Joins SQL Cheat Sheet Data Bias Examples Modern Data Stack Dashboard for Marketing Teams Dashboards for Sales Teams Dashboards for Engineering Teams
Elsewhere
Twitter
Github
Stay in touch with updates and news from Metabase
© Metabase 2023