DEVELOP A MULTIDIMENSIONAL MODEL TO ANALYZE SALES OF 40,000 PRODUCTS OVER 5 YEARS IN 300 STORES REPORTING DAILY SALES FOR EACH TYPE OF PROMOTION.
Develop a multidimensional model to analyze sales of 40,000 products over 5 years in 300 stores reporting daily sales for each type of promotion. Each promotion has a name, a promotion cost, a start and end date, and may be a display type, coupon type, or media type. About 4000 products are sold in each store daily. There are categories of products and different product brands. The 300 stores are located in sales territories in different regions in the U.S. Sales are tracked by cost and units sold. A sold item is in only one promotion per store per day.
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. -10 points
Step 2 - Declare the Grain -5 points
Step 3 - Identify the Dimensions -10 points
Step 4 - Identify the Facts - 10 points
Step 5 - Show the Data Model - 10 points
You can draw the model and scan the model into MS Word Document or use an ER Design Tool and copy into Word (be sure the MDM is readable).
Step 6 - Validate the Model - 5 points
Review the Dimensions and Facts and evaluate how these correspond to the grain as well as the business process.