retail data mgt
DESCRIPTION
Methodology for integrating retailer data-sets and reporting for CPG manufacturersTRANSCRIPT
© Knowledge Foundry 2008
Integrated Data Base (IDB)
Data Integration
• Integrate across retailers using UPC
• Match UPC with product hierarchy
• Match store master ZIP with ZIP hierarchy table
IDB
Data sets
• Sales summary (at various levels)
• Stock-out report
• Retailer comparison
• Velocity report• Geo rollups• Sales trend charts
• Ad-hoc queries and analysis
Reports
Retail datasets*
Store Masters
ZIP hierarchy
Mfr Product Master
…
Shipment database
Retail Data Management and Reports for CPG brands
* Information on store-level weekly sales, inventory for each UPC from Wal-Mart Retail Link, Target, CVS, Walgreens, Kroger, Kmart, etc