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