Your manager asks you for a report on profit by customer. We learned about facts (or measures) and dimensions. Which is the dimension?

Question

BlackTom AI · Accepted Answer

In data warehousing and analytics, facts (or measures) are numeric values that you want to aggregate, such as Profit, Revenue, Sales Quantity, etc. Dimensions, on the other hand, provide context for those measurements and are the ways you want to slice and dice the data.

Option 1: Profit. This is a numeric value that you would typically aggregate (e.g., sum of profit) in a report. It represents a measure, not a dimension, so this choice is incorrect as the dimension.

Option 2: Neither is a dimension. This would imply that both Profit and Customer are not dimensions, which contradicts the standard modeling where at least some attribute is used for grouping. Since customer is commonly used to group or segment data, this option is inaccurate.

Option 3: Customer. Customer is a descriptive attribute used to categorize or group the data (e.g., profit by customer, or profit by region by customer). It provides the context for the measure and is the correct example of a dimension in this scenario.

Putting it together, the task asks which item serves as a dimension when reporting profit by customer. Since Profit is the numeric measure and Customer is the category by which you break down that measure, Customer is the dimension.

Your manager asks you for a report on profit by customer. We learned about facts (or measures) and dimensions. Which is the dimension?

查看解析

登录即可查看完整答案

类似问题

Data Warehousing B Match the aspects/components to their role in the model (choose the most specific role/term that applies). 1: Amount 2: Business 3: BankExpenditure 4: Country 5: TypeCategory 6: ‘Customer making a purchase’

Dimensional databases are used to track historical data, and therefore must have a(n) ________.

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单