Normal
0

false
false
false

EN-US
X-NONE
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”,serif;}

Midterm Exam

Part 3 (50 points) Multidimensional Model

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. -5 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 and validate the model – 20 points