Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Metabase vs. Superset vs. Tableau
- Overview of Metabase features and components
Getting Started
- Installing Metabase
- Setting up an account
- Connecting to a database
- Exploring the UI and tools
Querying Data
- Creating questions (simple and custom)
- Creating exploratory 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 Common Table Expressions (CTEs)
- Organizing SQL code (snippets, saved questions, views)
- Combining tables with joins
Building Visualizations and Dashboards
- Selecting the appropriate 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 into websites
- Other use cases and examples
Common Issues and Troubleshooting
Summary and Next Steps
Requirements
- Familiarity with data analytics and database concepts.
Audience
- Data analysts
- Data scientists
14 Hours
