Schedules:

There are currently no scheduled classes for this course.

 
  SQL Server 2005 Reporting Services
 

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

Description
Audience
Prerequisites
Course Outline

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