Case Studies

Global Media Firm

Challenge

Providing data management consulting services to a leading US based media company. The company required visibility across the majority of its disparate ERP systems and data warehouses.

Due to continuing M&A activities this could not easily be done with the available resources across the group.

The objective was to integrate the relevant data from all disparate systems and prepare a consolidated set of data that could be used for in-house BI reporting teams. The raw data was in multiple language, scripts and of varying levels of completeness.

Solution

Using certified connectors and configured scripts we dynamically linked all relevant data sources from the client’s instances to the Data Hub.
Regular extraction events were scheduled to build the historical data sets and overlay these with regular updates.
The data was passed through several enrichment steps including a suite of dynamic rules-based
classification processes.
Mapping to the agreed schema was finalised and allowed the streaming data to be aggregated. The schema was made available to the client for in-house reporting as well as leveraging the available reporting solutions.

Results

Moving from a fragmented worldview to a consolidated and trusted data set, allowed the business to report accurately and in a timely manner across the conglomerate.

This data was continually updated to an agreed dynamic schedule, to meet extensive reporting requirements.

Automated support functions were established in order to continuously monitor and manage the data extraction, integration and preparation processes.

Related Case Studies

Global Law Firm

Programme management and consulting services to one of the world’s leading law firms, with over 30 offices in over 25 countries.

Financial Institution

Implementation of programme to assist London based financial institution in managing data challenges, due to rapid growth through both organic and M&A activities.