Multiple choice technology enterprise content management

I want to see number of orders against team size of the team processing the orders. Which is the fact and which is the dimension?

  1. Both are measures

  2. Order count is the measure, Team Size is the dimension

  3. Team size is the measure, Order Count is the measure

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Order count is clearly a measure/fact (numeric aggregate being analyzed). Team size is a dimension - it's a descriptive attribute of the teams processing orders, used to group or filter the order counts. In dimensional modeling, measures are the numeric values we analyze (facts), while dimensions are the context descriptors (who, what, where, when) we analyze across.

Keep practicing — related questions