Result
Commercial printer unlocks data visibility barriers with OneSix
Modern businesses and their supply chains are incredibly complex.
Overview
Errors at one end of a workflow can cause problems that ripple across the entire organization.
They often stretch across multiple systems, platforms, business units, and, often, markets. There are numerous opportunities for things to go wrong and for errors at one end of a workflow to cause problems that ripple across the entire organization.
One of our clients – a commercial printer – experienced these kinds of issues firsthand. Looking to achieve end-to-end efficiency and visibility across its entire operational footprint, from order entry through shipping, the company reached out to OneSix for help.
Our solution
Placing data warehouse needs under a single roof
Fractured data storage platforms are a huge obstacle to capturing a complete view of any organization and stand in the way of data analytics efforts. OneSix worked with our client to establish a data warehouse solution that collected information from disparate systems and databases. Our team integrated order data from multiple sources including order entry, planning, shop floor, and shipping data, giving our client a single, consolidated view of every order from start to finish.
We also designed user-friendly dashboards to help employees quickly and easily track down and address issues in the order process flow.
A SQL Server database serves as the central Data Warehouse, pulling information from numerous sources like Hybrid and Radius manufacturing planning and process control systems. OneSix built Qlik Sense dashboards and data models to support data retrieval and analysis.
Technologies implemented
SQL Server
Data Warehouse was built leveraging SQL Server as the core data platform
ETL
SQL Server Integration Services (SSIS) performed all ETL for data cleansing and transformation as part of building the Data Warehouse
Qlik Sense
Qlik Sense was the data visualization layer leveraged by multiple departments to drive data-based decision making
Results
The right tech delivers true value
Soon after implementation, multiple teams began incorporating those dashboards into their daily assignments and saw a dramatic improvement in their internal processes. For instance, the proofing team cut order turnaround times in half within the first 6 months of using their dashboard. With durable monitors installed on shipping floors and displaying up-to-date metrics, our client’s shipping department can track its performance on an hourly basis.
As more business units work these dashboards into their workflows, operational efficiency will only climb higher.
Discover how we’ve helped our customers build Modern Data Organizations.
Manufacturing
Commercial printer operations: Capitalizing on IoT’s potential
Data Lakes + Warehouses
Manufacturing
Food solutions manufacturer improves business insights with a cloud data architecture
Data Lakes + Warehouses
Manufacturing
Global color management and hardware manufacturer streamlines data across retailer POS systems with two-way, on-demand data sync
Data Lakes + Warehouses
Transform your data org
Schedule a free consultation with the team.