Business Intelligence and Data Analysis with Metabase Training Course

Introduction

• Comparing Metabase with Superset and Tableau
• Overview of Metabase’s core features and components

Getting Started

• Installation of Metabase
• Account setup procedures
• Establishing database connections
• Navigating the user interface and available tools

Querying Data

• Creating questions (both simple and custom)
• Generating interactive charts
• Utilizing custom expressions
• Performing table joins within Metabase
• Aggregating complex, multi-level queries

Working with SQL

• Composing native SQL queries
• Developing filter widgets
• Integrating smart filter widgets
• Handling date functions in SQL
• Utilizing SQL snippets
• Streamlining queries using Common Table Expressions (CTEs)
• Structuring SQL code via snippets, saved questions, and views
• Joining tables to combine data sources

Building Visualizations and Dashboards

• Selecting appropriate chart types
• Tuning visualization settings
• Configuring dashboard layouts
• Enhancing dashboard interactivity
• Incorporating dashboard filters
• Applying industry best practices and tips

Analyzing and Managing Data

• Implementing time series comparisons
• Creating customer lookup tools
• Publishing customer-facing analytics
• Embedding charts and dashboards into external websites
• Exploring additional use cases and real-world examples

Common Issues and Troubleshooting

Summary and Next Steps