HR Dashboard in Power BI
Creation of an HR controlling dashboard for monitoring current and planned employee utilisation.
Number of employees
Development of several dashboards in Power BI for the HR controlling department of a large German logistics company. Although the customer had in-house expertise in developing visualizations in Power BI, additional support was required to calculate complex DAX formulas. They also needed to connect to HR systems and update the dashboards automatically, rather than manually using Excel. The customer wanted to actively involve employees in the creation of the Power BI dashboard in order to achieve a learning effect.
The project was divided into four work phases:
Walecon developed the key concepts for each work package in advance, which were then implemented in Power BI or Azure together with the client during workshops.
The following tools were used in this project:
Azure Data Factory
The new HR reporting received very positive feedback from the Management Board and was a significant improvement on the previous, error-prone reports. The customer's employees who worked on the project operationally benefited from the training effect.
Support with financial modelling, valuation, data analytics, Excel and Power BI.