Success story

Vector Logistics Going Beyond With Their Data Automation

National supply chain specialist, Vector Logistics, is reaping significant benefits from an automated data analytics solution implemented by Keyrus. These include substantial time savings, reduced key person dependency and improved efficiency.

Headquartered in KwaZulu-Natal (KZN), Vector Logistics offers Sales solutions, Supply chain intelligence, Warehousing, Distribution, Credit Management and Imports/ Exports services. The organisation underwent a multi-million rand infrastructure expansion in 2017 and is now a specialist multi-temperature service provider. It serves food manufacturers, food-service groups and national retailers, bringing their leading brands to the market.

The Vector Logistics’ Sales & merchandising analytics team needed vastly improved response times to update merchandising call cycles. Users spent extensive amount of time manually extracting and consolidating files from enterprise resource planning (ERP) system SAP and using Microsoft Power Query in Excel. This process consumed approximately four days each month.  

The organisation needed a smart solution to automate this process and turned to Keyrus – a recognised expert and trusted Data and Digital partner.

The task was to create an automated workflow system to significantly reduce the manual effort involved in extracting, mapping and preparing data. Unstructured customer portal data needed to be mapped to SAP Business Warehouse (BW) to reduce the effort involved in cleansing data, previously completed using manual interventions including Microsoft Excel Text to Columns and VLOOKUP.

“The aim was to optimise the creation of Vector Logistics’ merchandising call cycles by combining a variety of sources leveraging leading modern technology tools,” says Stephen Coull, Sales Director at Keyrus.

Keyrus is a tool agnostic consultancy that prides itself on selecting the best technology tools to meet clients’ business challenges.

Based on the business brief, it was evident that a leading analytic process automation (APA) technology would be an ideal fit. Keyrus, as a global premier partner, introduced a Gartner Quadrant Leader in this space, Alteryx, which provides end-to-end analytics, data science and process automation. The solution includes the Alteryx Designer to build the automated workflows and was complimented by the Alteryx Connector for SAP from DVW Analytics, which provides the fastest, easiest way to read data from SAP into Alteryx.

The major immediate benefit for the Vector Logistics’ Sales & merchandising analytics team was dramatically improved response times and enabled higher visibility of granular store detail from disparate systems. The time taken to update call cycles has been shortened by approximately half.  The Sales & merchandising team no longer needs to invest four days to ensure accuracy of their call cycles giving them greater confidence in where their teams are spending time. Combined with granular visibility of mapped till sales, they now have the ability to ensure that the in-store teams know where to focus their efforts.

The recently completed optimisation and automation implementation has also resulted in increased accuracy and consistency. The organisation is benefitting from repeatable, robust workflow that is no longer key person dependent, and the Sales & merchandising analytics team is better able to focus on its core business.

In addition, the solution was non-invasive. It was overlaid on existing systems and integrated with existing data, minimising disruption to the organisation’s existing IT architecture.

“The solution is easy to use and able to master workflows quickly,” says Ashleigh Jacobs, Supply Chain Solutions Architect at Vector Logistics. “We now have a business tool, rather than a technology tool, which has completely transformed our process. In line with our vision to be in the front line of progress and innovation in our industry, the tools introduced to our analysts will enable them to accelerate their data science journey and assist the overall digital transformation of the company.”

“Our team of experts is equipped to enable true digital transformation,” says Stephen Coull. “We  aim to move companies away from tedious manual intervention through automation and are extremely happy to witness the positive impact on our client’s operations.”


Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Success story

Vector Logistics embraces cloud-powered modern analytic solutions

April 20, 2022

A leading national supply chain specialist now benefits from vastly improved visibility and immediate access to information via self-service following a sophisticated cloud-powered analytics solution delivered by Keyrus.

Success story

Robust cost transparency model for The Foschini Group

April 6, 2022

Following this implementation, TFG is benefitting from insights into the costs of delivering IT and services to the group, as well as the ability to accurately assign costs to users of IT services. For the first time, IT is able to properly explain these chargebacks with accurate, detailed reports.

Success story

Company-wide BI enablement and self-service at a large retailer

March 31, 2022

The leadership of Mr. Price Group, JSE listed retail company and one of the largest retailers in South Africa, had the foresight to invest in the new generation of BI solution and to empower wide business communities to utilise the tool. Keyrus has developed a unique methodology to train business users to extract relevant information for fast, competent decision-making through a self-service.

Press release

Keyrus wins a prestigious Tableau partner award

March 14, 2022

Keyrus, a leading business intelligence and analytics consultancy in South Africa announced that it has been recognised as a 2021 Tableau Partner Award winner for the following category: EMEA Rising Star. This award is a testament to Keyrus’s achievements as a long-term Tableau Partner and dedication to their customer success.

Expert's opinion

How to maximise your BI investment through business-wide enablement

March 3, 2022

Modern business intelligence (BI) technologies have propelled a surge in demand for a company-wide BI enablement as, for the first time, entire business communities are able to obtain answers from company data via self-service. That empowers them to have meaningful conversations about data, leading to more data-driven business culture. Once people throughout the business have visibility into, and take ownership of, the data, the organisation benefits from speed to insight as well as the ability to make rapid, informed decisions.


A proud Industry Insight Sponsor of ITWeb BI & Analytics Summit 2022

February 22, 2022

Enabling a data-driven business in a post-pandemic world is a topic that we at Keyrus feel very strongly about. Our experts will be taking the stage to contribute to this years' BI & Analytics Summit thought leadership and discussion on the most effective ways of driving business-wide enablement and maximizing the value of your data.

Press release

Namibia Breweries appoints Keyrus to implement their Big Data strategy

January 27, 2022

A leading southern African beverage manufacturer has selected Keyrus, a leader in the Data & Digital consultancy space, to partner on a journey of platform and application modernisation.

Expert's opinion

Delivering true value through IT financial transparency

January 25, 2022

In a services focused world, establishing the actual costs of services remains the key focus; greater levels of granularity are often needed to establish these and to deliver true cost transparency. This is especially true in a shared services environment where a range of administrative and support services, such as IT, HR and financial services, are provided to the entire organisation.

Expert's opinion

The future of business intelligence: 6 key trends

November 18, 2021

Business Intelligence (BI) - has undergone significant transformation in recent years and certainly is not being superseded by artificial intelligence. In fact, it has become more efficient and user friendly since moving to the cloud, utilising AI and machine learning, and its embedded implementation. Today's business leaders know that data is a valuable asset that needs to be used effectively to ensure efficient company processes. They require powerful data analysis tools to help them in the decision-making process. Businesses are embracing sophisticated analytics and data science to gain insights and make more informed decisions, the result; turning your BI department into a profit centre.


Live Webinar - Get to Know Tableau with Keyrus

November 10, 2021

Keyrus, in partnership with Tableau, have assisted organisations to transform how they use data to solve complex business problems, and become more data driven organisations, enabling more informed decision making—do you want to do the same? Register for this live webinar to discover the secrets of a self-service approach to visual analytics.