Manufacturing Data Merger

Project Tools

  • Analysis Services (SSAS)
  • Integration Services (SSIS)
  • Microsoft SQL Server 2012

Project Details

 

Customer profile

Global Twin Cities Manufacturer, global manufacturing and operations, global sales.

 

Customer’s challenge

After many acquisitions, combined with divergent growth at existing plants and facilities worldwide, our client needed to merge data from more than 30 disparate data systems while continuing to maintain functionality during roll-out of a single, centralized data system for the entire organization.

 

Tail Wind offering

  • We used Microsoft Data and Business Intelligence tools to build an ETL and Data Warehouse system enabling the extraction of data from legacy providers, unification of the data into interim storage and forward matching and distribution of the data into a new master data warehouse.
  • The process and interim storage were designed in a manner that allowed ongoing BI Analysis and Reporting throughout the transition, thus preventing a break in analytic services.

Manufacturing Data Management