OSA or OOS (Out of Shelf) is a huge issue for retailers and their suppliers. However identifying the stores or products where the OSA is a problem has required a lot of visits to the stores either by suppliers field force or by using crowd sourcing agents – like Gigwalk, Jobwalk, Fieldagent or similar.
However if you have access to POS data from the retailer – Store by Store – you can analyze the issues by using Excel 2013 and Power View.
By creating a PowerPivot model on the POS data and create measures to calculate average sales and identify the weeks with low or zero Sales, you will now be able to track, analyze, filter and last but not least plot it on a map using Power View.
In this example there is more than 1 million records and within 2-3 seconds I am able to visualize the lost Sales by Category and Store within a region using Power View in Excel.
I knew that PowerPivot was a powerful tool – but this is amazing.
At a later point I hope to find time to create an in-depth example but just had to share my excitement about this.