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

Want the data set to following along? Get it here 👉 https://aihr.ac/4nHO7xR 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/4nHO7xR 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!