The importance of Big Data and KPI visualization for HR controlling and reporting

August 09 2018 | Blog

by Kelly O’Hara

Every area of an organization can benefit of the visualization of big data and key performance indicators: Illustrations of this sort help Marketing analyze the success of their campaigns, Sales keep track of sales cycles, and R&D can monitor how projects are moving by using data to visualize roadblocks or milestones. The HR department is no different.

Data analysis is critical to manage HR operations successfully. Unfortunately, having to go through it all quickly becomes time consuming, especially when there is no proper visualization. Not only does data visualization help managers consume large amounts of data at a glance, but it also helps paint a clearer picture of an individual employee’s performance or personal information.
Here are a few ideas of what your organization can visualize for better HR controlling and reporting. We’ve also included some suggestions on how it can be done with the help of our org charting tool Ingentis org.manager.


Visualizing Company Demographics

Demographics are an integral part of company level key figures. For example, Google releases an annual diversity report that breaks down demographics for the company globally as a whole, by tech-based roles, by non-tech-based roles, and by leadership.
While your company may not be as large or globally reaching as Google, it is still beneficial to track and visualize demographic data points, so you can monitor the development of your company and benchmark how you are doing.
For instance, tracking and analyzing the gender, race, and age of your workforce throughout your company, by specific role and by level can help you better understand your hiring and attrition patterns. For instance, if you are working towards a more diverse workplace, you can see what strides you are making year over year.

A very popular way with our customers to display large data sets like these is the Ingentis org.manager feature “Big Data Visualization”. The feature works with different charts and maps to give a clear overview of big data.
For example, the sunburst chart holds the highest organizational level in its center. The next level is illustrated as yet another circle enveloping the first, and so on. One circle can consist of several fractions, if the respective level is composed of several org units.
With the help of visualization rules the circles and fractions can be highlighted by color-coding, to point out a certain circumstance, e.g. to show all those org units with an average age higher than 50.

Ingentis org.manager: Sunburst Chart for big data visualization

Visualizing Department & Team Data

On the division, department or team level, other data may be of interest. Typical indicators that can be illustrated as eye catchers are headcount, number of open positions, budget spent, span of control or full-time equivalent.

One idea for the visualization would be to display the KPIs within the org chart as part of the respective org unit. By the way, this feature is also available in our cloud solution orginio.
Another possibility is to work with a dashboard view as you may already know it from other applications.


Visualizing Individual Data

Finally, there’s the employee, the individual, with yet another set of important data to keep track of. This could include absences and salaries as well as the evaluation of skills and performance.
By visualizing these indicators, managers and HR can quickly see areas where the employee is excelling and areas where they potentially need help. Similarly, by tracking absences – either by sick day or paid time off – you can find trends that allow you to better plan for the future. For example, if there is a certain time of the year many employees take vacations, you can plan ahead to avoid being short-staffed.
Compensation is another individual employee metric that you can track and visualize. By looking at compensation trends over time (salary, bonuses, etc.) and comparing to data from employees in the same or similar role as well as industry data, you can ensure that you are offering competitive compensation for your employees and strengthen your chances of retaining them.

As the visualization of this information can turn out to be pretty detailed, our suggestion is to work with a tooltip – a dialog box that appears when your cursor hovers over a certain employee and contains the suggested or other KPIs.

So, these are just a few ideas of how to stay on top of your HR data. Maybe while reading you’ve come up with other data units you’d like to visualize for your company. If you’d like to learn more about how Ingentis org.manager can improve HR controlling for you, have a look at the org.manager product page, or contact us directly via



More News

25 years Ingentis: A story about brave trainees, innovative ideas and evolutionary developments

The future is inextricably linked with origins: Every person, every project, every company and every success is the result of its ... read more

Education should not fail because of technology: Ingentis donates laptops to VHS

Language is an important factor in the integration of people with a migration background and their success on the job market in the read more

Ingentis welcomes new faces to its management team

Today, we are proud to announce that the Ingentis management team is expanding: As of now, Joachim Rotzinger is joining Ingentis Holding as Managing Director. In-house talent Tobias Weiß advances to the management of Ingentis Softwareentwicklung GmbH. read more

Looking back on an eventful Ingentis year 2021!

It feels like we have only just started 2021, and yet again it’s time for gingerbread, fairy lights, mulled wine – and end-of-the-year reviews. Also this year, we want to use this time before Christmas to look back on the past twelve months with you. One thing in advance: A lot has happened at Ingentis! read more