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.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Keyrus automates logistics data for Tevo

Innovative products distributor, Tevo, now benefits from full visibility into the key shipping dates vital for its business. This follows the implementation of an automated logistics data system by the experts at Keyrus. The result? Increased accuracy in forecasting as well as speedier and more informed decision-making.

The challenge

Tevo is a South African business specialising in sourcing, developing, marketing, and distributing innovative, high-quality products that enhance the lives of their end-users.

Understanding its stock holding is critical to Tevo’s sales and distribution and forms the basis of its daily forecasts. The business needs a finger on the pulse of exactly what is in the warehouse and when more products will arrive from overseas suppliers.

Making this exceedingly challenging was a lack of timely information regarding when containers would arrive in South Africa. In the past, Tevo had to contact the shipping companies directly for this information. This process was time-consuming and prone to human error.

The solution

Tevo turned to the experts at Keyrus, with whom it has a long-standing working relationship.

Keyrus is a trusted partner to customers across various industries, assisting with their data and digital transformation journeys. It has a particularly rich proven track record of applying technology solutions in the retail industry.

“We decided to engage Keyrus to build an automated system to deliver this crucial shipping information,” says Jared Davey, Business Intelligence Manager at Tevo.

“A key dependency was to obtain buy-in from the shipping companies themselves,” comments Nathi Xulu, Head of Data Engineering & Principal Consultant at Keyrus. “Tevo, Keyrus, and the shipping lines would have to work collaboratively to complete this project.”

Having obtained the required buy-in, Keyrus designed a solution involving SQL Server Integration Services (SSIS) and a SQL Server database-driven LOB system. SSIS extracts data from FTP text files and the database. This data is then transformed and combined, using TSQL scripts and SSIS, before being loaded into SQL Server Analysis Services (SSAS) cubes where it is accessed by various BI tools.

Tevo’s product managers use SQL Server Reporting Services (SSRS), a data visualisation and reporting tool, as well as Microsoft Excel to view reports.

Benefits

“Keyrus helped us to solve the complex challenge we faced to acquire timely data about key shipping dates,” says Jared Davey. “Combining some of these key metrics along with other key metrics from our ERP system offers full visibility into this critical shipping information.”

Rapid, accurate, visible shipping date information makes for speedier and better-informed decision-making within the organisation.

There is now a reduced risk of error. The automated system has bypassed the need for human interaction. Tevo no longer needs to try and contact individuals at the shipping companies to obtain key information.

The new system consolidates all information into one comprehensive report, improving efficiency and visibility.

“On top of this, we are able to perform analytics around the data which is now stored within our environment, without the administrative burden associated with manual interventions to obtain the data,” adds Jared Davey.

“It is a privilege to work with an innovative company such as Tevo,” notes Xulu. “We celebrate their drive for innovation in everything they do, and their ambition to deliver the best value and quality to their consumers.”

Keyrus prides itself on its hands-on approach to the solutions it delivers. Its global reach enables the team to draw on the best practice, knowledge, and experience of its international teams of experts.

“Keyrus is a recognised expert and trusted partner, focused on making our customers’ data matter,” concludes Xulu.

This article was published on ITWeb

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

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

Press release

Partnering with Pyramid Analytics

January 12, 2023

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

November 23, 2022

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

August 20, 2021

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

September 12, 2022

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

September 9, 2021

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

June 15, 2022

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

May 27, 2022

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

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.

Logo - Keyrus
Durban

10 Flanders Drive Mt Edgecombe 4302 Kwazulu Natal

Phone:+27 87 350 8860

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection