Request Info

Salutation

First Name

Last Name

Job Title

Company

Post Code

Country
List

Office Telephone

Extension

E-mail

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

Save up to 55% per course
 

SQL Server® 2008 Reporting Services:
Hands-On


Course 1404 Days

 E-mail E-mail  Print Print  Q&A Q&A  PDF PDF  Facebook Facebook  Twitter Twitter

Quick Enrol

You Will Learn How To

  • Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data
  • Design reports and display your data graphically with enhanced visualisation features
  • Integrate parameters, filters and interactive components into report design
  • Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint
  • Safeguard reports with Windows Authentication
  • Easily create reports on Analysis Services cubes with Report Builder and Report Designer

Course Benefits

SQL Server 2008 Reporting Services meets demanding requirements by providing a powerful and versatile reporting platform of data on SQL Server, Oracle or any other database system. In this course, you learn how to glean business intelligence from your data. In addition, you gain the knowledge and skills to produce compelling reports with enhanced visualisation features and deliver the reports through organisation portals.

Who Should Attend

Those designing, creating or delivering reports from relational databases with SQL Server 2008. Previous exposure to any database system or spreadsheet data is assumed.

Hands-On Training

Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
  • Producing customised reports with expressions
  • Employing Tablix to produce new report formats
  • Leveraging advanced reporting charts
  • Creating cached instances, snapshots and subscriptions
  • Deploying reports to the Report Server
  • Configuring and testing security on report items
  • Creating reports on Analysis Services cubes

Course Content

Introduction to SQL Server 2008 Reporting Services

  • Identifying deployment: native, integrated or single server
  • Managing Web farm deployment with/without SharePoint

Developing Reports

Designing fundamental reports

  • Connecting to relational and multidimensional data sources
  • Generating a Tablix reporting structure
  • Building an interactive chart
  • Creating reports with richly formatted text

Composing expressions

  • Computing custom fields
  • Linking expressions to properties
  • Employing conditional formatting

Arranging and sorting data

  • Multiple-level grouping and categorising the results
  • Applying aggregate functions

Producing various outputs from a Tablix

  • Creating parallel dynamic group report formats
  • Combining dynamic and static columns

Integrating Parameters and Filters

Incorporating parameters into reports

  • Yielding subsets of data with query parameters
  • Aligning report parameters to query parameters
  • Constructing cascading report parameters
  • Transmitting parameters to stored procedures
  • Handling multivalued parameters

Applying filters to report data

  • Augmenting performance with filters
  • Determining filters vs. query parameters

Implementing Interactive Features

Combining multiple data regions in one report

  • Applying sequential and nested regions
  • Creating master/detail reports and linking subreports

Showing robust data with relevant detail

  • Drilling through report detail and drilling down report data
  • Navigating reports with document maps
  • Reporting with hierarchical rows and dynamic headers

Deploying and Delivering Reports

Deploying reports to the server

  • Publishing reports and configuring project properties
  • Verifying results with Report Manager

Identifying delivery options

  • Electing on demand or via subscription
  • Enhancing performance with cached instances and snapshots
  • Configuring snapshot history
  • Formatting different outputs

Dispatching subscription reports

  • Publishing reports via e-mail and fileshare
  • Seamlessly delivering reports by data-driven subscriptions

Integrating reports with SharePoint

  • Deploying reports to SharePoint
  • Viewing results in Report Center and Data Connections libraries

Safeguarding Reporting Services

Structuring content security

  • Leveraging existing Windows authentication
  • Establishing permission levels on report items

Ensuring the RS system

  • Instituting varying levels of administrative roles
  • Granting and revoking system-level permissions

Extended Reporting and Data Visualisation

Creating reports on Analysis Services cubes

  • Exploiting cubes as intuitive data sources for nontechnical and power users
  • Working with the slicing and dicing features of Analysis Services
  • Generating parameterised reports with MDX Builder

Designing reports for data visualisation

  • Improving data visualisation with sparklines, data bars, maps and indicators
  • Implementing Key Performance Indicators (KPIs)
  • Dragging and dropping visualisation components to display inline

Delivering Reports to Users

  • Accessing and controlling reports using URLs
  • Enumerating reports on a report server
  • Embedding reports in applications with the Report Viewer
  • Delivering reports through SharePoint

<< Back to Oracle Databases
 

Related Courses


SQL Server is a registered trademark of Microsoft Corporation.
 
SQL Server 2008 Reporting Services

Course Dates

Live online classroom training. Attend highlighted events in person or live, online via Learning Tree AnyWareTM.

UK Dates

28 Feb - 2 MarLondon enrol
28 Feb - 2 MarLondon enrol
29 May - 1 JunLondon enrol
21-24 AugLondon enrol
13-16 NovLondon enrol
29 Jan - 1 FebLondon enrol

US East Coast Dates

6-9 MarNew York enrol*
24-27 AprWashington, DC enrol*
8-11 MayNew York enrol*

*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST.

For AnyWare enrolments, please register at least 10 days prior to the start of the course.

More Dates and Locations.

Fees

£ 1,925Standard Fee
Fee with a Savings Plan
£ 1,2252-Course Passport
£ 1,0853-Course Passport
£ 1,0004-Course Passport
£ 1,600Voucher 10-Pack

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customised for your organisation.

SQL Server 2008 Reporting Services: Hands-On

Course participants configuring drill-down architecture on a report.


Average Attendee Evaluation

Evaluations in the last 12 months

5 stars:
74%
4 stars:
23%
3 stars:
2%
2 stars:
1%
1 star:   0%

 
"Just in the first week back from the Learning Tree Course, I was able to apply my new skills. I could never have gained the expertise I needed without having taken that class".

– M. Altemus
Aqua Pennsylvania



 
What's in It for You: Exploring the Benefits of the SQL Server 2008 Database Engine