Download
business intelligence and data visualization microsoft sql server 2012 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Business Intelligence and Data Visualization: Microsoft SQL Server 2012 PowerPoint Presentation
Download Presentation
Business Intelligence and Data Visualization: Microsoft SQL Server 2012

Business Intelligence and Data Visualization: Microsoft SQL Server 2012

230 Views Download Presentation
Download Presentation

Business Intelligence and Data Visualization: Microsoft SQL Server 2012

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. DBI206 Business Intelligence and Data Visualization: Microsoft SQL Server 2012 Jen Stirrup MVP Copper Blue Consulting

  2. Agenda • Traditional Business Intelligence versus ‘New’ Business Intelligence #newBI • Self-Service Business Intelligence in SQL Server 2012: • PowerPivot • Data Visualisation in SQL Server 2012: • Power View Architecture and demo • Reporting Services in Sharepoint • Questions?

  3. Agenda • Traditional Business Intelligence versus ‘New’ Business Intelligence #newBI • Self-Service Business Intelligence in SQL Server 2012: • PowerPivot • Data Visualisation in SQL Server 2012: • Power View Architecture and demo • Reporting Services in Sharepoint • Questions?

  4. Business Intelligence is about people first…

  5. … enabled by technology

  6. … making Businesses Intelligent

  7. What % of organizations considers their Business Intelligence Initiatives a success? A) 38.1% B) 52.8% C) 6.8% D) 2.3%

  8. What % of organizations considers their Business Intelligence Initiatives a success? A) 38.1% B) 52.8% C) 6.8% D) 2.3%

  9. ‘Traditional’ BI Upsides

  10. ‘Traditional’ BI Upsides

  11. ‘Traditional’ BI Upsides

  12. ‘Traditional’ BI Upsides

  13. ‘Traditional’ BI Upsides

  14. ‘Traditional’ BI Upsides

  15. ‘Traditional’ BI Upsides Downsides

  16. End User BI Upsides

  17. End User BI Upsides

  18. End User BI Upsides

  19. End User BI Upsides

  20. End User BI Upsides Downsides

  21. End User BI in SQL Server 2012

  22. End User BI in SQL Server 2012

  23. End User BI in SQL Server 2012 Downsides

  24. Design tools.. SQL Server SharePoint Office Report Builder Dashboard Designer Excel Power View SharePoint Chart Access Power Pivot Excel Services Visio Data Mining for Excel Visio services PerformancePoint Services SQL Server Data Tools Tabular Model 24

  25. Agenda • Traditional Business Intelligence versus ‘New’ Business Intelligence #newBI • Self-Service Business Intelligence in SQL Server 2012: • PowerPivot • Data Visualisation in SQL Server 2012: • Power View Architecture and demo • Reporting Services in Sharepoint • Questions?

  26. Report Authoring Suite IT Pros Power Users Developers End Users Sophisticated Design Environment ProductiveAuthoring Visual data representation Re-use of insights Report Viewer Controls Highly Interactive Flexible layout Rich Presentation Rich Design Capabilities Power Pivot Report Designer / SSRS Power View Embedded Operational Business

  27. Report Authoring Suite IT Pros Power Users Developers End Users Sophisticated Design Environment ProductiveAuthoring Visual data representation Re-use of insights Report Viewer Controls Highly Interactive Flexible layout Rich Presentation Rich Design Capabilities Power Pivot Report Designer / SSRS Power View Embedded Operational Business

  28. What is PowerPivot? • PowerPivot gives users the power to create compelling self-service BI solutions using familiar Excel Interface

  29. PowerPivot

  30. PowerPivot Versions

  31. Why PowerPivot? • Mashups • Far better than VLOOKUP • High Performance • Sophisticated Time Intelligence

  32. End User BI in SQL Server 2012

  33. demo Power Pivot Name: Jen Stirrup Title: Business Intelligence and Data Visualisation in SQL Server 2012 Group

  34. What did we learn from the demo?

  35. Report Authoring Suite IT Pros Power Users Developers End Users Sophisticated Design Environment ProductiveAuthoring Visual data representation Re-use of insights Report Viewer Controls Highly Interactive Flexible layout Rich Presentation Rich Design Capabilities Power Pivot Report Designer / SSRS Power View Embedded Operational Business

  36. Agenda • Traditional Business Intelligence versus ‘New’ Business Intelligence #newBI • Self-Service Business Intelligence in SQL Server 2012: • PowerPivot • Data Visualisation in SQL Server 2012: • Power View Architecture and demo • Reporting Services in Sharepoint • Questions?

  37. What is Power View • Power View is an interactive data exploration and visual presentation experience.

  38. Architecture SharePoint Farm SQL Server BIDS BISM Model App Server Web Front End RS Shared Service SSRS Addin for SharePoint Power View via Browser AS Server PowerPivot System Service PowerPivot Web Service Analysis Services SP Integrated Excel PowerPivot Model Data sources

  39. Data Visualisation is about People

  40. Pre-attentive Attributes

  41. Pre-attentive Attributes

  42. demo PowerView Name: Jen Stirrup Title: Business Intelligence and Data Visualisation in SQL Server 2012 Group

  43. What did we learn from the demo?

  44. Agenda • Traditional Business Intelligence versus ‘New’ Business Intelligence #newBI • Self-Service Business Intelligence in SQL Server 2012: • PowerPivot • Data Visualisation in SQL Server 2012: • Power View Architecture and demo • Reporting Services in Sharepoint • Questions?

  45. Reporting Services • SQL Server Data Tools • Sharepoint Integrated mode is, well, more integrated! • Rsreportserver.config • Report Server logs now stored in Sharepoint hive • SOAP API is no longer supported

  46. Reporting Services Design Future • White Space – use ConsumeContainerWhitespace • Rendered page by page • Nested Sub Report preserved in Excel

  47. demo Reporting Services in SSDT Name: Jen Stirrup Title: Business Intelligence and Data Visualisation in SQL Server 2012 Group

  48. Summary • Self-Service Business Intelligence Power Pivot Power View Reporting Services in SSDT

  49. Thank You for attending! Summary • Self-Service Business Intelligence Power Pivot Power View Reporting Services in SSDT

  50. Questions