Power View and Reporting Services - Learning SQL Server Reporting Services 2012 - page 317

Power View and
Reporting Services
This chapter describes how Power View reports are created using SQL Server
Reporting Services 2012 in conjunction with SharePoint Server 2010. The upgrade to
this set will be SQL Server 2012 SP1 and SharePoint 2013. The Power View examples
of this chapter are compatible with SharePoint 2013 (backward compatibility); readers
should access Microsoft SharePoint site for details. As Power View reports are based
on a tabular data model ( TDM ), creating a tabular model using SQL Server Analysis
Services is described together with creating a data source for the Power View report
using SharePoint Server 2010. Also described is a flavor of the rich visualization
experience that you can get working with Power View reports.
What is Power View?
Power View is a Silverlight browser application launched from SharePoint Server
2010, although there are many voices asking to make it independent of SharePoint
Server. In SQL Server Reporting Services 2008, Microsoft had dealt with an earlier
form of ad hoc reporting capability based on report model using multidimensional
data but with Power View it has made the earlier attempt look primitive.
Power View is not exclusive to SharePoint but can be created
using Excel as well, more easily in Excel 2013. Power View using
Power Pivot in Excel is considered sometimes as a junior version
of the enterprise grade Power View in SharePoint. All of these
can change in days to come. With SQL Server 2014 due this year,
Excel may not even need the add-in, and the in-memory business
intelligence capability will be that much more enhanced.