Achieve Rapid Reporting with Reporting Services and Report Builder 3.0 Matthew Stephen & Will Thompson Business Intelligence Technical Specialists Microsoft Ltd Questions? Text Microsoft to 60300 Or Tweet #uktechdays Agenda Microsoft BI Vision Microsoft BI Solution Stack Empower Your Users with Self-Service Reporting Self-Service Reporting with Reporting Services and Report Builder 3.0 Report Builder 3.0 Demo 4 Microsoft BI Vision Complete and integrated BI and Performance Management offering Agile products that adapt to how your need the information Built on a trusted part of your IT backbone 5 The Microsoft BI Solution Stack BUSINESS USER EXPERIENCE BUSINESS COLLABORATION PLATFORM DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM 6 The Microsoft BI Solution Stack BUSINESS USER EXPERIENCE BUSINESS COLLABORATION PLATFORM DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM 7 The Microsoft BI Solution Stack BUSINESS USER EXPERIENCE BUSINESS COLLABORATION PLATFORM DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM 8 Empower Your Users with Self-Service Reporting 9 Report Builder 3.0 Self-service report authoring Report Part Gallery Lookup functions Microsoft Office Interface Rich Visualizations Highly flexible layout options Powerful Query Designer Relational Multi-dimensional New data sources: SQL Azure PowerPivot SharePoint lists 10 Highly flexible layout options Pivot 11 Stepped or Block grouping Custom Subtotals Non-pivot columns Nested controls Custom Headers Multi-Pivot Tablix Visualisations: Sparklines and Data Bars Sparklines Sparklines “Data intense, word-sized graphics” – Tufte Automatic axis alignment Data Bars Usually depicts a single value in a cell Min and Max automatically determined 12 Data Bars Tablix Visualization: Indicators Icons used for value, goal or a trend Colors, Icon and Size based on data Automatic support for comparing siblings 13 Extensive Visualisations 14 Map Features Support for SQL Spatial data Integration with Bing Maps tiles Multiple Map layers – Point, Line, Polygon, Tile 15 Map Components Point Layer Polygon Layer Tile Layer 16 Another Map Example 17 Share & Collaborate Report Part Gallery Capitalise on Existing Reports Reusing common report elements helps to accelerate report creation, cut down costs, and increase end-user adoption. 18 Sharing and Re-use Report Parts Shared Datasets Shared Datasource Heterogeneous Data 19 PowerPivot as a Data Source 20 Enhanced Report Viewer and Report Manager Experience Facelift AJAX enabled Report Viewer Better workflow via context menus Access to properties without rendering Scroll position is maintained across interactivity New Test Connection button 21 Report Builder 3.0 22 Other Enhancements of Note Bottom-to-top text rotation Renderer dependent layout and formatting Page naming & Page break enhancements Read-Write report variables Aggregates of Aggregates - Avg(Sum(Sales,”Month”),”Year”) Pagination & Rendering diagnostics New edit Session Infrastructure – everything is cached 23 SQL Server 2008 Reporting Services - Summary Faster report creation New visualisations Easier management Better control of content 24 For resources, decks and video: www.microsoft.com/uk/techdays © 2008 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.