Transcript Microsoft Sql Server 2012 Power View

Arjun Krishnamoorthi
Twitter: @DataLocoAK




Power View enables self-service BI by providing simple to use ad-hoc
reporting for business users and decision makers.
Power View provides an interactive data exploration, visualization,
and presentation experience.
Power View is a browser-based Silverlight application which can be
launched from SharePoint 2010.
Users can create rich visualizations and interact with data from BISM
models including:

SSAS Tabular models deployed to SSAS instance in Tabular mode available in SQL
Server 2012 RTM.

PowerPivot workbooks deployed to Sharepoint 2010 PowerPivot Gallery.

SSAS Tabular models and PowerPivot are based upon the VertiPaq engine (inmemory analytics engine), which is now renamed to xVelocity as of March 9, 2012.

SSAS Molap engine in future, based upon conversation with SSRS product manager.




Always presentation ready
Export Power View report to PowerPoint and interact with it through that
interface.
Based on Tabular models
Visual design experience






Performance


Similar MS Office ribbon.
Easy data switching between visualizations at all times. No design vs. run-time.
When creating data visualizations always start with a table then switch between different
available visualizations such matrices , bubble charts, bar and line graphs, and even small
set of multiple charts.
Easy filtering and highlighting of data because Power View knows the relationships
between the data based upon the underlying metadata.
Easy sorting of tables, matrices, bar and column charts, and small sets of data either
ascending or descending on attributes or measures.
Power View retrieves rows needed for the data visualization. Even if the underlying table
contains millions of rows, Power View only fetches rows needed for the visualization at
the time.
Queries

Power View runs DAX queries against the Tabular models.







SQL Server 2012 RTM – SSRS feature available in Enterprise
(Developer also) and Business Intelligence versions.
Also, SSAS Tabular and PowerPivot for SharePoint are only available
in Enterprise and BI versions.
Web browsers support includes IE 7,8,9, Firefox7, and Safari 5.
SharePoint 2010 Enterprise edition is required with SP1
recommended. Reporting Services Add-On for SharePoint products is
added from the SQL Server 2012 onto SharePoint server.
Microsoft Silverligh 5.
If using SSAS Tabular engine, multiple hops, and need to secure the
data at the cell level then Kerberos authentication will have to
configured.
Installation checklist available on MSDN which provides details on
installation and configuration of SQL Server 2012 BI features with
Sharepoint.

http://msdn.microsoft.com/en-us/library/hh231671(v=sql.110).aspx




Pull data from the source systems into either PowerPivot or SSAS
Tabular models.
Define relationships between the data in the tables. Author any DMX
formulas for calculations.
Publish the PowerPivot workbook to SharePoint or deploy the SSAS
Tabular model to the server.
Power View visualizations can be built using a tabular model
connection in any of the following three ways:



PowerPivot for SharePoint workbook published in a PowerPivot Library view
(Gallery, Theater, or Carousel) in SharePoint.
BISM report server data source (.rsds) type published in a SharePoint Report Library
that connects to a database running on SQL Server 2012 SSAS Tabular mode server.
BISM Connection file (.bism) published in a SharePoint Report Library which can
connect to any of the following:
 Database running on SQL Server 2012 SSAS Tabular mode (Windows
authentication only).
 PowerPivot for SharePoint workbook. Workbooks can be created in SQL Server
2008 R2 or SQL Server 2012 versions of PowerPivot for Excel.