A national supermarket retailer with 2,400 stores and online shopping service with over 3,000 own brand product lines required the support of RGIS. The supermarket retailer offers customers distinctive, quality products at competitive prices across food, general merchandise, clothing and financial services. Driving efficiency in day-to-day operations enables them to invest in the customer offers in areas that they value: choice, quality, low prices, convenience and great service.
THE CHALLENGE
The customer required RGIS to provide the following:
- A dashboard to be built, which would give an interactive visualisation of the current inventory reporting
- To understand the top five losses and gains
- To be able to filter options for branch, stocktake date, ops group code, Super LG and LG
- Give ranking tables which can be adjusted with filter options
- Drill down to SKU (Stock Keeping Unit) level available
- Easy to understand charts
Why RGIS?
The national supermarket retailer required a dashboard which would give an interactive visualisation of the current paper and electronic reporting.
Our Solutions
The national supermarket retailer partnered with RGIS to complete the inventory dashboard project, and provided the following:
The skilled RGIS team designed and built a database to store raw data
Modified datasets to visualise multi-branch information were created
Branch KPIs were identified
Bespoke dashboard visuals were designed
Aggregated view for roll up data were created
Results
The national supermarket retailer found by outsourcing the inventory dashboard project to RGIS, the following results were achieved:
Improved individual store and company-wide performance
By identifying losses and gains, focus could now be applied by branch to decrease the losses and maximise the gains
Due to being able to export to excel, data could be shared with other departments that did not have access to the dashboard
A clear view of the current position at any time of key metrics
Conclusion
By partnering with RGIS to design and implement a bespoke inventory dashboard, the national supermarket retailer transformed complex stocktake data into clear, actionable business intelligence. The interactive, filterable reporting structure enabled management to quickly identify the top losses and gains, analyse performance by branch and operational grouping, and drill down to SKU level with confidence. With real-time visibility of KPIs and the ability to export and share data across departments, the retailer gained enhanced control over inventory performance, enabling targeted interventions to reduce losses, optimise gains and drive measurable improvements across the estate.
