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

Get Demo Files here
ko-fi.com/s/0a65c9db7b
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!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 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 KZbin.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@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!

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

[@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!

[@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!

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

[@tubeitz]

Excellent, thank you

[@SolutionsAbroad]

You're welcome, thanks for watching!

[@simontouma7924]

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

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

[@A96000]

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

[@oshunbaygull]

What's the measure for leavers?

[@baronoke5432]

15:10 Employee Turnover Rate

[@rajeshm7337]

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

[@elliotpowell4120]

How did you calculate the leavers?

[@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)

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

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

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

[@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!

[@random_roachonthefloor]

You should put the data link

[@SolutionsAbroad]

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

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

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