HR Attrition and Head Count Analysis Dashboard in Excel | Complete Tutorial

[@mcarvalhocarvalho1873]

Hi PK, the HR Excel tool is really interesting. Thank you for providing it, as it is very comprehensive and covers various HR topics. If possible, next time, try to record it with a better definition. Thanks again.

[@PKAnExcelExpert]

Sure. Thanks 🙏

[@asrani4282]

This is very helpful. Thank you! I would like to know more about the month column.. In the Data file it has only Mar-2023, whereas in the Pivot table it shows Mar to Nov..

[@levelabove007]

Thank you so much! I have multiple years in my data, I am assuming it will handle those. Loved it.

[@PKAnExcelExpert]

I hope so!

[@sonaliraghunathan9158]

This was amazing very helpful

[@shafeevullah8141]

Very nice dashboard. Pls prepare IT tickets dashboard like daily weekly and monthly report

[@PKAnExcelExpert]

Yes, sure

[@poojaakash]

Sir can we lock the slicer as when we do Right click there are options visible to remove, cut,

[@dilipinamdarpatil6301]

Great Thanks 🙏

[@PKAnExcelExpert]

Most welcome!

[@info2satish]

Awesome!! Seems you've cold!😊

[@PKAnExcelExpert]

You are right

[@Drkalaamarab]

❤️❤️❤️❤️🇮🇳🇮🇳🇮🇳🇮🇳 Very beautiful sir, many 🙏 thanks

[@PKAnExcelExpert]

Most welcome

[@SALIS_LIGHT]

I tried to learn and make the same dashboard but stuck in creation the measure "YTD Attrition". This measure is not creating and showing error. I have checked several times the DAX expression and found it is same as you mentioned in the video. Following is the error: The expression is not valid or appears to be incomplete. Please review and correct the expression. The following syntax error occurred during parsing: Invalid token, Line 6, Offset 27, “. and sometimes following error is appearing: The expression is not valid or appears to be incomplete. Please review and correct the expression. The following syntax error occurred during parsing: Invalid token, Line 5, Offset 22, “. Can you please check and reply.

[@NeLzKieTV]

How was it now sir?

[@irislobreno8794]

Hi Pk could you please make a chart for low and high ratings of the workers

[@PKAnExcelExpert]

Will try to make

[@mskhan5346]

Great

[@PKAnExcelExpert]

Thanks

[@gupta2001]

@PKAnExcelExpert i am not getting the correct headcount can you please help & also one Question if the emp. Join in the same month & resign in the same month its reflecting in the Exit & new joining ? is ther any solution.

[@gupta2001]

It also seem that Month headcount is Wrong formula (As we can see the headcount fluctuates monthly. The headcount on January 1st, 2022, was 190 and headcount on Jan 1st, 2023, was 180. The average headcount during 2022 is (190+180)/2 = 185.) You have just divided it by 2 which totaly wrong please correct & Share again & also thank you for the effort.

[@4alexxa4]

Column month, is termination month or hire month? I do not understand

[@VanikaPal-i8v]

How can i get all the formula for attrition?

[@sekhargreen]

Can you make inventory dashboard with analysis like pending PR, pending PO, ageing, mrp analysis etc

[@AnalyticsAlly]

can you provide link for Data

[@raviy9578]

Unable to download template , useful information

[@2palexxl]

I don't get why you put 3.31 in the measure and not the end of the year wich will be 12.31. What it has with 3.31 why you set the measurea only if >=3

[@PKAnExcelExpert]

It is according to Indian financial year April to March. If you want to use Year as Jan to Dec then you don't need to put anything. I will pick up automatically.

[@2palexxl]

@@PKAnExcelExpert thank you

[@2palexxl]

Where can i send you a file to take a look and give me a help on a similar problem?

[@prabhatmishra6830]

I have a idea to get excuted can we connect with each other

[@boluwatifeokebukunola6567]

Hello, please where can I download the dataset

[@Minimalistic_tee]

Thanks

[@prakash-uv1ct]

Hello Sir Please provide the measure for Diversity.Thanks

[@jttgapasin1118]

why is it in the month column all are dated in March1?

[@jeanpavan6816]

Don't know why but I always get a 403 FORBIDDEN when I try to download your files.

[@divyeshjebar5775]

Sir I see your this video kzbin.info/www/bejne/fIO9Z6FpnK2nac0si=cy3k3-R0Cl-5DvEV This is awesome but I get one problem i have one master file then used data for make daily report so when I run they export everything as the master data is bulk and I don't need so I try with hide that main sheet and try all other export but it's saw incorrect because sheet is hide so can you try give of this solution??