Using Power View in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 130

TABLE 5-1 A comparison of Power View versions

Power View in Excel Power View in SharePoint

Requires Excel 2013 and Silverlight installed on computer Requires supported browser and Silverlight installed on

computer

Uses Excel Data Model or PowerPivot in Excel model as
data source

Uses PowerPivot in SharePoint model or Analysis Services
tabular model as data source

Supports multiple views based on different Data Models Supports multiple views based on a single Data Model

Provides no support for duplicating a view Supports duplication of a view

Provides no support for export to PowerPoint Supports export of views to PowerPoint

Does not display thumbnail images of views for work-
books published to a PowerPivot gallery

Displays thumbnail images of view for reports published
to a PowerPivot gallery

When do you avoid using Power View?
The existence of multiple tools in the Microsoft BI stack reflects the reality that different tools serve
different purposes. As wonderful as Power View is, there are scenarios for which it is not the best
choice. In Chapter 2, “Planning for business intelligence adoption,” we provide an overview of the
available user tools to help you make the appropriate selection. In this section, let's consider the situa-
tions for which you should consider a tool other than Power View:

■ You want to present information that conforms to specific formatting or pagination guidelines,
or you want to make it possible for users to export the report to alternate formats such as
Excel workbooks or PDF files. In this case, you should use Reporting Services.

You want to distribute information to a wide audience by using subscriptions. Again, Reporting
Services supports this requirement.

■

You want to control the user's navigation path from one section of a report to another or from
one report to another. You can develop reports in Reporting Services and use actions to sup-
port this type of navigation.

■

You want users to be able to construct reports or dashboards from prebuilt components.
For this functionality, you can create and publish report parts in Reporting Services or
PerformancePoint components such as scorecards, indicators, charts, and grids for use in
SharePoint.

■

■ You want to explore data that contains many-to-many relationships, such as you might find
with bank accounts that have multiple owners or sales transactions for which multiple sales-
people receive credit.