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 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.”
Stay updated on the latest articles, events, and more
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.
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.
An international player in consulting and technology as well as a Data and Digital specialist, Keyrus has announced new goals for the market via a renewed and inspiring vision. A vision underpinned by its 25 years of global and 10 years of South African expertise in the data and digital sector.
The BI landscape is continually evolving, and rapidly too. The transition from IT-driven BI delivery to self-service analytics continues at pace and is now enhanced by the latest major trend of embedded analytics. The BI environment is no longer something separate from line of business systems. BI and advanced analytics are now being embedded within core operational systems with tangible benefits. So says Barry Burdis, head of delivery at Keyrus, who presented on ‘The value of embedded analytics’, at the ITWeb Business Intelligence Summit 2020.
By Craig Andrew, Senior Consultant and Tableau specialist at Keyrus in South Africa. Choosing the right tool to enable users across the company to perform analytics, publish dashboards and share discoveries is essential for businesses of all sizes to drive success through leveraging data.
The traditional data transformation procedure of extract, transform and load (ETL) is rapidly being turned on its head in a modern twist enabled by cloud technologies. Cloud’s lower costs, its flexibility and scalability, and the huge processing capability of cloud data warehouses, have driven a major change: the ability to load all data into the cloud, before transforming it. This trend means that ETL itself has been transformed—into extract, load and transform, or ELT. ELT offers several advantages, including retention of data granularity, reduced need for expensive software engineers and significantly reduced project turnaround times.
An ambitious, multi-phase digitalisation and automatisation project has provided unparalleled visibility process at SA’s largest mineral freight logistics company Grindrod. Keyrus, a leading business data intelligence consultancy, used cloud-based technologies and Industrial Internet of Things (IIoT) to develop a comprehensive solution that gives Grindrod’s Terminal business significantly improved performance of their operations. The solution highlights the power of modern technology to solve business challenges. It includes a combination of data streaming, analytics, logic matching and visualisation technologies and was designed using a range of Microsoft Azure services, Microsoft SQL Server Integration Services (SSIS) and Tableau visualisation software.
Grindrod can now accurately report on the size of the stockpiles throughout its southern African terminals. This was another module delivered by Keyrus in an ambitious, multi-phase development project that has achieved complete digitalisation of the logistics giant’s Terminal business.
Turning data into meaningful business information Keyrus implements Tableau as embedded visibility layer for Grindrod optimisation project Powerful analytics and data visualisation are critical components of any data automation implementation. For this reason, leading business data intelligence consultancy Keyrus chose Tableau Embedded Analytics as the key visibility layer when appointed to digitalise Grindrod’s southern African Terminal operations. The project has enabled the logistics giant to optimise its entire logistics process and Tableau is playing a key role in enabling faster, data-driven decision-making across the business.
SA’s largest mineral freight logistics company now has comprehensive visibility into its disparate third-party industrial systems. Leading business data intelligence consultancy Keyrus has integrated data from various Grindrod Terminals’ stand-alone industrial systems into the organisation’s operational data to provide a single version of the truth, accessible via dashboards and their Visibility System.