課程大綱： Business Intelligence and Data Analysis with Metabase培訓(xùn)
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
加入高級會員獲得助教答疑
