Database Reference
In-Depth Information
Self-service reporting with Power View
While SSRS is a great solution, companies frequently need to go beyond these static
reports to visualize their data in different ways to help them make better business
decisions. This is where Power View comes into the picture. Power View is an
easy-to-use solution that allows users to quickly create highly-interactive and
visual reports that can be accessed in a variety of different ways and from different
devices. The reporting experience is greatly simplified as there are no setting
properties on objects, no design mode, no creating of relationships with the data,
and no connecting items together for filtering. The following screenshot shows a
report being created in Power View:
Creating a report in Power View
Introduced with SQL Server 2012 and integrated with the SharePoint Enterprise
edition, Power View has become very popular due to its ease of use and the ability
to generate very useful and cool looking reports. It was first available only through
SharePoint Server (Enterprise edition), but now it is available as an Excel 2013
add-on in the Office 2013 ProPlus edition.
Power View in SharePoint can connect to Excel PowerPivot workbooks and SSAS
multidimensional models and tabular models (also known as cubes). An Excel
PowerPivot workbook can use many different data sources such as SQL Server,
SQL Azure, text file, and Microsoft Access.
