Microsoft Office Tutorials and References
In Depth Information
Figure 3-29. View a report authored using SharePoint List data
Power View is a Silverlight-based web client for ad-hoc data analysis and interactive data visualizatons. It is part of
the SQL Server 2012 Reporting Services Add-in and runs within SharePoint. This feature is available only within a
SharePoint Reporting Services native mode installation and will not be able to run Power View reports.
Until recently, Power View could work only with Analysis Services Tabular models. Power View internally
sends DAX queries to the back-end model, gets the required results, and renders them in the view. The traditional
SSAS cubes (Multidimensional cubes) used to accept only MDX queries, not DAX Queries. Microsoft recently added
DAX support for Multidimensional cubes. You will be able to use Power View with Multidimensional models now.
More details on this can be found at http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-
There are good reasons to use Power View for data visualization compared to other data visualization tools such
as Excel and Performance Point Services:
End users can quickly build highly interactive and visually appealing dashboards.
Power View, by default, provides cross-filtering capabilities across charts: selecting an item in
one chart can automatically filter data in other charts based on the current selection.
There’s no need to establish a connection between filters and charts explicitly to filter data.
A Power View report can be exported into PowerPoint, and you can interact with the charts
within PowerPoint as you do on the SharePoint site.
power view needs the Silverlight add-in to be installed on users’ machines to be able to author or view reports.
Creating a Power View Report
Bulding an interactive Power View report is quick and easy. Unlike a traditional SSRS report, fully functional Power
View reports can be built right within the browser. SQL Server Data Tools is not required for building Power View
Reports. Let’s build our first Power View report now.
Search JabSto ::