Metabase Basics

• Getting started
  • A tour of Metabase
  • Getting started with Metabase
  • Find data in Metabase
  • Explore dashboards and questions
  • Ask a question in the query builder
  • Filter and limit data
  • Summarize data
  • Share your work with others
  • Learn about your data
  • Next steps: advanced Metabase features for data analysts
  • Beyond BI: other problems you can solve with Metabase
  • Using Metabase with MongoDB
• Querying and dashboards
  • Asking questions
    • Create interactive charts
    • Custom expressions in the notebook editor
    • Joins in Metabase
    • Multi-level aggregation
    • Searching your tables and questions
    • Cleaning and formatting text
  • Visualizing data
    • Which chart should you use?
    • Guide to line charts
    • Master the bar chart visualization
    • Visualize your data as a histogram
    • Visualizing data with maps
    • Almost everything you can do with the table visualization
    • Creating pivot tables
    • Funnel charts
  • Building dashboards
    • BI dashboard best practices
    • Linking filters in dashboards
    • Custom destinations: choose what happens when people click on charts in your dashboard
    • Cross-filtering: using a chart to update a dashboard filter
    • Adding filters to dashboards with SQL questions
    • Build a record lookup tool with Metabase
    • Why you should regularly edit your dashboards
    • Fun with Markdown in your dashboards
  • Time series analysis
    • Getting insights from time series data
    • Period-over-period comparisons for time series
    • Visualizing time series comparisons
  • Data modeling
    • Models in Metabase
    • Analytics engineering for fact tables
  • Actions
    • Build a basic CRUD app with actions
• Administration
  • Administration and operation
    • Admin overview
    • How to run Metabase in production
    • Managing people in Metabase
    • Guide to sharing data
    • Keeping your analytics organized
    • Multiple environments
    • Serialization: preloading dashboards in a new Metabase instance
    • Setting up a git-based workflow
    • Making dashboards faster
    • Metabase at scale
    • Working with the Metabase API
  • Permissions
    • Permissions strategies
    • Guide to data permissions
    • Working with collection permissions
    • Basic sandboxes: setting row-level permissions
    • Custom sandboxes: limiting access to columns
    • Data sandboxes: personalizing the data that people can see in Metabase
    • Use Impersonation to get row-level permissions with both GUI and SQL queries
    • Configuring multi-tenant data permissions
    • How to keep tabs on your data
    • Using LDAP for authentication and access control
• Embedding
  • Strategies for delivering customer-facing analytics
  • Publishing data visualizations to the web
  • A Metabase mystery
  • Multi-tenant self-service analytics
  • Brand your Metabase
  • Securing embedded Metabase

Grow your data skills

• Data fundamentals
  • A guide to the data landscape
  • A short overview of databases
  • Data types and metadata
  • Database table relationships
  • Measures and dimensions
  • Data normalization
  • Types of databases
  • Data warehouse vs data lake vs data mart
  • Data cubes
• Analytics with Metabase
  • Which data warehouse should you use?
  • Managing your information budget
  • Don't use "data" as a crutch for lazy thinking
  • Common data model mistakes made by startups
  • Ten common analytics mistakes startups make
  • The five stages of embedding grief
  • The push and pull of analytics
  • ETLs, ELTs, and Reverse ETLs
• Learn SQL
  • Working with SQL
    • Best practices for writing SQL queries
    • Create filter widgets for charts using SQL variables
    • Field Filters: create smart filter widgets for SQL questions
    • Working with dates in SQL
    • SQL snippets: reuse and share SQL code
    • Simplify complex queries with Common Table Expressions (CTEs)
    • SQL Snippets vs. Saved Questions vs. Views
    • Combining tables with joins
    • SQL join types
    • SQL trick: ordering bars in a chart
    • How to calculate customer lifetime value (LTV) with SQL
  • Debugging SQL
    • Debugging SQL syntax errors
    • Debugging SQL query logic
    • Debugging duplicated data in SQL query results
    • Debugging missing data in SQL query results