nerdexam
Microsoft

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.

Design a reporting solution

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)
  • A
    20% (12)
  • B
    72% (44)
  • D
    8% (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.

APower View, using a table configured for vertical multiples

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.

BExcel 2010, using a PivotTableCorrect

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.

CReport Builder, using a MatrixCorrect

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.

DPower View, using a table configured for horizontal multiples

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

#Power View multiples#Excel PivotTable#Report Builder#tool selection

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice