HR METRICS AND ANALYTICS DASHBOARD
5 HR METRICS YOU SHOULD BE TRACKING IN YOUR ORGANISATION
1. TURNOVER RATE
2. AVERAGE TIME TO FILL
3. HR TO EMPLOYEE RATIO
4. REVENUE PER EMPLOYEE RATIO
5. CAREER PATH RATIO
WHAT IS HR ANALYTICS ?
HR analytics is the process of collecting and analyzing Human Resource ( HR data in order to improve an organization's workforce performance.
The process can also be referred to as talent analytics, people analytics, or even workforce analytics.
How to conduct employee turnover data analysis
Employee turnover rate is something every HR department should measure. Knowing the percentage of employees who left your organization, you can create effective hiring plans and calculate hiring costs.
However, by drilling deeper down into your turnover data, you gain more valuable insights that will help you retain top employees a build a robust workforce to help you achieve your organizational goals.
Gather your data and tools
Generally, you’ll find the data you require to conduct an employee turnover analysis in your HRIS.(Human Resources Information System)
Depending on the goals of your analysis, you might want to collect the following information:
Department
Age
Gender
Salary
Length of employment
Months/Years in current role
Performance rating
Excel is the most accessible tool to perform your calculations, especially if you’re just starting to build the people analytics capabilities at your organization.
Finally, you can use Microsoft Business Intelligence (Power BI) to visualize your HR Analysis
TURNOVER RATE= (No' of Terminations / Average Headcount) x100
Here is the HR ANALYTICS DASHBOARD I created in one of our HR Analytics Training
Do you want to learn HR Analytics using Excel and Power BI?
Join our July Cohort. It is 5 weeks program (weekend classes)
The training starts on Saturday 29th of July, 2023
Physical and virtual class available
Call us on 08062468296 to register
Kindly follow Akerele Oluwasogo, GLMP (MR EXCEL)
Choose Lead-Leap Data Analytics School
Watch video HR METRICS AND ANALYTICS DASHBOARD online without registration, duration 05 minute 58 second in high hd quality. This video was added by user Akerele Oluwasogo (Mr Excel) 24 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 167 once and liked it 3 people.