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
- Comparing Metabase, Superset, and 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 (standard and custom)
- Building exploratory charts
- Utilizing custom expressions
- Joining tables within Metabase
- Aggregating multi-level queries
Working with SQL
- Writing SQL queries (native query)
- Creating filter widgets
- Implementing smart filter widgets
- Handling dates in SQL
- Using SQL snippets
- Simplifying queries with Common Table Expressions (CTEs)
- Organizing SQL code (snippets, saved questions, views)
- Combining tables using joins
Building Visualizations and Dashboards
- Selecting appropriate chart types
- Customizing visualization settings
- Setting up and configuring dashboards
- Enhancing dashboard interactivity
- Adding dashboard filters
- Best practices and tips
Analyzing and Managing Data
- Performing time series comparisons
- Developing customer lookup tools
- Delivering customer-facing analytics
- Embedding charts and dashboards onto websites
- Additional use cases and examples
Common Issues and Troubleshooting
Summary and Next Steps
Requirements
- A foundational understanding of data analytics and database concepts
Target Audience
- Data analysts
- Data scientists
14 Hours
