70-467 · Question #56
You need to select an appropriate tool for creating the Regional Sales report. Which tools or tools should you use? (Each Answer presents a complete solution. Choose all that apply.)
The correct answer is B. Excel 2010, using a PivotTable C. Report Builder, using a Matrix. A Regional Sales report requires a tool that supports cross-tabular or pivoted data aggregation by region. Excel PivotTable and Report Builder Matrix both provide native row-column grouping with subtotals that fulfill this requirement completely.
Question
You need to select an appropriate tool for creating the Regional Sales report. Which tools or tools should you use? (Each Answer presents a complete solution. Choose all that apply.)
Options
- APower View, using a table configured for vertical multiples
- BExcel 2010, using a PivotTable
- CReport Builder, using a Matrix
- DPower View, using a table configured for horizontal multiples
How the community answered
(61 responses)- A20% (12)
- B72% (44)
- D8% (5)
Why each option
A Regional Sales report requires a tool that supports cross-tabular or pivoted data aggregation by region. Excel PivotTable and Report Builder Matrix both provide native row-column grouping with subtotals that fulfill this requirement completely.
Power View vertical multiples produce a series of small repeated charts stacked vertically for each category, which is a small-multiples visualization style rather than a consolidated tabular regional report.
Excel 2010 PivotTable natively supports grouping sales data by region across rows and columns with aggregated measures and subtotals, making it a complete self-contained solution for a regional sales report.
Report Builder's Matrix data region renders data in a cross-tab format with configurable row groups, column groups, and aggregated cell values, directly mapping to a multi-region sales breakdown with totals.
Power View horizontal multiples produce side-by-side small chart panels for each category value, not a traditional tabular or matrix report layout suitable for a Regional Sales report.
Concept tested: Selecting BI tools for tabular regional sales reporting
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/matrix-report-builder-and-ssrs
Topics
Community Discussion
No community discussion yet for this question.