1 / 26

Business Intelligence and Data Visualisation 2012

Business Intelligence and Data Visualisation 2012. Jen Stirrup MVP CopperBlue Consulting. Who am I?. Jen Stirrup Specialist in Data Visualisation Microsoft SQL Server MVP Twitter: @ JenStirrup @ thinkcopperblue E: jen.stirrup@CopperBlueConsulting.com W: www.copperblueconsulting.com

lindsey
Download Presentation

Business Intelligence and Data Visualisation 2012

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. Business Intelligence and Data Visualisation 2012 Jen Stirrup MVP CopperBlue Consulting

  2. Who am I? • Jen Stirrup Specialist in Data Visualisation • Microsoft SQL Server MVP • Twitter: @JenStirrup @thinkcopperblue • E: jen.stirrup@CopperBlueConsulting.com • W: www.copperblueconsulting.com • W: www.jenstirrup.com

  3. ‘Traditional’ BI Downsides Upsides Flexible: Can model anything Familiar: Lots of expertise Rigid: hard to change Powerful: Enterprise scale Hard: MDX isn’t easy Near real time: 15 minute refresh Secure: Fine grain control Control: Process & versions

  4. End User BI Downsides Upsides Easy to Use: users get it Collaboration: Between IW & IT Chaos: IT can’t manage it Mashups: make your own Refresh: Could be a day out Agile: Deploy in a click or 2

  5. End User BI in SQL Server 2012 No Downsides Upsides Easy to Use: users get it Collaboration: Between IW & IT Cool: End user analysis Mashups: make your own Powerful: Enterprise scale Secure: Fine grain control Control: Process & versions Agile: Deploy in a click or 2

  6. Design tools.. SQL Server SharePoint Office Report Builder Dashboard Designer Excel Power View SharePoint Chart Access PowerPivot Excel Services Visio Data Mining for Excel Visio services BI Development Studio 6

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

  8. What is PowerPivot? • Subversive: Business Intelligence in the hands of users, not 18-month plus projects • What is PowerPivot? • Two types: • Free Excel add-in • Sharepoint presentation layer • Strength: Vertipaq column-oriented data store • Scaleability

  9. What is PowerPivot? • Diagram View • Advanced Tab – Perspectives • Show Details

  10. Demo

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

  12. Power View (formerly Crescent) Highly Visual Design Experience • Interactive, web-based authoring and sharing of information • Familiar Microsoft Office design patterns • Powerful data layout with banding, callout and small multiples visualizations Rich metadata-driven interactivity • Fully integrated with PowerPivot • Drive greater insight through smart and powerful querying • Zero configuration highlighting and filtering • Animated trending and comparisons Presentation-ready at all times • Interactive Presentation turns pervasive information into persuasive information • Deliver and collaborate through SharePoint • Full screen presentation mode for interactive boardroom session

  13. Design for a new wave of Information workers

  14. Architecture SharePoint Farm SQL Server BIDS BISM Model App Server Web Front End RS Shared Service SSRS Addin for SharePoint Crescent client AS Server PowerPivot System Service PowerPivot Web Service Analysis Services SP Integrated Excel PowerPivot Model Data sources

  15. Architecture Yet…. Crescent only works from Tabular BISM for now Crescent and alerting depend on SharePoint Silverlight based

  16. Demo

  17. Trellis Chart 17

  18. Motion Chart

  19. Parallel Co-Ordinates

  20. What is PowerPivot? • Efficiency - Power View does not get all of the information in one go • If the underlying data isn’t joined together, then the ‘missing’ tables are greyed out. • Web client based on a tabular model in SharePoint Server 2010 • PowerPivot workbook • SSAS Tabular model

  21. What is PowerPivot? • Highlight and filter data • Sort data • Based on Dimensions and Measures • Automatically synchronises axis

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

  23. Reporting Services Design Future • Data Regions Removed: Table / Matrix / List • Replaced with a Tablix • White Space – use ConsumeContainerWhitespace • Rendered page by page • Nested Sub Report preserved in Excel

  24. Questions

  25. Get in touch! • Jen Stirrup Specialist in Data Visualisation • Microsoft SQL Server MVP • Twitter: @JenStirrup @thinkcopperblue • E: jen.stirrup@CopperBlueConsulting.com • W: www.copperblueconsulting.com • W: www.jenstirrup.com

  26. © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related