Advanced HR Dashboard

Description
This Excel dashboard template allows you to track the main Human Resources Key Performance Indicators (HR KPIs) of your company, over 3 years: Headcount, Employee Movements, Payroll, Skills, Training, Absenteeism, Health and Safety and Gender equality.


It is a Human Resource management tool, that will help you implement and improve, the Human Resources policies in your company.


It allows HR team members to monitor the main HR analytics:


Headcount Metrics
Total and average headcount, full-time/part-time employees, employees by working time, by occupation and occupation classification, by age group and tenure, the average employee tenure and average employee age, employee by division and department, expat workers vs locals, employees with disabilities, gender diversity and headcount metrics changes over 3 years.


Employee Movements Metrics
Hires, departures and employee turnover rate, promotions, mutations and other employee career changes, disciplinary sanctions, men to women ratio and employee movement changes over 3 years.


Employee Skills Matrix
Mapping of employees’ skills and their levels.


Employee Training Metrics
Number of trained employees, total training hours and average training hours, training costs, training expenses vs budget, gender training gap and evolution of training and expenses over 3 years.


Payroll Metrics
Payroll, employer payroll taxes and net pay KPIs, total remuneration, average remuneration and average cost of an employee, highest and lowest pay, payroll break down by department and division, contract type and working time, occupation and occupation classification, age group and tenure, pay Gap between men and women, local and expat workers, employees with and without disabilities, and payroll trends over 3 years.


Workplace Health and Safety Metrics
Occupational accidents, commuting accidents and occupational diseases, number, frequency, severity, lost working days, workplace safety training hours, the causes of accidents and diseases, analysis of the most exposed employees and evolution of health and safety in the company over 3 years.


Absenteeism Metrics
Number of absence days, lost working days and absenteeism rate, absenteeism causes, characteristics of absent employees, and evolution of absenteeism in the company over 3 years.
An easy-to-use HR dashboard template perfect for HR managers and executives who wish to keep track of workforce KPIs, identify trends, and analyze how efficient is the HR team in achieving the company’s HR strategy.


Using this template is quite easy, you just need to:
• Input your settings
• Enter/import employee data
• Enter/import movement, sanctions, skills, training, remuneration, health & safety, employee absences data.


Template Requirements:
• Works on PC with Windows.
• Does not work on a MAC.
• Requires Microsoft Excel 2016 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• Memory (RAM) 4 GB or more recommended.
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel sheet “User Guide”.


Template Customization:
Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.