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

#exceldashboard #exceldashboardstutorial #powerpivot
Hello Friends,

In this video, you'll learn how to create a HR Attrition Analysis dashboard using Excel's powerful tools like Power Pivot and DAX measures. Whether you're an HR professional, a data analyst, or someone passionate about workforce analytics, this video is tailored for you.

We have used below given KPI in this dashboard:

Total Headcount: Average headcount used for Attrition calculations.
Involuntary Count: Number of involuntary separations.
Voluntary Count: Number of voluntary separations.
Attrition Percentages: Detailed percentages for Involuntary, Voluntary, and Total Attrition.
YTD Attrition %: Year-to-date Attrition calculations.
Annualized Attrition %: An estimated annual attrition rate, calculated from YTD Attrition %.

Subscribe our new YouTube Channel:

Below is the link to download the Dashboard Template:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store

[mcarvalhocarvalho]

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.

[asrani]

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..

[shafeevullah]

Very nice dashboard.

Pls prepare IT tickets dashboard like daily weekly and monthly report

[Drkalaamarab]

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

[poojaakash]

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

[sekhargreen]

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

[VanikaPal-iv]

How can i get all the formula for attrition?

[prakash-uvct]

Hello Sir
Please provide the measure for Diversity.Thanks

[irislobreno]

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

[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.

[boluwatifeokebukunola]

Hello, please where can I download the dataset

[gupta]

@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.

[jttgapasin]

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

[jeanpavan]

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

[palexxl]

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 <= 3 month it s got to do with the firs quarte ?

[divyeshjebar]

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??