How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024] 

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 👉 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 future-proof your HR career with our courses and certificate programs:
- Build a full analytics skill set aihr.ac/4a2rKM6
- Master powerful dashboarding skills aihr.ac/3TMcD43
- Lead the digital transformation of HR aihr.ac/4923sRb
Get unlimited access to all AIHR training courses and certificate programs with our Full Academy License aihr.ac/43qgsPi
👋👋 P.S. Follow us on LinkedIn for the latest HR developments!