Skip to content
June 12, 2013 / Erik Svensen

Analyzing OSA (On-Shelf Availability) with Excel 2013 and Power View

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: