The Human Resource dashboard and human resources report is an integral part of managing HR. Both tools are important for making informed decisions in HR. Why? Because it is hard to do so when HR business partners and other stakeholders lack insight into their own organization. Never fear, HR reporting can solve this! How? Well, that’s what this article is all about. We will outline the value of the HR dashboard.
We’ll explore the advantages of a human resources report as well as the data and metrics which could be included. We’ll also include an interactive report and a few HR dashboard templates to provide you with some practical insights on how to get started.
Want to truly master powerful reporting skills and get the metrics right? Check out our HR Metrics & Dashboarding Certificate Program.
An HR dashboard is the most efficient way to monitor, manage, track, and report on data. Using this business intelligence tool enables you to track, analyze and report on HR KPIs (key performance indicators).
Before you start to create your HR report, there are a few considerations to be made about the ‘how’ and ‘when’.
A lot of organizations still work with ad-hoc data reports. For example, when a manager or director wants to know something about the organization’s workforce, they ask HR to send them a report. After this request, the HR data department will work overtime to produce this report. This is an example of (inefficient and) reactive reporting. HR reports should be deployed (pro)actively and should, therefore, be automated.
An HR report can be automated, if certain software is used to create it – such as Excel, Gusto or BambooHR. There are many software options on the market – these are some of the best HR dashboards.
In line with the previous point, there’s still a considerable number of organizations that work with manual/paper reports. This isn’t necessarily bad: When the information isn’t likely to change, paper reports can be quite effective.
In addition, an email containing a report might be more likely to be seen than an infrequent update on an HR dashboard. This is simply because people won’t use dashboards that don’t constantly add value.
An HR dashboard is the most efficient way to monitor, manage and track data. Using this business intelligence tool, enables you to track, analyze and report on HR KPIs (key performance indicators). It offers the possibility to drill down to the finer details.
Turnover may be an interesting metric, but how much of this turnover consists of regretted loss? You wouldn’t bat an eyelid when a bad performer leaves, but it’s like shooting yourself in the foot when a high performer leaves. These employees are potential senior management material. Interactive dashboards enable you to dig down deeper into your data and make these observations.
You can give all HR staff access to this dashboard or provide the relevant access or data for the relevant personnel.
While the previous dashboards offer simple drill-downs, more advanced dashboards enable you to predict the future through machine learning algorithms. This gives insights into how employees will behave, for example, which employees are at risk of quitting. This information could potentially be of great strategic value.
Note: in this case, the dashboard is merely the means of displaying the information. The predictions are made using specialized analytics tools.
An example of a Human Resource dashboard with headcount. Click to enlarge.
For more examples, check the end of the article
A final note before we show you an example of the HR report: HR reporting is often seen as a hygiene factor. This means that, like hygiene, solid reporting is not appreciated.
To explain this concept better – imagine you are out for a meal in a restaurant. You are not likely to comment on a restaurant being clean. This is what we all expect! But, if you are given dirty cutlery, or the toilets are messy – you would (rightfully) complain. So, to relate this back to HR; reporting is not noticed much unless errors occur. Solid reporting, like cleanliness in a restaurant, is essential in maintaining credibility.
Luk Smeyer, founder of iNostix, wrote this about HR reporting a few years ago. We think it captures this sentiment well.
Of course, every HR department should be (extremely) good at this ‘classical’ reporting level. No discussion. No debate. Just do it. This level should be the fully automated, highly effective, super-fast, slicing-and-dicing, easy to read, well-structured, ‘just-click-on-the-button’ functionality in every organization.
Not every organization is at the ‘highly effective and super-fast’ bit yet. However, every organization should be extremely effective in its HR reporting.
There are several important metrics that need to be included in an human resources report. Note that most of them are high-level metrics as they provide an organizational overview. We’ve published multiple lists of HR Metrics, including recruitment metrics and performance metrics on this platform. These can be used for specialized dashboards. The most common HR metrics that are being reported on, include:
This is by no means an exhaustive list. Other metrics that can be included are:
To illustrate exactly what we mean, here’s a number of examples of HR reporting in action.
This dashboard helps you understand where your employees stand on the 9 box grid.
Simply capturing the number of people who join the organization and who leave the organization is often insufficient as it doesn’t provide you with the full picture. A solution could be a personnel flow matrix. Such a matrix offers a great way of representing how many people joined, were promoted and left the company, and also how these numbers stack up.
This somewhat complex-looking table is a perfect example of a personnel flow matrix. The rows represent the four personnel categories (A, B, C, and D) and the changes between 2018 and 2019. For example, during the year 2018, 10 people went from a middle management position to a top management position.
The total employees on 1-1-2019 are displayed in the bottom row, while the total employees on 1-1-2018 are displayed in the rightmost column. The total turnover of 2018 is represented in the turnover column, and the promotions/demotions are represented in the matrix.
This overview helps to visualize organizational growth, turnover (this organization has low turnover in its production staff department, but all other departments struggle with turnover levels of well over 10%). It also visualizes its personnel development (note the 10% increase in top management, from 45 in 2018 to 50 in 2019).
On one hand, a table like this provides a great overview, on the other hand, it helps to identify some key organizational problem areas.
This HRIS the report we’re most proud of. It’s part of our People Analytics Certificate Program in which our students learn how to create this exact report by connecting multiple datasets using Power BI. As you can see for yourself, the report is fully interactive!
Another great example is the Valuing Your Talent initiative, from the Copyright Chartered Institute of Personnel and Development (CIPD).
CIPD – a professional association for HRM – provides some great resources, including a case study on Capgemini. This case study was developed with Capgemini’s own people analytics team. The report contains some excellent examples of HR dashboards (all data is, of course, fictitious).
If you want to learn how to work with data and Excel & PowerBI to create this report, check out the HR analyst course page.
HR reporting and HR dashboards are often a stepping stone for organizations that want to move towards HR analytics – and that’s why this subject is so important. Depending on the company that you work for, different data will be relevant. Good luck with creating your HR report!
An HR dashboard is a dynamic overview of the most important HR metrics in one place. The HR dashboard provides a slice-and-dice overview of the workforce, their performance, absence, and turnover. It is key for strategic decision-making in HR.
How to make an HR dashboard in Excel?It is fairly easy to make a basic HR dashboard in Excel. Create a Table (‘Insert’, ‘Table’) with the relevant HR data. Open a new worksheet and add slicers (‘Insert’, ‘Slicer’) for the HR metrics you want in your dashboard. Arrange the slicers to create your dashboard.
