0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® 2008 Reporting Services: Hands-On

 
Course: 140   Duration: 4 Days
 
 

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

Related Courses

  • 534 SQL Queries for SQL Server
  • 532 SQL Server Transact-SQL Programming
  • 134 SQL Server Integration Services
  • 139 SQL Server Analysis Services
  • 535 High-Performance SQL Server Databases
  • 502 Programming with .NET Introduction
  • 503 Visual Basic Programming for .NET
  • 419 C# Programming
  • 2106 SQL Server 2012: BI Skills Upgrade

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

Upcoming Dates

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

UK Dates

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

US East Coast Dates

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

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


For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk140.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® 2008 Reporting Services: Hands-On

 
Course: 140   Duration: 4 Days
 
 
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
 
http://www.learningtree.co.uk/courses/uk140.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® 2008 Reporting Services: Hands-On

 
Course: 140   Duration: 4 Days
 
 
Course 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

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Savings Plans

2-Course Passport
  • 2 Courses in 12 months for £2,450
  • As little as £1,225 per course
  • Savings up to 45% per course
3-Course Passport
  • 3 Courses in 24 months for £3,250
  • As little as £1,085 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for £4,000
  • As little as £1,000 per course
  • Savings up to 55% per course
Training Vouchers
  • Save as much as £675 per course
  • Fully transferable
  • As low as £1,600 per course
* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrolment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk140.htm