Use the four steps matrix method to design a data warehouse logical model (Dimensional Model) for the business case summarized in the following points:
- Retail chain consists of over 100 grocery stores in 50 states
- Stores average 60,000 stock keeping units (SKUs) in departments such as frozen foods, dairy, etc.
- Bar codes are scanned directly into the cash registers' point-of-sale (POS) system
- Items are promoted via coupons, temporary price reductions, ads, and in-store promotions
Analytic Requirements:
- Need to know what is selling in the stores each day in order to evaluate product movement, as well as to see how sales are impacted by promotions
- Need to understand the mix of items in a consumer's basket