We take pride in delivering quality solutions...

Data Lakes and Warehouses

Manufacturing Client's Data Warehouse

What was the problem?

Our client is a manufacturing organization that was formed by the purchase of a number of individual manufacturing competitors across the globe with a goal to integrate data across all locations to support consistent and accurate reporting within Sales, Marketing, Manufacturing and Finance.

How we helped?

The One Six Solutions team assisted our client with business analysis, project management, Data Warehouse architecture and development to build an Enterprise Data Warehouse supporting a standard information management architecture across the firm. One Six Solutions worked with the organization’s executive leadership team to define requirements and create a standard set of KPI’s for the organization.

What were some of the tools used?

The solution was built upon the SQL Server 2014 platform utilizing SSIS for ETL to integrate data from five disparate ERP systems. Master Data Services 2014 was used to standardize product and product attribute data. Advanced data visualizations and the data discovery platform was developed using Qlik Sense reading data from the SQL Server 2014 Data Warehouse environment. Development timeframes were increased significantly by utilizing Windows Azure and SQL Server Azure Virtual Machines were deployed as development, test and production environments.

What were the results?

Whereas our client did not have the in-house expertise to know where to start, One Six Solutions implemented a Data Warehouse solution integrating the disparate companies which then enabled our client to successfully measure business performance. Analysis of sales trends and global inventory were now streamlined and consistent. The solution is scalable to support future acquisitions by the firm and additional data elements for future state analytics.