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
Level of detail and willingness to answer questions
Nozithelo Ncube, Vodacom
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 - Nozithelo Ncube, Vodacom
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 - Nozithelo Ncube, Vodacom
Understanding big data beter
Shaune Dennis - Nozithelo Ncube, Vodacom
pues lo sencillo de la herramienta
Viviana González Moreno, Seguros Banorte
The pratcice option and the involving participants in solving the tasks
BAT Pécsi Dohánygyár Ltd
Data sources and tasks were really creative and interesting.
BAT Pécsi Dohánygyár Ltd
It was very interatctive, and a load of things to learn
BAT Pécsi Dohánygyár Ltd
New knowledge. :-)
BAT Pécsi Dohánygyár Ltd
Trainers are very knowledgeable, and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
I felt like we saw the whole spectrum of what Power BI can do. The trainers were super knowledgeable and so patient with our group.
Angela Murphy - Indigenous Services Canada
I learned a lot about Power BI and how to integrate the excel into it. I also enjoyed learning all different filters, visualizations and information that can be created.
Krystina Merkley - Indigenous Services Canada
I found the two instructors extremely knowledgeable, personable and respectful, great guys.
Bruce Pickett - Indigenous Services Canada
o conteúdo em si que foi ensinado.
Edivaldo Gonçalves Cordeiro, Imdepa Rolamentos
Do aprendizado, conseguir colocar em prática os exercícios propostos.
Samanta - Edivaldo Gonçalves Cordeiro, Imdepa Rolamentos
Younes is a great trainer. Always willing to assist, and very patient. I will give him 5 stars. Also, the QLIK sense training was excellent, due to an excellent trainer.