“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.
Let us know your comments, questions and conerns as you read through the document.
Connect with me on
Jim Kane is the Director of Collaboration and Knowledge Management (KM) at Paragon Solutions. Jim leads the KM practice with a focus on knowledge management and SharePoint-based solutions that support day-to-day business optimization via virtual problem solving, communities of practice, knowledge repositories, role-based communication portals, partner collaboration, and information dashboards. He is co-author of a patent, “Methods of Knowledge Management,” and has over 15 years of experience teaching at the college level as an adjunct instructor. Jim has presented at numerous regional and national conferences on the topics of Knowledge Communities, Adoption Strategies for SharePoint, and Global SharePoint deployments.