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 🙂
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.
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.
@@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.
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!
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!
Thanks for sharing. This is an excellent reference for doing HR Analytics in Excel. ❤
Thankyou so much for this insightful video! Please keep making more of such informative videos
Thank you very much because the video is so detailed, easy to understand and clear
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 🙂
Very happy to hear it!
thank you so much for this vid. i found it really easy to follow and useful
Great Job.👏👏Thank you so much for sharing this valuable information.
This was so helpful. Thank you very much
Love the content Erik. Very instructional and practical.
the channel is blessing
Very insightful video. Thanks for sharing.
SO easy
Very nice. Thank you. Can you please share your used data set for practice?
The dataset is in the description 💪
@@AIHRAcademytoInnovateHR Got it. Thank you.
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.
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.
@@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.
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!
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!
Would you have the excel full files I need to practice so u can shared this files sir. thanks you❤
Hi there! You can download the data set using the link in the video description!
@@AIHRAcademytoInnovateHRI'm got it, thanks you sis 🌻🙏💐
Hi! Thank you for the video! The data file is not working.
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?
Would you have the data file so I can practice. Thank you.
You can find the file in the description!
The data set url is not working. Pls check.
Thank you for spotting it! We have fixed the link 🚀
wao