Data Warehousing and Analytics

For a leading all-round service provider in the human resources field.

The Story

Situation and Challenge

The old data warehouse took too long to load and had different problems, resulting in regularly unfinished loads.
There did not exist one version of the truth and the structure of the old data warehouse could not always deal with business process changes.

Solution

A new data warehouse was built, making use of the Data Vault technology to be able to act easily and flexible on business process changes. And to be able to quickly integrate new data sources.
A SOA architecture was also implemented to exchange data between systems in a flexible manner.

Advantages

• Flexible architecture
• One version of the truth
• The different offices have a flexible and secured global overview of their KPI’s.
• The users can easily create their own reports, secured and based on their own needs.

What We Did

• Provide a global overview of all the different data sources
• Implementation of a Security Layer
• Creation of complex reports

The Technologies