“Power View” is an enhancement of power pivot. You can base a Power View file in SharePoint 2013 with the SQL Server 2012 Reporting Services add-in on an Excel 2013 data model or on a SQL Server 2012 SP 1 Analysis Services tabular model, and vice versa. However, some features, such as hierarchies and KPIs, are only available if you base a Power View report in SharePoint Server with the SQL Server 2012 SP 1 Reporting Services add-in on an Excel 2013 data model or on a SQL Server 2012 SP 1 Analysis Services tabular model.Our Take: Our perspective on using Power View comes in two parts; the first being the
obvious: by using the feature, you could simply solve business problems while harmonizing and exposing the relative data easily through Power View in SharePoint. Secondly, the relationships and their meaningful relationships can be more easily achieved, allowing drill-through properties on varying charts and graphs.
Microsoft has also added a nice customization piece that allows you to add unique images to your charts and graphs that can help make the data they represent more meaningful.
Stay tuned as we release more of this 11-part series from our whitepaper on SharePoint 2013′s newest features right here on our blog for your reading pleasure. But, why wait? You can download the whitepaper in its entirety now.
Let us know your comments, questions and conerns as you read through the document.