matthew stephen & will thompson business intelligence technical specialists microsoft ltd...
TRANSCRIPT
Matthew Stephen & Will ThompsonBusiness Intelligence Technical SpecialistsMicrosoft Ltd
Achieve Rapid Reporting with Reporting Services and Report Builder 3.0
Text Microsoft to 60300
Or
Tweet #uktechdays
Questions?
4
Agenda
Microsoft BI VisionMicrosoft BI Solution StackEmpower Your Users with Self-Service ReportingSelf-Service Reporting with Reporting Services and Report Builder 3.0 Report Builder 3.0 Demo
5
Microsoft BI Vision
Complete and integrated BI and Performance Management offering Agile products that adapt to how your need the informationBuilt on a trusted part of your IT backbone
Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions
6
Data Infrastructure & BI Platform• Integration Services• Data Warehousing• Analysis Services• Data Mining• Reporting Services• Master Data Services
BUSINESS COLLABORATION PLATFORM
DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM
BUSINESS USER EXPERIENCE
The Microsoft BI Solution Stack
7
Business Productivity Infrastructure• Dashboards & Scorecards• Excel Services• Web based forms
& workflow• Collaboration• Search• Content Management• LOB data integration• PowerPivot for
SharePoint
The Microsoft BI Solution Stack
BUSINESS COLLABORATION PLATFORM
DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM
BUSINESS USER EXPERIENCE
8
Delivered through a Familiar Interface• Self-Service access
& insight• Data exploration
& analysis• Predictive analysis• Data visualization• Contextual visualization
The Microsoft BI Solution Stack
BUSINESS COLLABORATION PLATFORM
DATA INFRASTRUCTURE & BUSINESS INTELLIGENCE PLATFORM
BUSINESS USER EXPERIENCE
9
Empower Your Users with Self-Service Reporting
Users need timely access to information
Ability to combine data across multiple sources provides a more accurate view
Flexible layout options and reusable insights
10
Report Builder 3.0 Self-service report authoringReport Part GalleryLookup functionsMicrosoft Office InterfaceRich VisualizationsHighly flexible layout optionsPowerful Query Designer
Relational Multi-dimensional
New data sources:SQL AzurePowerPivotSharePoint lists
11Stepped or Block grouping
PivotCustom
SubtotalsNon-pivotcolumns
Nested controls Multi-Pivot
CustomHeaders
Highly flexible layout options
12
Tablix Visualisations: Sparklines and Data Bars
Sparklines“Data intense, word-sized graphics” – TufteAutomatic axis alignment
Data BarsUsually depicts a single value in a cellMin and Max automatically determined
Sparklines
Data Bars
13
Tablix Visualization: Indicators
Icons used for value, goal or a trendColors, Icon and Size based on dataAutomatic support for comparing siblings
14
Extensive Visualisations
15
Map FeaturesSupport for SQL Spatial dataIntegration with Bing Maps tilesMultiple Map layers – Point, Line, Polygon, Tile
16
Map Components
Point Layer
Tile Layer
Polygon Layer
17
Another Map Example
18
Capitalise on Existing ReportsReusing common report elements helps to accelerate report creation, cut down costs, and increase end-
user adoption.
Share & Collaborate
New Report
SourceReport
Report Part Gallery
19
Sharing and Re-useReport Parts
Shared Datasets
Shared Datasource
Heterogeneous Data
20
PowerPivot as a Data Source
DATA SOURCE
OLTP AND OLAPDATA SOURCES
PUBLISHING
21
Enhanced Report Viewer and Report Manager Experience
FaceliftAJAX enabled Report ViewerBetter workflow via context menusAccess to properties without renderingScroll position is maintained across interactivityNew Test Connection button
22
Report Builder 3.0
demo
23
Other Enhancements of Note
Bottom-to-top text rotationRenderer dependent layout and formattingPage naming & Page break enhancementsRead-Write report variablesAggregates of Aggregates - Avg(Sum(Sales,”Month”),”Year”)Pagination & Rendering diagnosticsNew edit Session Infrastructure – everything is cached
24
SQL Server 2008 Reporting Services - Summary
Faster report creationNew visualisationsEasier managementBetter control of content
© 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.