+
DEVELOP A MULTIDIMENSIONAL MODEL TO ANALYZE SALES...

DEVELOP A MULTIDIMENSIONAL MODEL TO ANALYZE SALES...

Rating:
Rating
(0)
Author: Carol 96
Description:

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.

http://theperfecthomework.com/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. 


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial