Excerpt from:  Globally AWhere
.
August 07, 2008

Mapping POS Data: De-pivoting the Pivot Table

One of the most powerful benefits of mapping retail sales data is the simple elegance of seeing 3600 sales numbers as colored points, in geographic context, on a map. Sure beats 3600 store IDs.

Just this week we announced a new map-centric business solution aimed at Category Managers for grocery and consumer packaged goods (CPG) manufacturers.  The product is called AWhere CPG and you can check out the announcement here.

 

Category Managers are the bright and focused people that are responsible for the ultimate sales success of high volume consumables that we buy at Walmart, Safeway, Krogers, Target and Walgreens (among several thousand other retail chains.)  Did you know there are 34,000 grocery stores in the US alone?\nEach with 30,000 to 50,000 products?  That’s a lot of data.

 

Category Managers are Excel spreadsheet gurus. Think of it.  If you sell to Walmart, you have more than 3600 retail locations in the US alone serviced by more than 100 distribution centers (DCs).  If you are responsible for a dozen SKUs of juices, each with 20-30 pricing, sales, and inventory parameters: All that together makes for a very large spreadsheet dump.  All referenced by 3600 4-digit store IDs. Whew! I’m feeling numb writing this.

As we developed AWhere CPG with its integrated capability to import POS data from Walmart’s Retail Link® online reporting tool, one of the first and most obvious uses of mapping is simply seeing a products sales velocity painted as 3600 colored points on a US map.  Instead of staring blankly at 30 Super-A pages of Wal-Mart Store IDs (let see, is store #916 or #2717 in Hattiesburg Mississippi, oops, both are!), now you can see at a glance which sales figures go with Chicago and which go with LA.  And, wow! Look at what’s going on in Tucson and South Florida!

 

 

Over the next few days, I’m going to share a few of the first observations that we and our early customers have had with AWhere CPG:  Some we expected. Some were surprises, even to those of us that live and breath maps every day.


Syndication OptionsRSS (Rich Site Summary) Feed Atom Feed OPML (Outline Processor Language) Feed MYST-ML (MyST Markup Language) Content Feed MS-Office Smart Tag Subscription