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.
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
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
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
Vector Logistics embraces cloud-powered modern analytic solutions
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
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.