Feb 6, 20212 min read

Executive HR Dashboard

Updated: Nov 29, 2021

HR Dashboard

HR Dashboard is a business intelligence tool that allows Human Resource teams to track, analyze and report on HR Metrics. Modern, interactive dashboards leverage an HR analytics platform which makes it easy to combine data from all systems and to deeply explore this data directly within the dashboard.

HR Metrics

Headcount, Terminations and Turnover, Hires/ Rehires, Promotions and Transfers

Headcount – Headcount is simply the number of people employed by an organization at a given time. Any employee who is active or on paid or on unpaid short-term leave
Hires – The practice/ process of finding, evaluating, and establishing a working relationship with future employees, interns, contractors, or consultants in an organization
Terminations – Termination of employment refers to the end of an employee’s work with a company. An employee may be terminated from a job of their own free will or following a decision made by the employer
Turnover/ Attrition Rate – It measures the rate of employees leaving the organization over the average headcount in a specific period of time
Promotions – Promotion of an employee is an advancement within an organization. It is an upward movement of an employee from a current job to another higher job with higher pay, grade, responsibility, and level
Transfers – Transfer is a process of placing employees in positions where they are likely to be more effective or where they are to get more job satisfaction. In transfers, there is no change in the responsibility, designation, status, or salary.

Average Headcount Calculation

HC at the beginning of Month + HC at the end of the month/ 2

For example –

Headcount as of 01 Jan 2021 – 100

Headcount as of 31 Jan 2021 – 90

Average Headcount = 100 + 90/2 (190/2 = 95)

Turnover/ Attrition Rate Calculation

Example

Let us take the example of an IT-based company in the US. At the start of 2018, there were 250 employees in the company which ended up at 240 by the end of the year. 25 employees left the company during the year. Calculate the attrition rate of the company for the year 2018 based on the given information.

Solution:

Average No. of Employees is calculated using the formula given below

Average No. of Employees = (No. of Employees at the Start of 2018 + No. of Employees at the End of 2018) / 2

Average No. of Employees = (250 + 240) / 2

Average No. of Employees = 245

Attrition Rate is calculated using the formula given below

Attrition Rate = No. of Employees that Left Workforce / Average No. of Employees

Attrition Rate = 25 / 245

Attrition Rate = 10.2%

Promotion Rate

The promotion rate is the percentage of promotion taking place in a company during a specific period of time against the total employees that are eligible for the promotion.