Microsoft Sql Server 2012 Power View

1. Microsoft Sql Server 2012Power View ArjunKrishnamoorthi Twitter: @DataLocoAK

2. What is Power View • 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 (in-memory 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.

3. What is Power View con’t • Always presentation ready • Export Power View report to PowerPoint and interact with it through that interface. • Based on Tabular models • Visual design experience • 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. • Performance • 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.

4. System Requirements • 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

7. How Does it Work • 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.

8. Demo