       Business Intelligence and Data Analysis with Metabase培訓

Introduction

Metabase vs Superset vs Tableau
Overview of Metabase features and components
Getting Started

Installing Metabase
Setting up an account
Connecting the database
Exploring the UI and tools
Querying Data

Adding a question (simple and custom)
Creating explorable charts
Using custom expressions
Joining tables in Metabase
Aggregating multi-level queries
Working with SQL

Writing SQL queries (native query)
Creating filter widgets
Adding smart filter widgets
Working with dates in SQL
Using SQL snippets
Simplifying queries with CTEs
Organizing SQL codes (snippets, saved questions, views)
Combining tables with joins
Building Visualizations and Dashboards

Choosing a chart type
Customizing visualization settings
Setting up and configuring dashboards
Making dashboards interactive
Adding dashboard filters
Best practices and tips
Analyzing and Managing Data

Using time series comparisons
Building a customer lookup tool
Delivering customer-facing analytics
Embedding charts and dashboards to websites
Other use cases and examples
Common Issues and Troubleshooting

Summary and Next Steps