Getting the Most from Stocktaking Data Using the RGIS Dashboard

Sainsbury’s partnered with RGIS to consolidate the data captured at each stock take and gain insights into store and product performance.

REQUIREMENT

Sainsbury’s Loss and Prevention Department partnered with RGIS to gain greater insights into a largely unused data set. That would not have been a priority for internal reporting teams:

  • There was unexplored value in the data being captured, but with no internal resource. To analyse the data and deliver the insights, this was outsourced to RGIS
  • There was a need to consolidate data from multiple vendors for a full picture of exposure performance. That could be drilled into by store, by region, and by product category

SOLUTION

RGIS built a web-based dashboard for Sainsbury’s, with multiple user access:

  • Daily automated transfer of data, eliminated manual transfer of multiple data feeds and enabled data preparation, cleansing, alerts and archiving to be actioned prior to refresh of the dashboard
  • RGIS worked with Sainsbury’s to scope the required KPIs, along with expected drill-down capabilities for each view
  • Standard reports were created that can be accessed in a self-serve manner with up-to-date information, with optional development for new requirements/reports ongoing
  • On-site training for users with ongoing support when needed

RESULTS

Sainsbury’s have an online tool, with external Analyst support, that consolidates vast amounts of data:

  • The dashboard offers a ‘self-serve’ approach to multiple users, from users who want a high level summary of performance, to analysts who want to extract and manipulate the data themselves
  • There are four years of data securely archived, with two years of data to view for year-on-year trending
  • The automated updates of standard reports allow users to view their data online, but also schedule updates or download and view on the move