4 - Grocery Store Data Warehouse Dr. Navneet Goyal...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Grocery Store Data Warehouse Dr. Navneet Goyal Associate Professor Computer Science Department BITS, Pilani
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Processes  Sales  Inventory  Procurement  Order Management  Promotion
Background image of page 2
Value Chain Retailer Issues  Purchase Order Deliveries @   Retailer WH Retailer WH Inventory Deliveries @ Retail Store Retail Store Inventory Retail Store Sales
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The Scenario A chain of grocery stores in the US  100 stores   60,000 individual products on the shelves in each store  6,000 products (on an average) sell each day in a given  store   Each product belongs to a subcategory  Each subcategory belongs to a category  Each category belongs to a department
Background image of page 4
Some Terms  SKU (Stock Keeping Units)  UPC (Universal Product Codes)  EPOS ( Electronic Point of Sales)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
What Management is Interested In?   Ordering logistics  Stocking shelves  Selling products  Maximize profits
Background image of page 6
Data Warehouse: Design Steps Step 1: Identify the Business Process Step 2: Declare the Grain Step 3: Identify the Dimensions Step 4: Identify the Facts
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Star Schema FK FK FK FK Sales Fact Table Location  Dimension Promotion  Dimension Product Dimension Time Dimension
Background image of page 8
The “Classic” Star Schema PERIOD KEY
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

4 - Grocery Store Data Warehouse Dr. Navneet Goyal...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online