Reference no: EM133036789

CAN YOU HELP ME ABOUT THE EXPLANATION .JUST A SHORT EXPLANATION.IF MY VALUE IS WRONG YOU CAN MAKE A CORRECTION

The Question :

Different Dimensions

The focus of data warehousing is to extend the transformation of data into information. Data warehouses offer strategic level, external, integrated, and historical information so businesses can make projections, identify trends, and make key business decisions. The data warehouse collects and stores integrated sets of historical information from multiple operational systems and feeds them to one or more data marts. It may also provide end user access to support enterprise wide views of information.

You are currently working on a marketing team for a large corporation that sells jewelry around the world. Your boss has asked you to look at the following dimensions of data to determine which ones you want in your data mart for performing sales and market analysis (see Figure AYK.1). As a team, categorize the different dimensions, ranking them from 1 to 5, with 1 indicating that the dimension offers the highest value and must be in your data mart and 5 indicating that the dimension offers the lowest value and does not need to be in your data mart.

The answer

Dimension	value (1-5)	explanation
product number	2
store location	1
customer net worth	1
number of sales personnel	2
customer eating habit	5
store hours	1
sales person Id	1
product style	1
order date	3
product quantity	1
ship date	3
current interest rate	5
product cost	1
customer political affiliation	5
local market analysis	1
order time	2
customer spending habits	1
product price	1
exchange rate	3
product gross margin	1

Dimension	value (1-5)	explanation
season	4
promotion	2
payment method	5
commission policy	3
manufacturer	3
traffic report	5
customer language	5
weather	5
customer gender	2
local tax information	2
local cultural demographics	1
stock market closing	5
customer religious affiliation	3
reason for purchase	1
employee dress code policy	4
customer age	2
employee vacation policy	5
employee benefits	5
current tariff information	3