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?

View Explanation

Log in for full answers

Similar Questions

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:

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler