Your manager asks you for a report on profit by customer. We learned about facts (or measures) and dimensions. Which is the dimension?单项选择题
A
Profit
B
Neither is a dimension
C
Customer

Question

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

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) ________.

Name the Supreme Court decision that removed financial constraints on PACs.

Political scientists Joshua Kalla and David Broockman find that senior policy makers made themselves available to _____ between three and four times more often than they did to constituents.

Name the political scientist who argues that parties are designed to serve the needs of ambitious politicians (namely candidates and officeholders).

Name the political scientist who said this famous quote about the problems of pluralism: “The flaw in the pluralist heaven is that the heavenly choir sings with a strong upper-class accent.”

What is the name of the third party candidate in 2000 who was not allowed to participate in the presidential debates? Hint: We watched a video clip with him in class.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单