Manufacturer unites reporting processes under single data warehouse solution


Many organizations grow through acquisition, buying up competitors and vendors that increase their market footprint while expanding their core capabilities.

There are operational risks to this approach, however. Integrating smaller businesses into a larger organization could create a confusing web of conflicting processes and workflows that are difficult to untangle. 

A client of ours in the manufacturing space is no stranger to such headaches. It has achieved global reach by purchasing a number of competitors in different international markets. It recently approached One Six Solutions seeking help integrating data across all locations to support consistent and accurate reporting within its sales, marketing, manufacturing and finance departments.

Integrating smaller businesses into a larger organization could create a confusing web of conflicting processes.

Our Solution

Connecting global data through a single enterprise data warehouse

One Six Solutions has ample experience working on such large-scale projects, and brought that expertise to the table when devising a data warehouse solution. The goal was to build an enterprise data warehouse that could support a standard information management architecture across the firm. That required One Six Solutions’ assistance not only architecting and developing an enterprise data warehouse, but conducting business analysis and project management efforts as well. 

Our team also consulted the organization’s executive leadership on defining project requirements and relevant KPIs to measure performance.

Advanced solutions lead to streamlined data processing

One Six Solutions turned to some of the most sophisticated data warehouse technology available to bring the project together:

The data warehouse was built on SQL Server 2014.

Data from various ERP systems was integrated with SSIS for ETL.

Product and product attribute data was standardized using Master Data Services 2014.

Advanced data visualizations, as well as the data discovery platform, were developed using Qlik Sense.

The Results

Thanks to One Six Solutions’ expert guidance and support, our client has been able to create a holistic data warehouse environment capable of integrating disparate data sources, accurately measuring business performance, analyzing sales trends and streamlining global inventory workflows.