Course Outline
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
Requirements
- An understanding of data analytics and database concepts
Audience
- Data analysts
- Data scientists
Testimonials (4)
Podstawowe informacje pozwalajae na samodzielne rozpoczęcie pracy i uwagi dot. optymalizacji podejścia
Robert Kaźmierczak
Course - Microsoft Office Excel - moduł Business Intelligence
All the examples used and the lecturing style was on point even for a begginer i was able to understand and the training was so patient and always willing to go extra mile when in need of assistance.
Mathipa Chepape - Vodacom
Course - Big Data Business Intelligence for Telecom and Communication Service Providers
the personalized part during which I was able to work on my project and directly apply the elements of the training
Caroline - Schreder
Course - Power BI Dashboards
Machine Translated
Do aprendizado, conseguir colocar em prática os exercícios propostos.