retail data mgt

1
© 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

Upload: raj-bhatt

Post on 04-Jul-2015

695 views

Category:

Business


2 download

DESCRIPTION

Methodology for integrating retailer data-sets and reporting for CPG manufacturers

TRANSCRIPT

Page 1: Retail data mgt

© 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