Top 10 reasons for using sql server report builder and reporting services
Download
1 / 32

- PowerPoint PPT Presentation


  • 304 Views
  • Uploaded on

SESSION CODE: BIU204. Top 10 Reasons for Using SQL Server Report Builder and Reporting Services. Thierry D’hers Group Program Manager SQL Server Reporting Services [email protected] Top 11 reasons for using SQL Server Reporting Services (2008). Thierry D’hers

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '' - anatola


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Top 10 reasons for using sql server report builder and reporting services l.jpg

SESSION CODE: BIU204

Top 10 Reasons for Using SQL Server Report Builder and Reporting Services

Thierry D’hers

Group Program Manager

SQL Server Reporting Services

[email protected]


Top 11 reasons for using sql server reporting services 2008 l.jpg

Top 11 reasons for using SQL Server Reporting Services (2008)

Thierry D’hers

Group Program Manager

SQL Server Reporting Services

[email protected]


Microsoft business intelligence l.jpg
Microsoft Business Intelligence

Business Intelligence with the world’s most popular business productivity suite and most widely deployed information platform

Empower Your People

Improve Organizational Effectiveness

Increase IT Efficiency

Self-service access & insight

Collaborative across your value chain

Trusted, scalable & secure

Familiar interface & tools you own today

Alignment, accountability & ownership

IT management & developer productivity


Microsoft business intelligence4 l.jpg
Microsoft Business Intelligence

Business Intelligence with the world’s most popular business productivity suite and most widely deployed information platform

Empower Your People

Improve Organizational Effectiveness

Increase IT Efficiency

Self-service access & insight

Collaborative across your value chain

Trusted, scalable & secure

Familiar interface & tools you own today

Alignment, accountability & ownership

IT management & developer productivity


Microsoft business intelligence5 l.jpg
Microsoft Business Intelligence

Business Intelligence with the world’s most popular business productivity suite and most widely deployed information platform

Empower Your People

Improve Organizational Effectiveness

Increase IT Efficiency

Self-service access & insight

Collaborative across your value chain

Trusted, scalable & secure

Familiar interface & tools you own today

Alignment, accountability & ownership

IT management & developer productivity


Slide6 l.jpg

Reason #:11

  • Cost of acquisition:

    • = 1 single Box

  • Cost of Ownership/Development:

    • Use of standards and open format: SOAP, XML, MDX, RDL

    • XML based metadata and artifact definition

    • Extensive use of wizard in both development and deployment tools

    • Leverage Developer skillset, IW know how: Visual Studio, CLR, Office Client, Office Server

RDB

RDB + ETL + OLAP + Reporting

ETL

OLAP

Reporting


Slide7 l.jpg

Reason #:10

  • DBA:

    • First to ship a reporting platform with a Relational Database

    • Common Management experience and Infrastructure.

  • Dev:

    • Leverage Developers skill-set by integrating Design and embedding experience in the VS IDE

    • Built and shipped Free Chart controls in the framework.

  • IW

    • Self Service: Lowering the bar of entry for authoring report

    • Making BI as easy as writing a PowerPoint or Word document


Slide8 l.jpg

Reason #:9

Sharepoint

Visual Studio

  • Powerful designers

  • Built into the Enterprise IDE

  • Leveraging Sharepoint collaboration and search corporate platform

Office Client experience

Browser


Slide9 l.jpg

Reason #:8

  • Extensible Data Sources

  • Extensible Rendering (Beyond Word, Excel, CSV, XML, PDF, HTML, TIFF…)

  • Extensible Security

  • Extensible Data Processing extensions

  • Extensible Custom report Items


Slide10 l.jpg

Reason #:7

RS MVP Bloggers & Authors

Teo Lachev

Chris Webb

Brian Larson

Paul Turley

Russell Christopher

RS Team Bloggers

RS Team Blog

Chris Hays

Bob Meyers

Robert Bruckner

John Gallardo

Lukasz Pawlowski

James Wu

Brian Hartman

Sean Boon

Alex Gorev

  • Large book collection written by MVPs

  • R&D Team daily involvement in Forums and Microsoft Connect:

    • http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads/

    • www.connect.microsoft.com

  • Dozens of blogs by MVPs and Product group team members

  • Presence at Conferences: SQL PASS, Teched, PDC, SQL/Dev Connections, BI Conference…


Slide11 l.jpg

Reason #:6

  • All Data

    • Structured

    • Semi Structured

    • Unstructured

    • Spatial…

  • Acquired, enriched and deployed through an End to End platform…


Microsoft business intelligence get more out of products you already own l.jpg
Microsoft Business IntelligenceGet more out of products you already own

Familiar User Experience

Self-service Access and Insight

Data Exploration and Analysis

Predictive Analysis

Data Visualization

Contextual Visualization

Business User Experience

Integrated Content and Collaboration

Thin Clients

Dashboards

BI Search

Content Management

Compositions

Business Collaboration Platform

Information Platform

Analysis Services

Reporting Services

Integration Services

Master Data

Data Mining Services

Data Warehousing

Information Platform


Slide13 l.jpg

Reason #:5

  • Can work on departmental SQL Express apps

  • Can scale to large Scale out farm infrastructure

  • Built on a robust core SQL infrastructure

    • No more IIS dependency, Architecture rehosted on SQLOS

    • Resource management

  • On Demand Processing Architecture

    • Only process and render data on demand

    • Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned:

    • http://sqlcat.com/technicalnotes/archive/2008/07/09/scaling-up-reporting-services-2008-vs-reporting-services-2005-lessons-learned.aspx


Slide14 l.jpg

Excel

Visual Studio

Report Builder

Report Designer

Model Designer

RS Data Source UI

AS Data Source UI

Office Data Connection Wizard

VS Data Connection UI

ODBC Admin UI

Microsoft Query

OLEDB Data Link UI

ODBC Connection Wizards

ADO.NET

OLEDB

ODBC

File Drivers (ISAM)

SQL

Oracle

...

AS

SAP

...

...

XLS

MDB

File

Relational

OLAP

Reason #:4

  • ADO.Net:

    • Teradata, Oracle, SQL, DB2, SSAS, SAPBW, Hyperion Essbase

    • New in R2: PowerPivot, Sharepoint list, SQL Azure, SQL Parallele Data Warehouse

  • OLEDB:

    • Informix, Sybase…

  • XML

  • ODBC

    • Text, Excel, CSV File…


Slide15 l.jpg

Reason #:3

  • ADO.Net:

    • Oracle, SQL, DB2, SSAS, SAPBW, Hyperion Essbase

    • Soon: EDM

  • OLEDB:

    • Teradata, Informix, Sybase…

  • ODBC

    • XML, Text, Excel, CSV File…


Flexible report layout l.jpg
Flexible Report Layout

Tabl

e+Matr

ix


Highly flexible layout options l.jpg
Highly flexible layout options

Custom

Subtotals

Non-pivot

columns

Custom

Headers

Pivot

Stepped or Block grouping

Nested controls

Multi-Pivot


Most flexible with multiple layout targets l.jpg
Most Flexible with Multiple Layout Targets

PDF

  • Render to PDF, Word, Excel, HTML, XML, TIFF…

  • Support diverse industry and regional layout requirements

  • Enable pixel perfect reports with interactivity and animation

  • High resolution printing

Word

Report Builder

HTML

Excel


Slide19 l.jpg

Reason #:2



Tablix visualizations sparklines and data bars l.jpg
Tablix Visualizations: Sparklines and Data Bars

New in R2

  • Sparklines

    • “Data intense, word-sized graphics” – Tufte

    • Automatic axis alignment. All charts can have the same data points, regardless of source data

    • Can be converted into full charts to support additional small multiple scenarios

  • Data Bars

    • Usually depicts a single value in a cell

    • Min and Max are automatically determined, but are configurable

Sparklines

Data Bars


Tablix visualization indicators l.jpg
Tablix Visualization: Indicators

New in R2

  • Icons used to depict the status against a value, goals or a trend

  • Report authors can create their own sets or choose from several pre-configured sets

  • Colors, Icon and Size can be changed based on data.

  • Automatic support for comparing each member of a group against siblings

  • Can also be placed inside gauges


Map features l.jpg
Map Features

New in R2

  • Support for SQL Spatial

  • Integration with Virtual Earth tiles

  • Data Grouping

    • Equal intervals, equal distribution, optimal, user-defined

  • Multiple Map layers


Slide24 l.jpg

Reason #:1


Self service report authoring l.jpg
Self-service report authoring

New in R2

Report Builder 3.0

  • Familiar Microsoft Office Interface

  • Rich Visualizations

  • Powerful Query Designer

  • PowerPivot & SharePoint lists as data sources

  • Report Part Gallery for “grab and go” report design experience


Microsoft business intelligence26 l.jpg
Microsoft Business Intelligence

Business Intelligence with the world’s most popular business productivity suite and most widely deployed information platform

Empower Your People

Improve Organizational Effectiveness

Increase IT Efficiency

Self-service access & insight

Collaborative across your value chain

Trusted, scalable & secure

Familiar interface & tools you own today

Alignment, accountability & ownership

IT management & developer productivity


Related content l.jpg

Required Slide

Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session.

Related Content

  • BIU08-INT - Using Microsoft SQL Server 2008 R2 Report Builder 3.0 (6/8/2010 3:15PM)

  • BIE310 - Microsoft SQL Server 2008 R2 Reporting Services Integration with Microsoft SharePoint Server 2010 (6/9/2010 8:00AM)

  • BIE18-INT - Microsoft SQL Server Reporting Services Architecture(6/9/2010 9:45AM)

  • Building Effective Data Visualizations and Maps with Microsoft SQL Server 2008 Reporting Services (6/9/2010 1:30PM)

  • BIE14-INT- Optimizing Reports for Performance and Scale(6/9/2010 3:15PM)

  • BIE19-INT - Microsoft SQL Server Reporting Services Extensibility and Programmability (6/10/2010 9:45AM)


Resources l.jpg

Required Slide

Resources

Learning

  • Sessions On-Demand & Community

  • Microsoft Certification & Training Resources

www.microsoft.com/teched

www.microsoft.com/learning

  • Resources for IT Professionals

  • Resources for Developers

http://microsoft.com/technet

http://microsoft.com/msdn


Slide29 l.jpg

Required Slide

Complete an evaluation on CommNet and enter to win!


Slide30 l.jpg

Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st

http://northamerica.msteched.com/registration

You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year


Slide31 l.jpg

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



ad