BIN305 BI Analytics Boring? You Just Haven’t Used Live Labs Pivot Yet!

2. BIN305BI Analytics Boring?You Just Haven’t Used Live Labs Pivot Yet! Frank van Egmond Jeroen ter Heerdt Business Intelligence Consultants Microsoft Corporation

3. The Data Dilemma

4. Data Representation Challenges Visual expressed data Filtering options

5. What Is Pivot? • PivotViewer is fundamentally about: • Visualizing collections of objects • Revealing hidden patterns within data • Acting on discovered insights • PivotViewer helps us to: • Make better use of the growing amount of information that surrounds us • Interact more easily with information in ways that are powerful, informative, and fun • View thousands of things at once and see the relationships which connect them • Visualize information in a new way, so we can learn and identify key insights that were once hard to find

6. PivotViewer Design Principles • The user is never lost: simple interface and animations help build and maintain context • The user never has to wait: deep zoom technology allows for continuous and progressive rendering of content with no page reloads • The content is the focus: the experience and navigation are driven by the content itself, menus and controls are secondary • The whole is > the sum of the parts: exposing hidden insights by viewing data in aggregate and exposing the interconnections

7. Pivot Is Different • Pivot - more than an Excel term • Collections • Hosted in: • Desktop Application • Silverlight 4.0 • PivotViewerextension for Reporting Services • Authoring tools • JIT server • Uses DeepZoomtechnology

8. Pivot User Interface Pivotize Music Collection demo

9. Pivot Works With Collections define Pivot Collection (noun) • Visual dataset of related objects with associated metadata 2. Interface to explore trends and details of data through filtering, pan and zoom, and relevant views You provide PivotViewer provides

10. Collections Are Just Files DZC (Deep Zoom Collection) Top of the pyramid CXML DZI (Deep Zoom Images) Bottom of the pyramid DZC DZI CXML (Collection XML): Metadata Defines each item and its values, define the shape of the data

11. DeepZoom Image Pyramid

12. Tools for Creating Collections • Excel Tool: The fastest, easiest way to build a collection. Great for prototyping. Uses rows and columns to organize metadata. • Command Line Tool: Specialized tool for converting data between formats including CXML. Also includes an HTML based deep zoom image creator. • Third Party Tools: There are a handful of third party tools on the market to help with other scenarios. http://www.GetPivot.com/Developer-Info/Tools.aspx

13. Creating A Collection Using Excel demo

14. Pivot in Silverlight: Anatomy Web Page Silverlight Application CXML Server PivotViewer Control Script PivotViewer API DZC Server

15. Benefits Of Using Silverlight Two-way interaction between the PivotViewer control and your Silverlight application: • Load collections, manipulate the display of the collection from your Silverlight app • Receive events from the PivotViewer control to the Silverlight app as the user uses the control

16. PivotViewer Silverlight Pivotize Music Collection: Generating a playlist demo

17. Programming Pivot: API • Methods • void LoadCollection(string collectionUri, string viewerState) • PivotItemGetItem(string id) • Properties (all provide change notification) • CollectionName • CollectionUri • CollectionItemCount • CurrentItemId • InScopeItemIds • SortFacetCategory • AppliedFilters • ViewerState – one string including applied filters, view, and sort

18. PivotViewer API • Events • CollectionLoadingCompleted • CollectionLoadingFailed • ItemDoubleClicked • LinkClicked • Change notifications for all properties

19. Custom Buttons • Allows adding custom buttons to the collection item UI • Custom buttons are context-sensitive: control asks the Silverlight application for information necessary about the available custom buttons for an item before displaying that item’s UI • Custom button consists of an icon, a text description, and the tooltip text • Control notifies your application when a custom button is clicked, so it can perform a custom action

20. Custom Filter States • Simple to implement • Add a button on the web page or Silverlight application • When the button is clicked, set a pre-defined view state corresponding to your custom filter set

21. Customizing Pivot Tiles • HTML template for tiles • Use PAuthor to generate

22. Command Line Tool: Pauthor.exe Raw Images Deep Zoom Images CXML Excel CSV CXML Pauthor.exe CXML Excel CSV CXML Raw Images Deep Zoom Images

23. Fourth Coffee demo

24. PivotViewer Extension for Reporting Services • A concept project by the Microsoft Business Intelligence engineering team • Not supported • Enables automatically collection generation using Reporting Services • Hosted in PivotViewer control in SharePoint • Create a report to define tile template • http://www.microsoft.com/sqlserver/tour/en/videos/pivot-viewer.aspx

25. Sales Managers PivotViewer for SQL Server Reporting Services demo

26. Wrap Up • Pivot is a great way to show a lot of information in a visually appealing manner, for easy analysis • Three ways of hosting: • Standalone exe • SilverLight Control • Reporting Services Extension • Ways to create collections: • Standard tooling (Pauthor, Excel Add-in) • PivotViewer API • Configuring Pivot Crawler for SSRS

27. PivotViewer Anticipated Schedule Note: Silverlight control specific PivotViewer V1.0 Released June 29 2010 PivotViewer V1.1 Released Fall 2010 PivotViewervNext TBD 2011

28. Resources • Overview: http://www.microsoft.com/silverlight/pivot • Pauthor: http://pauthor.codeplex.com and http://www.getpivot.com/developer-info/cmd-line-tools.aspx • Excel tool: http://www.getpivot.com/developer-info/excel-tools.aspx • PivotViewerSilverLight Control: http://www.silverlight.net/learn/pivotviewer • PivotViewer Extension for SSRS: http://www.microsoft.com/sqlserver/tour/en/videos/pivot-viewer.aspx

29. Real-Life Examples • NetFlix movies: http://netflixpivot.cloudapp.net/ • Top Sharepoint sites: http://www.wssdemo.com/livepivot/ • Wedding venues search: http://www.hitched.co.uk/wedding-venues/visual-search.htm • UK Caravan search: http://www.blackcountrycaravans.co.uk/advanced-stocklist.aspx • TweetPivot: http://www.tweetpivot.com

30. Session Evaluations Tell us what you think, and you could win! All evaluations submitted are automatically entered into a daily prize draw*  Sign-in to the Schedule Builder at http://europe.msteched.com/topic/list/ * Details of prize draw rules can be obtained from the Information Desk.

31. © 2010 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.