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.”
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
Continue reading
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.
Success story
Company-wide BI enablement and self-service at a large retailer
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
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
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.
Event
A proud Industry Insight Sponsor of ITWeb BI & Analytics Summit 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
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
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
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.
Event
Live Webinar - Get to Know Tableau with Keyrus
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.
Press release
Keyrus’s mission is to 'make data matter'
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.