Business Intelligence and Data Analysis with Metabase Training Course

Introduction

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

Getting Started

• Installing Metabase
• Creating and configuring user accounts
• Establishing database connections
• Navigating the interface and available tools

Data Querying

• Adding questions (both simple and custom)
• Generating interactive charts
• Applying custom expressions
• Performing table joins within Metabase
• Handling multi-level query aggregation

SQL Integration

• Composing native SQL queries
• Developing filter widgets
• Incorporating smart filter widgets
• Managing date logic in SQL
• Utilizing SQL snippets
• Refining queries using Common Table Expressions (CTEs)
• Structuring SQL code via snippets, saved questions, and views
• Merging tables using join operations

Visualizations and Dashboards

• Selecting appropriate chart types
• Tailoring visualization parameters
• Setting up and adjusting dashboard configurations
• Enhancing dashboard interactivity
• Implementing dashboard filters
• Reviewing best practices and practical tips

Data Analysis and Management

• Performing time series comparisons
• Developing customer lookup utilities
• Publishing analytics for external stakeholders
• Embedding charts and dashboards into external websites
• Exploring additional use cases and practical examples

Common Issues and Troubleshooting

Summary and Next Steps