SQL Server 2005 Reporting Services (SSRS) for Power Users/End Users

Course level: Beginner-to-intermediateCourse level:
Beginner-to-intermediate Course Code:
BISSRS Duration:
2.0 days
download course outline pdf

Course Schedule & Prices
Sort by Start Date Sort by Venue Price per Delegate
08/07/2013 2 days Gatwick £800+VAT
12/08/2013 2 days Gatwick £800+VAT
09/09/2013 2 days Gatwick £800+VAT
14/10/2013 2 days Gatwick £800+VAT
11/11/2013 2 days Gatwick £800+VAT
09/12/2013 2 days Gatwick £800+VAT
Book a place now
Save when you book two or more delegates on the same course.
If dates or venues don't suit
If the scheduled dates or locations don't suit you, please complete the form below or
call us on (01403) 269247 or email us to request:
  • a different date
  • another venue
  • an on-site or bespoke course
Request Quote | More Info

  * = required fields
Course Title: SQL Server 2005 Reporting Services (SSRS) for Power Users and End Users training
Summary: This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2005 Reporting Services' Report Builder tool to design and deliver a variety of report types in various formats.
Objectives: Upon completion of this presentation, the delegate should be competent to:
  • Understand report models
  • Create reports using Report Builder
  • Create different types of reports, such as tables, matrices and charts
  • Sort data in reports
  • Filter data
  • Format reports
  • Publish reports
  • Render reports in Excel, PDF, etc
Audience: Business intelligence/data warehouse specialists, BI managers, BI power users and anyone tasked with tactical and strategic planning and analysis.
Prerequisites: Familiarity with desktop applications such as Microsoft Excel or Access.
Format: Lecture and hands-on (about 70%).

Core Topics

1. REPORTING OVERVIEW
  • Understanding Business Intelligence
  • Reporting options
  • Audience type considerations
  • Enterprise reporting life cycle
  • What is SQL Server 2005 Reporting Services (SSRS)?
  • SSRS interfaces
  • Ad-hoc reporting
2. UNDERSTANDING REPORT MODELS
  • What is a report model?
  • Accessing report models
  • Perspectives
  • Entities
  • Fields
3. REPORT BUILDER
  • Launching Report Builder
  • Understanding the interface
  • Accessing report models
  • How Report Builder uses the report model
4. DESIGNING REPORTS
  • Table reports
  • Matrix reports
  • Charts
  • Clickthrough reports
  • Formatting reports
  • Filtering data
  • Grouping and sorting data
  • Adding expressions
  • Working with formulas and functions
  • Renaming fields
  • Working with graphic elements
5. RUNNING REPORTS
  • Previewing a report
  • Page setup
  • Controlling page breaks, headings and columns
  • Printing a report
  • Exporting a report (e.g., Excel, PDF, etc.) from Report Builder
6. PUBLISHING REPORTS
  • Saving a report
  • Sharing a report
  • Report Manager
  • Exporting a report (e.g., Excel, PDF, etc.) from Report Manager
  • SharePoint Report Center
  • My Reports
7. SECURITY CONSIDERATIONS
  • Understanding security
  • Securing your reports

top of page