Product
Overview
What's Metabase?

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

Platform Data Sources Icon Data Sources Security Icon Security
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 For Small Teams Icon
Small Teams

Open-source analytics in 5 minutes

Growing Businesses Icon
Growing Businesses

Data tools for growing teams

Enterprise Icon
Enterprise

Data-driven decision-making at scale

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
Why full-app embedding?
Bus factor of top GitHub projects
Why Metabase Cloud?
Halloween Edition: Data Horror stories in startups
The data guide to travel
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

Company Size Enterprise Icon Enterprise Growing Businesses Icon Growing Businesses Small Teams Icon Small Teams Platform Data Sources Icon Data Sources Security Icon Security
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. Database fundamentals
    1. A short overview of databases
    2. Data types and metadata
    3. Database table relationships
    4. Measures and dimensions
    5. Data normalization
    6. Types of databases
    7. Data warehouse vs data lake vs data mart
    8. Data cubes
  3. Asking questions
    1. Create interactive charts
    2. Custom expressions in the notebook editor
    3. Trend analysis: comparing time periods
    4. Trend analysis: measuring rates of change
    5. Joins in Metabase
    6. Multi-level aggregation
    7. Searching your tables and questions
    8. 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. How to compare one time period to another
    7. Build a record lookup tool with Metabase
    8. Why you should regularly edit your dashboards
    9. Fun with Markdown in your dashboards
  8. Data modeling
    1. Models in Metabase
    2. Analytics engineering for fact tables
  9. 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
  10. Administration and operation
    1. Admin overview
    2. Managing people in Metabase
    3. Guide to sharing data
    4. Keeping your analytics organized
    5. Serialization: preloading dashboards in a new Metabase instance
    6. Making dashboards faster
    7. Metabase at scale
    8. Working with the Metabase API
  11. Permissions
    1. Permissions strategies
    2. Guide to data permissions
    3. Working with collection permissions
    4. Data sandboxing: setting row-level permissions
    5. Advanced data sandboxing: limiting access to columns
    6. Configuring permissions for different customer schemas
    7. Auditing your users and data
    8. Using LDAP for authentication and access control
  12. 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
  • 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 for
Small Teams Growing Businesses 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