The way from Excel to data preparation and analysis

The WSW (Wuppertaler Stadtwerke) work to supply their city (350,000 inhabitants) with electricity, gas and district heating, produce drinking water and take care of drainage. They operate local public transport (e.g. the suspension railway) and transport about 90 million people a year with their mobility services. Together with their association partner AWG, they also organise waste disposal and, with this comprehensive supply mandate, see themselves as partners responsible for people and nature. With 3,046 employees, the WSW Group is one of the largest employers in Wuppertal.

Efficient data management is often just a wish, the reality is different

A central task of human resource management is the collection and dissemination of key figures and values, which are obtained from various sources such as SAP or other systems. The individual recipients of reports – from management and departments to the works council or external authorities – have different needs for information and correspondingly diverse requirements. The collected figures are needed for controlling and planning, measures are derived from them or projects are developed. Data is usually passed on via the usual Office products (Word, Excel or PowerPoint). The manual effort for collection, consolidation and dissemination is considerable and ties up resources. Data timeliness is correspondingly weak and HR departments often reach their limits.

"This can be done better," is how Sascha Fette, HR Controlling and Cost Planning Officer at WSW, formulates WSW’s urgent wish for change and the goal of "setting up HR management more efficiently and having more time for analyses and measures." In their search for support, the management consultancy noventum consulting came into play for the Wuppertal-based company with its noventum HR-Analytics solution. "We are on the road with many clients and usually find exactly such a situation," Kay Kamphans of noventum confirms the widespread situation in HR departments.

Read the whole article on nc360°, the news platform of noventum consulting GmbH.

– Personnel controlling is a key strategic function

– Requirements for a modern reporting system

– noventum HR-Analytics is a complete solution for reporting, analysis and planning

– Bringing together individual source data in the data mart to a single point of truth is the real effort for an HR analytics project

– The WSW project: from manual data preparation to analyses and recommendations for action

– The project carried out completely remotely

Watch the complete presentation at Zukunft Personal 2022 on Youtube: https://youtu.be/ra3FCU7lhUk