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

1. 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 Thierry.dhers@microsoft.com

2. Top 11 reasons for using SQL Server Reporting Services (2008) Thierry D’hers Group Program Manager SQL Server Reporting Services Thierry.dhers@microsoft.com

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

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

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

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

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

8. Reason #:9 Sharepoint Visual Studio • Powerful designers • Built into the Enterprise IDE • Leveraging Sharepoint collaboration and search corporate platform Office Client experience Browser

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

10. 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…

11. Reason #:6 • All Data • Structured • Semi Structured • Unstructured • Spatial… • Acquired, enriched and deployed through an End to End platform…

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

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

14. 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…

15. Reason #:3 • ADO.Net: • Oracle, SQL, DB2, SSAS, SAPBW, Hyperion Essbase • Soon: EDM • OLEDB: • Teradata, Informix, Sybase… • ODBC • XML, Text, Excel, CSV File…

16. Flexible Report Layout Tabl e+Matr ix

17. Highly flexible layout options Custom Subtotals Non-pivot columns Custom Headers Pivot Stepped or Block grouping Nested controls Multi-Pivot

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

19. Reason #:2

20. Extensive Visualizations

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

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

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

24. Reason #:1

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

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

27. 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)

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

29. Required Slide Complete an evaluation on CommNet and enter to win!

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

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.

32. Required Slide