Data Analysis in MS Excel using Power BI tools (Power Query and Power Pivot) training - advanced level

Since 2012, we have been operating in the training industry, and our team consists of people who have been involved in teaching and creating modern solutions in the field of IT for many years. We spend over 600 hours a month in training rooms. This time is dedicated to training our clients but also to enriching our experiences, listening skills, and responding to your needs. We specialize in training and consulting in the field of IT. We create ready-made solutions that facilitate daily work. Our offer includes a wide range of training for both beginners and advanced users and IT specialists. The client is the most important to us! Our work makes sense when the client returns to us again and recommends us to others.

The training "Data Analysis in MS Excel using Power BI tools (Power Query and Power Pivot) – advanced level" is an intensive course for those who already know the basics of Power Query and Power Pivot and want to deepen their skills in advanced data modeling, query optimization, and creating complex analyses and reports. Participants will learn, among other things, advanced data transformation, writing complex DAX formulas, working with large datasets, and integration with Power BI Desktop.

The training is intended for data analysts, BI specialists, financial controllers, managers, and anyone who wants to fully utilize the potential of Excel and Power BI tools in their daily work.

The goal of the training is to develop analytical and technical skills in working with data, which translates into better business decisions and greater efficiency.

• Deepening knowledge of DAX language and its applications
• Ability to create advanced data models
• Optimization of query and model performance
• Integration of data from multiple sources and systems
• Creating dynamic reports and dashboards
• Increasing efficiency in working with large datasets
• Preparation for working with Power BI Desktop and Power BI service

• Advanced data transformation techniques in Power Query
• Creating custom columns and functions in Power Query (M)
• Data modeling with multiple tables and relationships
• Advanced DAX formulas – CALCULATE, FILTER, ALL, VALUES
• Creating dynamic measures and KPIs
• Handling hierarchies, dates, and calendars in data models
• Optimizing data models and managing performance
• Analytical scenarios: year-over-year comparisons, trend analysis
• Integration with Power BI Desktop – publishing and updating data
• Practical case study – building a complete analytical model

14 hours

• Practical classes with a trainer
• Training script
• Files with tasks and exercises
• Certificate
• Email consultations