Project Description

Travis Perkins

Digital Transformation to Reduce Inventory and Maximize Availability

About The Client

Travis Perkins is a leading British builders merchant and home improvement retailer operating 21 distinct businesses across its branches, with more than 100,000 stock keeping units (SKUs) to manage.

The Challenge

Travis Perkins wanted to reduce inventory while maximizing availability. New capabilities were needed to optimize store inventories and analyze product performance across many attributes through analysis of huge volumes of data. More than 100K products, substitute products, and 1000+ branches of multiple types made this a daunting problem.

Business Impact

0%
Annual Revenue Growth

Project Highlights

0
Brands
0+
Data Feeds
0+
Metrics

Technology

Cloud

aws-logo

Analytics

sas-logo

Data Management

postgresql-logo

Data Processing

apache-spark-logo

Data Processing

hadoop-logo

The Solution

Core Compete developed a comprehensive bespoke solution for weekly performance reviews and analysis across many attributes. The new solution enables end-to-end annual line reviews, collaboration, and ‘what if’ analysis to simulate product change impacts throughout the supply chain, store-SKU assignments and direct integration into replenishment systems.

Business Components

  • Assortment Optimization to get the right product to the right store
  • End-to-End integration to simplify planogram analytics and execution across multiple banners
  • Analytics that help understand merchandise performance across dimensions like customers, transactions, inventory, sales, promotions etc.

Technical Components

  • Data from POS, Inventory, Warehouse Management, Replenishment and CRM systems were aggregated in a transient Spark cluster and then loaded into a persistent Hadoop platform
  • Real-time integrations enable communications of planogram and inventory decisions to the downstream operational systems
  • Cloud-based infrastructure enables easy changes to the network such as branch closures and brand divestitures

Core Compete in Action

To drive maximum value from the big data and analytics solution, Core Compete brought together the right components in four critical areas.

Domain Expertise – Our retail solution architects designed a data lake that integrated large volumes of data including Invoices, Daily Inventory, Customer Master, Planograms, and Trade Promotions. A comprehensive data model enables dynamic insights spanning sales, market basket, and performance related to inventory, promotions, planograms, and branch-specific metrics.

Analytics Innovation – Several retail analytics areas were integrated to facilitate end-to-end assortment workflows including Assortment (product-branch) scoring, market basket analyses, and automated outlier detection and elimination to compute standard rates of sale for products.

Technology Know-How – The solution was deployed on a Hadoop Data Lake on AWS. Spark was used for automated aggregation routines to address complex large-scale calculations. SAS platform enables visualizations and analytics. Core Compete provides 24/7 management of the environment allowing the client to focus on their business.

Agile Delivery Methodology – The solution was delivered in phases over a 9-month development and delivery cycle. Within 12 weeks, the data lake was deployed with more than a dozen weekly performance and attribute-based analytics dashboards. Subsequent phases addressed planogram management and comprehensive annual line review workflows.

The Result

Travis Perkins has moved closer to the goal of reduced non-productive inventory through a deeper understanding of range performance that drives effective actions. Another big benefit is the elimination of multiple weeks of latency through instantaneous impact analysis of range changes on the supply chain. Changes to the range can now be executed far more easily with more collaboration.

Solution Architecture

  • Industry: Retail

  • Revenue: $6.74 Billion

  • Location: United Kingdom

  • Employee Base: 29,000+

About The Client

Travis Perkins is a leading British builders merchant and home improvement retailer operating 21 distinct businesses across its branches, with more than 100,000 stock keeping units (SKUs) to manage.

DATA 2000 semi-layered

Let’s Connect

Make a connection with one of our specialists to:

  • Learn how cloud analytics can drive business value in your organization
  • Understand how other companies are transforming their business and using AI and ML
  • Identify specific use cases where you can implement a transformation project as soon as 3 months
Request a Briefing