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.
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.
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.
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.