Power BI Desktop for HR-Analytics
December 31 - December 30, 2025, 11:00 PM - 11:00 PM
Your Office
HR & People Analytics
Note: This training is available in-company on request.
Do you have various files with data related to employees but don't know how to link them together? Do you often find yourself copying and pasting data to conduct an analysis? Do you need to perform data cleanup actions every month to create reports? Would you like to create a clear dashboard? Then this training is for you!
This training provides you with the practical tools you need to easily and effectively extract more information from the available data. You will also learn how to let your data speak and how to create interactive visual dashboards so that complex relationships are immediately visible. Even for experienced users, there’s still plenty to learn. After completing this training, you’ll be equipped to use Power BI Desktop more effectively and efficiently in your work. In this 2-day training, you’ll make significant progress in using Power BI Desktop.
The real gain lies in preparing, transforming, and modeling data in Power BI Desktop. In this training, you will learn how to automate data processing so that you don’t have to perform the same cleanup actions every month. You will also learn how to work with complex table formulas in the DAX language. After this training, you’ll be amazed at the possibilities that Power BI Desktop can offer in your daily work.
You can use Power BI Desktop as a database for all your HR data, build dynamic dashboards, and automatically update them when new data is available. This way, Power BI Desktop is perfectly suited to provide deeper insights into your data. Conclusion: with this training, you will have the tools to analyze your HR data: What trends are there? And what are the forecasts for the upcoming months?
Target Audience
This training is highly suitable for HR professionals who regularly create reports and/or analyses. It’s also ideal for HR professionals who want to make more use of Power BI Desktop. Basic knowledge of Power BI Desktop is not a requirement. During the day, we will work exclusively with examples and data from the HR field.
- Haven’t taken the HR Analytics basic training yet? You might also be interested in the HR Analytics Course.
- In addition to this training, other supplementary masterclasses can be taken after the basic training, such as the training Basic Statistics for HR Analytics, and the masterclasses Strategic Workforce Planning and Data-driven Diversity, Equity, and Inclusion (DEI).
Eric Strijk - Information specialist
I found this training very useful. In 2 days, you get great material to start using a large part of Power BI, including tips and tricks that are not immediately obvious. I can really use this. My compliments and thanks!
Good to know
- Our training programs feature an optimal combination of theory and practice. Since our instructors have extensive practical experience, they know how to effectively deliver the material. After the training, you’ll be able to immediately put what you’ve learned into practice.
- At Highberg, we opt for small groups (maximum 12 participants) so that we can offer personalized attention.
- If, due to personal circumstances, you can’t attend in person for a day, we offer the option to attend the session digitally. We ensure that you can participate interactively, just like the other participants.
- For in-company requests, it will be tailored to the needs of the company.
Learning Objectives
Based on a concrete practical case, you will learn how to:
- Import data from various sources and link them together
- Automate manual data cleanup actions
- Adjust data formats (so that sources can match)
- Work with dates
- Aggregate data
- Create new variables
- Build data models
- Create KPIs and more complex variables
- Create a dashboard in Power BI Desktop
Program
DAY 1
09.30 – 16.30
- Getting Started with Power BI Desktop
- Familiarizing with the interface
- Creating your first dashboard
- Importing a single file
- Checking and modifying data types
- Adding columns to tables
- Manually adding lookup tables
- Creating relationships between tables
- Creating hierarchies
- Creating visualizations
- Adding slicers to visualizations
- Taking it further
- Importing multiple files at onceCleaning data
- Deriving values from existing data
- Making calculations with DAX formulas
- Visualizing trends
- Making visualizations dynamic
- Comparing rows
DAY 2
09.30 – 16.30
- Taking it further (continued)
- Creating relationships with composite reference keys
- Breaking down pivot tables
- Absence analysis with Power BI Desktop
- Transforming dates
- Merging tables (joins)
- Aggregating sickness and calendar days
- Calculating sick leave percentage
- ‘Year to Date’ calculations
- Calculating rolling year sickness
- Creating relevant visualizations
- Other Analyses
- Calculating eNPS score with DAX
- Analyzing the relationship between eNPS score and various variables
- Regression and additional analyses
- Simulation and forecasting
Instructor - Irma Doze
Irma helps organizations create value with HR data and transform from conventional HR to data-driven HR. She also shares her knowledge and experience through training, workshops, and coaching. She is the co-author of the book ‘HR Analytics, Creating Value with Data-driven HR Policies’.
Costs & Terms
The in-house training will be tailored to the client’s wishes, and a proposal will be made accordingly.
At Highberg, we apply terms and conditions for all our training courses. By registering, you agree to these terms, so please read them carefully.
