Dashboard Showing Inventory Accuracy

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.

REQUIREMENT

The national supermarket retailer required a dashboard which would give an interactive visualisation of the current paper and electronic reporting, so 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

SOLUTION

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