1. SQL Server 2012 Business Intelligence A Tour of the Next Generation of BI

2. Welcome!

3. Our Tour Today of SQL 2012 BI • Data Modeling • Tabular Modeling in SSAS • Data Presentation • PowerView Reports

4. What We’re Building • DW/BI solution for CAA Athletics • NFL Analytics • Requested functionality • SharePoint 2010 front-end • PowerView • Excel 2010 support for ad-hoc analysis • PowerPivot models

5. SQL Server BI: The Product Roadmap Source: http://sqlblog.com/blogs/jorg_klein/archive/2010/11/15/analysis-services-roadmap-for-sql-server-denali-and-beyond.aspx

6. Corporate BI Enterprise Data Analytic Data NFL MLB NFL Presentation Tools NHL NBA MLB Consume ETL NBA Data Warehouse Enterprise DW Process

7. Self-Service BI: A Paradigm Shift Enterprise Data NFL MLB User’s Machine ETL, Process, Consume NHL NBA

8. Which Then Begs the Question of BI Professionals…

9. Bridging Self-Service and Corporate BI • PowerPivot: modeling, extraction, and analytic tools to the end-user • External data sources, databases, CSV’s, etc • Corporate BI distills PowerPivot models from the business • Adds value through consistencyand durability

10. SSAS Tabular Models: The Bridge • “Relational” approach to modeling of SSAS cubes • The “PowerPivot” Method • Separate product from multidimensional • Simpler, better responsiveness to change • Bridges self-service BI (PowerPivot) with corporate BI • Option to re-use PowerPivot Workbooks as starting points

11. SSAS Tabular Modeling: A Demo

12. But What About Multi-Dimensional? Tabular Modeling is not intended to be MDM’s replacement MDM will still be used, as it possesses features that Tabular does not (yet) Licensing for MDM will be more cost effective than Tabular Microsoft is not planning to sunset MDM

13. MDM vs. Tabular? • Tabular • Strong investment in PowerPivot/PowerView • Scale-out needs in the future • More SQL/relational expertise looking to make a leap into SQL Server BI MDM • Significant investment in multi-dimensional products, expertise, and features • Limited licensing budget • Extremely large SSAS projects (terabytes of data)

14. Corporate BI Enterprise Data Analytic Data NFL MLB NFL Presentation Tools NHL NBA MLB Consume ETL NBA Data Warehouse Enterprise DW Process

15. SQL Server BI Presentation Has Been…Spotty.

16. Typical Presentation Platforms for SSAS on SharePoint • Excel/Excel Services • PivotTables, PivotCharts, powerful ad-hoc analysis • Reporting Services • Static format reports – interactive or subscribed • PerformancePoint Services • Web dashboarding • PowerView • Modern, “Metro-style” presentation for Tabular/PowerPivot

17. PowerView: What is It? • A browser-based Silverlight application that produces reports for data exploration, visualization, and presentation • A “PowerPoint” of sorts for data interaction • PowerView Reports can be exported to PPT • Uses BISM models on SSAS, PowerPivot workbooks (on a SharePoint PowerPivotLibrary)

18. …and now, a PowerView Demo!

19. SQL 2012 BI: The Wrap-up Tabular Modeling: The “new-old” way to model data PowerView: A unique, new presentation layer for PowerPivot workbooks and Tabular cubes

20. Orlando Code Camp 2013: SQL Server 2012 BI Resources • Twitter: @grales • Artifacts from Today’s Presentation (Subversion): https://edg.sourcerepo.com/edg/OrlandoCodeCamp2013 • Further Reading • Tabular Modeling: http://blogs.msdn.com/b/microsoft_business_intelligence1/archive/2012/10/11/blog-series-creating-bi-solutions-with-bism-tabular-part-1-of-4.aspx • PowerView: http://office.microsoft.com/en-us/excel-help/power-view-explore-visualize-and-present-your-data-HA102835634.aspx

21. Q&A