The Challenge
A leading UK grocer implemented a process to migrate inventory data
from a legacy system to a new system. The two systems tracked the
movement of inventory at outlets across the grocer’s estate. It was noted
that there was a wide discrepancy between the two systems but this
was often noticed when problems arose at an outlet, when it was too late to
resolve, rather than through alerts or through any trend analysis.
The challenge was to collate the data from the two systems into a common
datasource where the metrics could be compared for analysis in a
dashboard.
A stated aim of the project was to address the following: ‘This dashboard
should provide a view of any issues regarding variance of inventory on a
location or item level. It would be ideal to be able to drill down or filter to
specific locations and then even further to identify products that have high
levels of variance.’