Business Intelligence and Data Analysis with Metabase Training Course

Introduction

• Comparing Metabase with Superset and Tableau
• Overview of key Metabase features and components

Initial Setup

• Installing Metabase
• Account configuration
• Establishing database connections
• Navigating the user interface and available tools

Data Querying

• Formulating questions (basic and custom)
• Generating interactive charts
• Applying custom expressions
• Performing table joins within Metabase
• Handling multi-level query aggregations

SQL Integration

• Composing native SQL queries
• Developing filter widgets
• Implementing smart filter functionalities
• Managing date operations in SQL
• Leveraging SQL snippets
• Streamlining queries using Common Table Expressions (CTEs)
• Organizing SQL code via snippets, saved questions, and views
• Merging tables through join operations

Visualization and Dashboard Creation

• Selecting appropriate chart types
• Refining visualization settings
• Configuring and setting up dashboards
• Enhancing dashboard interactivity
• Incorporating dashboard filters
• Adhering to best practices and pro tips

Data Management and Analysis

• Performing time series comparisons
• Creating customer lookup utilities
• Providing analytics for customer-facing applications
• Embedding charts and dashboards into external websites
• Exploring additional use cases and examples

Troubleshooting Common Challenges

Conclusion and Future Directions