TOP 5 HR Metrics you SHOULD BE TRACKING and How to Calculate them in Power BI

[@ojara]

Hey, your video is the simplest, yet the most explanatory and clear of all I have seen on KZbin related to HR analytics. Thanks a lot for the effort!

[@dwest783]

keep up the HR analytics work - Power BI youtubers tend to focus on Product rather than People :). You've been a great resource so far! Look forward to future videos!

[@SolutionsAbroad]

I appreciate that Dan, thanks for your kind words!

[@blushandrush9584]

Hello Fernan, thank you for this great video. However, I don't understand why you first established two relationships for start and end date with the calendar when calculating the headcount, but then put the relationships inactive? What's the point in doing so? Sorry, if this question sounds stupid, but I'm super new to PowerBI...just started last week.

[@jr713121]

Another Excelent video! Thanks For sharing! I have a question and I hope you can help me. To calculate turnover and headcount I linked my calendar table to my main table using your trick of deactivate the relationships and then activate them using the USERELATIONSHIP function. That part is working fine. However, Now I am calculating the hire retention in a granular way during a 3-month period. I can say for each new hire, if they remain in the company after 3 months, but I had to use a different calendar. How can I use just one calendar table to calculate this and also turnover, headcount and all the other metrics? I have tried everything but can't find a solution different than two use two different calendars

[@anuragkumar2112]

Very useful video, I was stuck at the point to make the relation between joining date and relieving date of a staff at a particular branch, then presenting staff strength comparison at different point of time. This video would be helpful in solving that problem. Thanks for making such videos.

[@SolutionsAbroad]

Glad it was helpful! To be honest I also had this problem a long time ago until I discovered the power of the Calendar table, thanks for watching!

[@seankelly573]

Hi! At 16:26 you summarize average of the headcount measure. Any ideas on why I wouldn't be able to? I'm stumped.

[@SolutionsAbroad]

Hi there, is your headcount a measure? You can only implicitly summarise column values not measures

[@baronoke5432]

15:10 Employee Turnover Rate

[@A96000]

Hey, for the turnover %, wouldn't the average headcount be the headcount on 1 Jan and headcount on 31st dec divided by 2?

[@KerstinDunderberg]

Great! Do you have more HR KPI´s?

[@denwo1982]

Is it best to roll up the absence to months? As I currently have a table for absence which holds the employeeid, absencedate, absencetype, absencehours, your example is based on days but my system uses hours and not sure best way to convert this to days as each employee are on different work patterns

[@SolutionsAbroad]

Hi there, generally speaking it's better if you can roll up your data to a higher grouping its better because you'll decrease you dataset size. I would start by calculating individual people's work pattern, working out what their hours per day is and then converting them into days (as decimal)

[@denwo1982]

At 6:59 when I drag the headcount the value is repeating on each row? Any ideas as to why

[@SolutionsAbroad]

Hi there, sounds like you havent set up your relationships correctly!

[@tubeitz]

Excellent, thank you

[@SolutionsAbroad]

You're welcome, thanks for watching!

[@oshunbaygull]

What's the measure for leavers?

[@simontouma7924]

Thanks alot. Would you consider maybe explaining how to count "Leavers"?

[@rezamujahid]

Hello - What is the solution to address the scenario where offers are accepted in a particular month for offers sent in the past month, It is resulting in offer acceptance over 100%. Please advise.

[@psychoyt7802]

how did you get the monthly headcount and leavers count in turnover table for turnover calculation??? its not a measure

[@SolutionsAbroad]

Hi, for the demo I think I just summarised them into columns in a table

[@pallavijain3957]

Hi, very nice video.. I am not able to calculate average employees... As i have only employee code coloumn. Other columns are string datatype Is there any other way we can calculate Avg employee?

[@rajeshm7337]

How to create MoM annualized attrition for the financial year by overall and by department level. .pls help

[@RunWithAdamOsmond]

How can I have a table or matrix that will show me all records in one table and documents that match in another table and leave blank when there is no match.

[@SolutionsAbroad]

Hi, unrelated to this video but I've covered it here: kzbin.info/www/bejne/aGqXc3tsq7SjmdU

[@elliotpowell4120]

How did you calculate the leavers?

[@Tarunendushekhar]

how did you calculate leavers?

[@Orlandolover01]

Overall Headcount Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH(DATESMTD('Date'[Date]))) vs OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) do you know why OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) doesn't work? i get the same value as if there's no relationship, but i am referencing the date table in the measures so it should work, the same thing for quarters and previous year. but when i do all of them the first way OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) it works.

[@gowthamigg8976]

IF I am using your headcount measure i am getting blank can anyone help me

[@denwo1982]

How do you calculate HR attrition?

[@SolutionsAbroad]

Hi Denwo, there are many ways you can calculate attrition, the standard way would be total leavers in period / average headcount in period

[@denwo1982]

@@SolutionsAbroad thanks for your reply! So what would the calculation be for Turnover or is that the same?

[@SolutionsAbroad]

@@denwo1982 Yep that's what I normally use as a standard

[@Sanmaya_KumarMishra6981]

You should put the data link

[@SolutionsAbroad]

Hi there, demo files are available here: www.patreon.com/posts/demo-files-52538104