How can you build an interactive HR dashboard in Excel?
Building an interactive dashboard allows you to track, analyze, and monitor a large amount of data in one convenient Excel sheet. Whether you’re trying to analyze and describe the workforce as it is, or create strategies for the future, an HR dashboard will provide you fast and accessible data points.
Meet your teacher: Erik van Vulpen. Erik is the Dean at the Academy to Innovate HR and an expert on HR analytics.
In this video you will learn how to build an interactive HR dashboard from scratch using Microsoft Excel.
You will also find out how to:
Create reports using different data sets
Run an attrition analysis
Report data using AI
Watch the full video to find out how you can leverage the power of data in your HR role to drive better and faster people decisions.
Download the data set https://aihr.ac/3TQ8tXD
TIMESTAMPS
0:00 Intro
1:25 Formatting the datasheet
2:42 Finding the age distribution with a Pivot Table
4:40 Visualising a Pivot Table
5:55 Making an interactive HR dashboard
7:09 Average salary
10:14 Salary gap by gender
13:57 Difference in pay by performance
19:49 Conclusion
____________________________________________________________________________
Upskill yourself and futureproof your HR career with our courses and certificate programs:
Build a full analytics skill set https://aihr.ac/4a2rKM6
Master powerful dashboarding skills https://aihr.ac/3TMcD43
Lead the digital transformation of HR https://aihr.ac/4923sRb
Get unlimited access to all AIHR training courses and certificate programs with our Full Academy License https://aihr.ac/43qgsPi
P.S. Follow us on LinkedIn for the latest HR developments!