70-467 · Question #171
You are designing a self-service reporting solution based on published PowerPivot workbooks. The reporting solution must allow users to perform the following tasks: - Easily create reports. - Create…
The correct answer is C. Power View. Power View is the purpose-built self-service BI tool for PowerPivot workbooks, offering drag-and-drop report creation and polished, interactive visualizations with minimal effort.
Question
You are designing a self-service reporting solution based on published PowerPivot workbooks. The reporting solution must allow users to perform the following tasks:
- Easily create reports.
- Create report queries by dragging and dropping fields.
- Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements. Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- AReport Builder
- BReport Designer
- CPower View
- DMicrosoft Excel
How the community answered
(62 responses)- A3% (2)
- C95% (59)
- D2% (1)
Why each option
Power View is the purpose-built self-service BI tool for PowerPivot workbooks, offering drag-and-drop report creation and polished, interactive visualizations with minimal effort.
Report Builder targets IT-level report authors who write formal paginated reports; it is not optimized for self-service PowerPivot consumption or quick drag-and-drop interactivity.
Report Designer is a developer-facing tool inside Visual Studio for building structured SSRS reports; it requires significant technical skill and is not a self-service end-user tool.
Power View is specifically designed for self-service reporting on top of PowerPivot data models and SharePoint. It provides an intuitive drag-and-drop field interface and renders presentation-quality, interactive charts and tables with minimal configuration, directly satisfying all three stated requirements.
Microsoft Excel can connect to PowerPivot models, but it does not natively produce presentation-quality reports with minimal effort the way Power View does, and it lacks built-in drag-and-drop visualization canvas.
Concept tested: Power View self-service reporting on PowerPivot models
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/report-builder-in-sql-server
Topics
Community Discussion
No community discussion yet for this question.