SQL Server 2005 Reporting Services
 

4-Day (BI-SSRS005-301-EN)

Description

This course will introduce Enterprise Reporting, its characteristics and relation to current business projects.  It will provide System Administrators with the knowledge necessary to understand and manage a SQL Server 2005 Reporting Services Enterprise Reporting Solution, and Report Designers the skills necessary to design different kinds of reports.   Ad-hoc reporting functionalities are state-of-the-art and you will learn how and when to use them.  You will also be learning additional topics such as setup, configuration, maintenance, and extensibility.

Audience

  • Future Reporting Services System  Administrators
  • Future Reporting Services Report Designers

Prerequisites

  • General knowledge of Microsoft Windows Platform (Authentication mechanisms, authorization principles, Internet Information Server, SQL Server, Windows Server 2003…) 
  • General knowledge of SQL and RDBMS, OLAP concepts, XML, and HTML
  • General knowledge of programming techniques and/or scripting. Some VB.NET knowledge is desirable

Course Outline

Section A:  Introduction

Introducing Reporting Services

  • What is Reporting Services (SSRS)
  • Business Scenarios
  • Report Life Cycle
  • SSRS Architecture
  • RDL (Report Definition Language)
  • Designers

End user experience

  • Report manager
  • Viewing, Scheduling, Printing & Exporting
  • MyReports
Section B: Designing Reports

Data Sources

  • Defining Data Sources
    • Relational
    • OLAP
    • Semantic models
  • Types of data sources
  • Query assistants
  • Data Source Expressions

Report Layout

  • Report bands
  • Controls
  • Understanding Data Regions
  • Graphics

Report-to-User interactivity

  • Filters
  • Grouping
  • Sorting and Interactive Sorting
  • Parameters. Cascading parameters
  • Drill-down
  • Links (Subreports)

Advanced features

  • Expressions & Functions
    • Report Collections
  • Conditional formatting
  • Embedded code
Section C: Semantic Models & Report Builder

Accessing SSRS

  • Ad-hoc Reporting
  • Infinite Drilldown

Reporting Controls

  • Relational Sources
  • OLAP Sources
Section D: Administering Reporting Services

Object management

  • Folders
  • Data Sources and Credentials
  • Reports
  • Linked reports

Tuning Report Processing

  • Cache
  • Snapshots
  • History

Authentication and Authorization

  • System Level roles and permissions
  • Item Level roles and permissions

Subscriptions

  • Standard subscriptions
  • Data driven Subscriptions
Section E: Setup, Configuration & Maintenance

Setting Up SSRS

  • Scenarios
  • HTTPs
  • Required accounts

Configuring SSRS

  • Configuration Manager
  • Configuration files
  • Report Builder specific issues

Maintenance

  • Encryption Key backup
  • SSRS Database backup
  • RS Scripting
  • Logging
Section F:  Development & Reporting Services

Introduction

  • Building Models
  • Building Reports with Report Builder
  • Administration Tools
  • Extending SSRS

Architecture Review

  • Web Service APIs
  • URL Access
​