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

Get Demo Files here

In this video were going to go through my top five HR metrics you should be tracking if you're working in HR, like headcount or attrition, and also how to calculate them using examples.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[ojara]

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

[dwest]

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!

[jr]

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

[blushandrush]

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.

[anuragkumar]

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.

[seankelly]

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

[A]

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

[denwo]

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

[denwo]

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

[simontouma]

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

[rajeshm]

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

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

[psychoyt]

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

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

[pallavijain]

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?

[gowthamigg]

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

[Orlandolover]

Overall Headcount Prior Month = CALCULATE([Overall Headcount], 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.