Background
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. Based on the partnership built over several years, Tevo turned to the experts at Keyrus for this business challenge.
Challenge
Our customer who sources and distributes innovative products from many domestic and international suppliers was lacking understanding of its stock holding which is critical to Tevo’s sales and distribution and forms the basis of its daily forecasts.
Approach
Keyrus was engaged to build an automated system to deliver crucial shipping information and consolidate it into one comprehensive report available throughout the customer's organisation. A key dependency was to obtain buy-in from the shipping companies themselves, which required collaborative work between the customer, shipping companies and Keyrus. Once in place, 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.
Key results
Benefits
Customer now has access to timely data about key shipping dates. Combining some of these key metrics along with other key metrics from their 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. Additionally, the customer is now able to perform analytics around the data which is now stored within their own environment, without the administrative burden associated with manual interventions to obtain the data from external sources/locations.
What our clients say
Keyrus helped us to solve the complex challenge acquiring timely data about key shipping dates. Automating these key metrics offers full visibility into this critical shipping information.
Jared Davey, Business Intelligence Manager, Tevo
Share this key play
