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

Подписаться 45 тыс.

Просмотров 17 тыс.

50% 1

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 - fernan@solutionsabroad.co.uk
🤵 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 RU-vid.
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

Опубликовано:

5 дек 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@ojara 2 года назад

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

@dwest783 2 года назад

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 2 года назад

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 2 года назад

Excellent, thank you

@SolutionsAbroad 2 года назад

You're welcome, thanks for watching!

@anuragkumar2112 2 года назад

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 2 года назад

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!

@simontouma7924 Год назад

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

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

@pallavijain3957 2 года назад

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?

@elliotpowell4120 Год назад

How did you calculate the leavers?

@oshunbaygull 2 года назад

What's the measure for leavers?

@rajeshm7337 Год назад

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

@Tarunendushekhar 8 месяцев назад

how did you calculate leavers?

@baronoke5432 8 месяцев назад

15:10 Employee Turnover Rate

@seankelly573 2 года назад

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 2 года назад

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

@denwo1982 2 года назад

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 2 года назад

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)

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

@gowthamigg8976 2 года назад

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

@psychoyt7802 2 года назад

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

@SolutionsAbroad 2 года назад

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

@denwo1982 2 года назад

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

@SolutionsAbroad 2 года назад

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

@RunWithAdamOsmond 2 года назад

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 2 года назад

Hi, unrelated to this video but I've covered it here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-294BH6vOpcs.html

@Orlandolover01 5 месяцев назад

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.