Business Intelligence and Data Analysis with Metabase Training Course

Introduction

• Metabase vs Superset vs Tableau
• Overview of Metabase features and components

Getting Started

• Installing Metabase
• Setting up an account
• Connecting to the database
• Exploring the user interface and tools

Querying Data

• Adding questions (simple and custom)
• Creating explorable charts
• Using custom expressions
• Joining tables in Metabase
• Aggregating multi-level queries

Working with SQL

• Writing SQL queries (native queries)
• Creating filter widgets
• Adding smart filter widgets
• Working with dates in SQL
• Using SQL snippets
• Simplifying queries with CTEs
• Organising SQL code (snippets, saved questions, views)
• Combining tables with joins

Building Visualisations and Dashboards

• Choosing chart types
• Customising visualisation settings
• Setting up and configuring dashboards
• Making dashboards interactive
• Adding dashboard filters
• Best practices and tips

Analysing and Managing Data

• Using time series comparisons
• Building a customer lookup tool
• Delivering customer-facing analytics
• Embedding charts and dashboards into websites
• Other use cases and examples

Common Issues and Troubleshooting

Summary and Next Steps