A sales manager wants a dashboard that shows sales aggregated by region and identifies high-volume sales by salesperson per region. Which of the following techniques best displays this information?

Enhance your skills with the CompTIA Data+ Certification Test. Engage with flashcards, tackle challenging multiple choice questions, complete with hints and explanations. Get yourself exam-ready now!

Controlling how data is aggregated across different dimensions is what this item tests. Level of detail lets you fix the calculation at a specific granularity—such as region—while still allowing additional breakdowns inside that granularity, like listing each salesperson within each region and identifying who has the highest sales.

Using Level of Detail, you can compute a regional total (aggregating all sales within each region) and simultaneously compute per-salesperson sales within those regions. This lets the dashboard show the region totals and, inside each region, highlight the high-volume performers. For example, you might use a fixed-grain calculation to get regional totals, and another calculation to assess sales by salesperson within each region, then present these in a single view (such as a regional map with nested bars or a matrix).

Defined parameters are about letting users change values, not how data is aggregated across dimensions. Filter options control which data points are visible but don’t establish multi-level aggregation necessary to show totals by region plus per-region, per-salesperson detail. User persona relates to audience needs, not the data calculation or the visual layout.