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 👉 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 future-proof 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!