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

[@mamhyamo]

Thanks for sharing. This is an excellent reference for doing HR Analytics in Excel. ❤

[@docfariz]

Thankyou so much for this insightful video! Please keep making more of such informative videos

[@CelesFranco]

Love the content Erik. Very instructional and practical.

[@ramaasivakumar4178]

Thank you so much for the Video Erik... Your strategical approach to this HR Analysis is crystal clear... And I also learnt a lot of hidden capabilities that a pivot table has... Especially the function that you used to create Age ranges is completely new to me... And thank you for sharing the dataset... I am a beginner and this project is gonna be super-useful 🙂

[@AIHRAcademytoInnovateHR]

Very happy to hear it!

[@jubaerferdous]

Great Tutorial! Really Helpful!

[@sumeraasim4170]

the channel is blessing

[@ahassan7270]

Great Job.👏👏Thank you so much for sharing this valuable information.

[@bachlinhcpgiang]

Thank you very much because the video is so detailed, easy to understand and clear

[@AnneArts]

thank you so much for this vid. i found it really easy to follow and useful

[@mojalefacoaching]

This was so helpful. Thank you very much

[@rachnabhatia5523]

Very insightful video. Thanks for sharing.

[@karinf3435]

Great Video, as usual. The only thing I am missing are data across one or more years (with data of each month) and how the dashboard would look like and be designed then.

[@নামাজকায়েমকরুন-থ৯ব]

Very nice. Thank you. Can you please share your used data set for practice?

[@AIHRAcademytoInnovateHR]

The dataset is in the description 💪

[@নামাজকায়েমকরুন-থ৯ব]

@@AIHRAcademytoInnovateHR Got it. Thank you.

[@tutsecret499]

Would you have the data file so I can practice. Thank you.

[@AIHRAcademytoInnovateHR]

You can find the file in the description!

[@harshpatil5821]

My pivot table is not grouping.

[@swooz7746]

What about the 44 employees that are listed twice in the dataset: 20 hrs for Sales and 20 hrs for Marketing? Shouldn't they only count 1x each as an employee, rather than twice? I haven't yet tried to adjust the dataset to see what it does to the results.

[@AIHRAcademytoInnovateHR]

That's a great example of why you should review and clean your data set before the analysis Swooz! Well-spotted. We skipped that in the video as we wanted to dive right into the data visualization but the data has a couple of Easter eggs that need to be cleaned and corrected if this were a real people analytics case.

[@menghao4576]

@@AIHRAcademytoInnovateHR Forgive me for asking a simple question, I am new to data analysis, only the duplicate id should be removed right? When I highlighted the duplicates, it showed many, but I selected all columns and tried to delete duplicates, but the result was no duplicate found. So how should I clean the data here? Thank you.

[@jasminxpurple14]

Hi! Thank you for the video! The data file is not working.

[@AIHRAcademytoInnovateHR]

Hi there! I'm sorry to hear you're having trouble with the data file. Are you having trouble starting the download, or opening the file?

[@prakveasna010]

Would you have the excel full files I need to practice so u can shared this files sir. thanks you❤

[@AIHRAcademytoInnovateHR]

Hi there! You can download the data set using the link in the video description!

[@prakveasna010]

​@@AIHRAcademytoInnovateHRI'm got it, thanks you sis 🌻🙏💐

[@skbhardwaj01]

The data set url is not working. Pls check.

[@AIHRAcademytoInnovateHR]

Thank you for spotting it! We have fixed the link 🚀

[@peijunwang]

SO easy

[@dreamb2304]

I have followed the same as per my data base but the last part of clicking male and female average salary is not changing. All and all amazing video. I have learned so much. thank you!

[@AIHRAcademytoInnovateHR]

This is likely because the slicer is not connected to your average salary variable. You can check the instructions from 18:25 onward, where I show how to connect these reports so they become interactive. Hope that helps. I'm glad you liked the video, dreamb2304!

[@Khananaama]

Why the average age was not changing

[@MazharHussain-me8eq]

wao