Assignment

You are working on a DW/BI project for a clothing retailer. They want to better understand the details surrounding what's selling in each store.

Develop a multidimensional model to analyze sales of 75,000 products over 5 years in 300 stores reporting daily sales for each type of promotion. Each promotion has a name, promotion description, promotion offer, a start and end date. The 300 stores are located in sales territories in different regions in the U.S. Sales are tracked by cost and units sold.

Document any assumptions you make. (If you had a customer, these assumptions would have to be clarified with the customer. Since there is not a customer for the test, your assumptions will be included in the evaluation.)

Step 1 - Choose the Business Process, Describe the Data Warehouse. Define the questions that the Data Warehouse will answer.

Step 2 - Declare the Grain

Step 3 - Identify the Dimensions

Step 4 - Identify the Facts

Step 5 - Show the Data Model and validate the model.