Vector Logistics Enhances Data Automation for Improved Efficiency

Vector Logistics, a Sales, Merchandising, and Supply Chain partner in Southern Africa, was facing a significant challenge in managing multiple data sets within the customer analytics area. The company was spending a substantial amount of time manually extracting files from SAP and consolidating them with files received in email attachments using Microsoft Excel and the Power Query functions. This process was repeated approximately 4 days per month and upon ad-hoc requests, such as employee changes including new hires, resignations, and role changes. The challenge was to create an automated workflow that would significantly reduce manual efforts in extracting, mapping, and cleansing data that was previously done using Power Query. The company also needed to map unstructured IRI/Shoprite/PNP Portal data to SAP BW data, thereby reducing efforts involved with cleansing data previously completed using 'text to columns', 'vlookup' and other manual interventions.

Vector Logistics is a Sales, Merchandising, and Supply Chain partner that adds value to businesses through a fully integrated, temperature-controlled network in Southern Africa. The company was spending a significant amount of time mapping efforts involved with multiple datasets within the customer analytics area. The users would manually extract files from SAP and consolidate it with files received in email attachments, using Excel and the Microsoft Power Query functions. This process was repeated approximately 4 days per month and upon ad-hoc requests, such as employee changes including new hires, resignations, and role changes.