Increase your analytical skills and make the process of data analysis easier and more enjoyable.
BI Academy II
Workshop for self-service data analytics and compelling dashboard creation using Power BI and Power Query.
Advanced Power BI Online Workshop
Learn how to import data, create data model, measures and visualizations in Power BI.
Advanced Reports with Power BI
- Consolidate skills acquired in BI Academy I
- Import multiple data tables, including planning tables
- Create dynamic titles and advanced measures to compare time periods (year-to-date)
- Create advanced visualizations, including deviations for quick discovery of anomalies in business performance
DAX and Power Query
- Understand the structure of planning tables and create time limited functions to compare realization with plan
- Import Excel files with plans and transform data
- Learn what is ETL and how it is performed in Power Query
- User interface
- Learn about M language and automated query generation
- Learn about different types of data and data import
Attendee Testimonial
Power BI is a great tool for data automation and transformation
Skills acquired in the workshop will enable me to automate and transform imported data, create robust data model and well-designed reports. I would definitely recommend this workshop.
Who is it for?
BI Academy II is for anyone who prepares or uses advanced analyses - in finance, controlling, marketing, sales or other departments.
Duration
Duration of the workshop can be adjusted to your needs, but is typically 14 instructional hours long and executed in two sessions.
BI Academy II Agenda
- Repetition and consolidation of skills acqured in BI Academy I.
- First workshop - Advanced Reports with Power BI. You import several data tables, including planning tables into a data model, preprare dynamic titles, advanced measures and learn how to use Power BI functionalities for advanced visualization.
- Second workshop - DAX and Power Query. You learn the process of ETL in Power Query, M language basics and date and time functions in DAX language.
Workshop price
Cena
690,00 €
Trusted by
