The challenge
The worldwide operating retailer fought with the lack of data definition (metadata) and various data sources. Legacy systems prevented the client from joining multiple sources into a single source of truth. Moreover, the need for more strategic and automated ingestions and limited data history restricted a data-driven decision process.
Our client also worked with an incomplete data set required for valuable big data analytics and predictive analysis. The retailer needed to calculate the workforce and routes for the next day to decrease expenses and increase positive fulfillment. At that point, the retailer reached out to VirtusLab.
The solution
VirtusLab (VL) leveraged Hadoop and Hive technology to integrate with the client’s system. In cooperation with our client, creating a reliable data platform was the base for more advanced predictive analytics. VL integrated data such as van weight, van trap capacity, time of travel, time at the door, and the optimal routing of delivery vans. Yet, we saw the need to integrate more data sources and collect relevant data to make efficient predictions.
Since depots held frozen, fresh, and ambient products, the fulfillment structure needed to be considered. National and regional locations of depots meant cheaper and more successful operations. As a result, the analysis had to consider the time and costs of delivering from a depot to a store.
The results
VirtusLab made impressive cost cuts every year by reducing the spent-on transport, and operational costs, thus achieving a solid ROI for our client through predictive analytics. For instance, we developed a graph processing framework to compute complex predictions about the delivery speed of grocery vans at any time and day, using the van’s tracking data and delivery schedules.
We improved the client’s delivery schedule accuracy and, therefore:
- Saved £ 500k with a prediction of the driver’s way from store to store, or customer to customer
- Saved £ 500k – £600k with a prediction of a driver spending time at a door
- Increased order fulfillment by 0.2%
The tech stack
Languages: Scala, Python, Bash
Database: Hive, Hadoop
Eventing Platform: Kafka
Infrastructure: Spark, Oozie, Splunk, Ansible, Jenkins, Git
Partner flexibly with VirtusLab
Use one or a combination of engagement models to suit your needs.
Take the first step to a sustained competitive edge for your business
Let's connectVirtusLab's work has met the mark several times over, and their latest project is no exception. The team is efficient, hard-working, and trustworthy. Customers can expect a proactive team that drives results.
VirtusLab's engineers are truly Strapi extensions experts. Their knowledge and expertise in the area of Strapi plugins gave us the opportunity to lift our multi-brand CMS implementation to a different level.
VirtusLab has been an incredible partner since the early development of Scala 3, essential to a mature and stable Scala 3 ecosystem.
VirtusLab's strength is its knowledge of the latest trends and technologies for creating UIs and its ability to design complex applications. The VirtusLab team's in-depth knowledge, understanding, and experience of MIS systems have been invaluable to us in developing our product. The team is professional and delivers on time – we greatly appreciated this efficiency when working with them.
