Develop a multidimensional model to analyze sales

Assignment Help Database Management System

Reference no: EM131897967

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.

Reference no: EM131897967

Questions Cloud

Create an array of ten thirty two bit signed integers : Create an array of ten 32 bit signed integers and then look for a specific number in that array. If you find the number then print it other print a message.

What is the validated tool that will be used to collect data : What is the validated tool that will be used to collect data and Are the research hypothesis statements written clearly and correctly

Premium is for compulsory insurance : What is the difference between the two? Calculate the premium for someone in class 20 for 10/20/5. Note: This premium is for compulsory insurance.

Describe the daily activities in brief : Summary of Job Activities: Describe your daily activities: projects, meetings, etc. and reflect on your learning. What stands out as your most critical moment.

Develop a multidimensional model to analyze sales : 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.

Perform market research and maintain accounts : Global Advertising, Inc. (referred to as "GAI") has hired you as an IT consultant for implementing their Windows. Perform market research and maintain accounts.

What size sample would be necessary to find : What size sample would be necessary to find, with 95% confidence, the true population proportion, p, to within 2.5% if you had no idea what the true proportion

Complete a financial risk assessment : Taking on the role of a CEO, develop a PowerPoint presentation of approximately 15 slides that explains how you would adapt the Western leadership strategies.

Money market account that averages return : James has no outstanding debt and invests all her money in a money market account that averages a return of 0.85%

User Account

All Pages