1 / 21

SQL Server 2012 Business Intelligence

SQL Server 2012 Business Intelligence. A Tour of the Next Generation of BI. Welcome!. Our Tour Today of SQL 2012 BI. Data Modeling Tabular Modeling in SSAS Data Presentation PowerView Reports. What We’re Building. DW/BI solution for CAA Athletics NFL Analytics Requested functionality

kiet
Download Presentation

SQL Server 2012 Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related