You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
Keyrus as an expert in business intelligence (BI) and analytics solutions was again chosen as the partner of choice by Vector Logistics for this project, which followed a highly successful automated sales analytics implementation by Keyrus in 2021.
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 partnership built while developing the initial solution for Vector Logistics meant that our client trusted us once again with their ambitious requirements,” says Stephen Coull, Sales Director at Keyrus, a recognised specialist in recommending and implementing modern technology and business intelligence solutions.
“We applaud the leadership of Vector Logistics for their foresight to invest in cloud technology to future-proof their operating model.”
Watch this short video that summarises the technology solution implemented at Vector Logistics led by Nkosinathi Xulu, Senior BI Developer at Keyrus.
The challenge
The organisation faced several business challenges including an outdated business analytics system. Multiple analytics platforms resulted in duplication of effort, resources as well as costs while existing models were either no longer relevant or unable to offer self-service for business users. The supply chain organisation required a seamless, integrated & fit for purpose analytics platform to allow self-service analytics that would lead to efficient, effective management of resources and costs and drive a single source of truth. It also needed key models to be automated, using the cloud.
The powerful cloud solution
Keyrusdeveloped a cloud-powered analytics solution involving a number of Microsoft Azure and Power BI technologies. The business intelligence specialists at Keyrus leveraged tabular models and Power BI to enable large-scale models to drive self-service capability.
“The solution ensures that sales & route data, pulled from a number of disparate source systems including SAP Business Warehouse (BW), SQL Server, SFTP, and Azure blob storage, is initially staged and massaged before being made available to the tabular model. This model consolidates the data from the SQL staging layer and SAP and presents it in the correct star schema format to the Power BI reporting layer”, explains Nkosinathi Xulu, Senior BI Developer at Keyrus. The architecture, therefore, consists of source, staging, semantic, and presentation/reporting layers.
Technologies used include Azure Analysis Services, Azure Storage Account, Virtual machines, Azure Data Factory, Azure Function Apps, Azure SQL DB, and Power BI Pro.
Tangible benefits
The major benefits can be summed up as improved visibility, reduced manpower requirements, enabled self-service capabilities, and reduced costs. The administration load has also been tangibly reduced.
“We are now benefitting from a 20% improvement in terms of visibility and have reduced our manpower requirements by three and a half hours each week,” notes Ashleigh Jacobs, Supply Chain Intelligence Executive at Vector Logistics about the benefits achieved in their Tabular models.
“In addition, the frequency of updates and distribution of our reports has increased from once a week to daily, and the information is now available immediately via the Power BI mobile app.”
Data has now been consolidated, leading to improved visibility, and users can slice and dice by different data sources.
“Vector Logistics now has a consolidated view of its internal & external sales and planned versus actual transport-related data, one of the major requirements of this project,” adds Coull.
As the solution is completely cloud-based, the client no longer needs to maintain on-premise servers and automation has replaced tedious manual workaround Excel spreadsheets.
“At Keyrus, we use our technical expertise to empower our clients with strategic, actionable, data-driven insights,” concludes Coull. “Beyond simply understanding data, we use it as a driving force for progress and innovation - a means to a better future. We make data matter. We’re experts at tackling complex problems and providing our clients with straightforward, effective, and scalable solutions.”
This article was published by ITWeb
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
Digital transformation of Namibia Breweries' operations
Namibia Breweries chose Keyrus to contribute to its transformation into a data-driven organisation. Keyrus helped to instill a true data culture within Namibia Breweries’ operations.
Success story
Keyrus automates logistics data for Tevo
Keyrus assisted with a rapid, accurate, visible shipping date information system that makes for faster and better-informed customer decision-making.
Press release
Partnering with Pyramid Analytics
Keyrus has become a systems integration and consulting partner for Gartner-recognised, Pyramid Analytics in Southern Africa. This partnership will enable Keyrus's customers to benefit from this unique augmented analytics platform for decision intelligence and accelerate growth for Pyramid Analytics in Africa
Client testimonial
Keyrus and Tableau make data matter
In this age, it is absolutely essential to collect data but even more important is to use it effectively to the organisations’ full advantage - to make data matter.
Expert's opinion
Value of embedded analytics
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, says Adam Walker, General Manager at Keyrus South Africa.
Success story
We are experts in embedded analytics
Keyrus is Tableau Embedded Specialist Partner in Africa and MEA region, recognising our expertise in promoting and implementing Tableau’s embedded BI solution.
Success story
Creating new BI service stream through Qlik platform
Keyrus assists the Kwaden Investments Group to revolutionise its clients’ business landscape and transform their organisations. In the modern information age, data should be considered a precious corporate resource. However, it is only beneficial when coupled with the ability to derive deep insights from the available information by using analytics to provide focused details around business areas such as sales, stock and financial performance.
Expert's opinion
How we 'make data matter' and what are the future trends in business intelligence
Stephen Coull, Sales Director at Keyrus South Africa conducts a captivating interview with a business-technology celebrity Aki Anastasiou discussing key contributors to Keyrus’s success, our unique partnership with Tableau, embedded analytics being the future of BI, and the importance of humanizing data.
Success story
Keyrus is a Tableau PREMIER Reseller Partner in South Africa and EMEA region
South Africa’s leading data and technology consultancy Keyrus has achieved Premier Reseller Partner status in the Tableau Partner Network, becoming the only Premier Tableau reseller in South Africa and also on the African continent.
Success story
Robust cost transparency model for The Foschini Group
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.