We take pride in delivering quality solutions...

Data Lakes and Warehouses

Third Party Logistics Provider’s Analytics Platform

What was the problem?

Our client is a third party logistics, warehousing and supply chain solution company. Their goal was to obtain insights into employee productivity and financials to improve overall efficiency and reduce operating costs.

How we helped?

The One Six team assisted the client with analysis, architecture and development of their Data Warehouse to provide a single source for employee, financial and warehouse activity data. We worked with the clients executive team to develop a reporting platform to measure KPI’s for employee productivity and worked with them to define a set of standards to measure against these KPI's against.  We also consolidated general ledger financials with the Warehouse Management System’s activity/picking data.

What were some of the tools used?

The Data Warehouse solution was built on a SQL Server 2016 utilizing SSIS for ETL to extract data from various SQL databases and flat files. Tableau Desktop and Server were used to develop data visualizations, dashboards and end user reports. Financial data marts were sourced from Microsoft Dynamics Great Plains.

What were the results?

One Six Solutions implemented a Data Warehouse solution integrating activity and labor hours which then enabled our client to successfully measure employee productivity against their end customers goals to improve efficiency across the company. Visibility into the general ledger combined with costs associated to the use of temporary staffing agencies was now easily visible and consistent.