1-888-THE-TREE (1-888-843-8733)
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 visualization 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 visualization features and deliver the reports through organization 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 customized 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

 
SQL Server is a registered trademark of Microsoft Corporation. 		 

Training Dates

Live online classroom training.Participate in person or in live, online events (highlighted) via Learning Tree AnyWareTM.
Mar 13 - 16Ottawa 
Mar 20 - 23Toronto 
Jun 19 - 22Toronto 
Jul 10 - 13Ottawa 
Sep 11 - 14Toronto 
Nov 6 - 9Ottawa 
Dec 18 - 21Toronto 

US Dates

Mar 6 - 9New York 
Apr 10 - 13Boston 
Apr 10 - 13Alexandria, VA
Apr 17 - 20Atlanta 
Apr 24 - 27Rockville, MD
May 1 - 4Dallas 
May 8 - 11New York 

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


For complete schedule, please visit www.learningtree.ca
http://www.learningtree.ca/courses/140pf.htm
 
 
1-888-THE-TREE (1-888-843-8733)
PRODUCTIVITY THROUGH EDUCATION®
 

SQL Server 2008 Reporting Services: Hands-On

 
Course: 140   Duration: 4 Days
 
 
Course 140 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 categorizing the results
  • Applying aggregate functions

Producing various outputs from a Tablix

  • Creating parallel dynamic groups 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 Visualization

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 parametrized reports with MDX Builder

Designing reports for data visualization

  • Improving data visualization with sparklines, data bars, maps and indicators
  • Implementing Key Performance Indicators (KPIs)
  • Dragging and dropping visualization 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.ca/courses/140pf.htm
 
 
1-888-THE-TREE (1-888-843-8733)
PRODUCTIVITY THROUGH EDUCATION®
 

SQL Server 2008 Reporting Services: Hands-On Tuition

 
Course: 140   Duration: 4 Days
 
 
Course Tuition
$ 3,220Standard Tuition
Tuition with a Savings Plan
$ 2,2952-Course Passport
$ 1,8353-Course Passport
$ 1,7604-Course Passport
$ 2,950Voucher 5-Pack
$ 2,830Government Discount

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  
 

Tuition Savings Plans

2-Course Passport
  • 2 Courses in 12 months for $4,590
  • As little as $2,295 per course
  • Savings up to 35% per course
3-Course Passport
  • 3 Courses in 24 months for $5,500
  • As little as $1,835 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for $7,035
  • As little as $1,760 per course
  • Savings up to 50% per course
Training Vouchers
  • Save as much as $1,080 per course
  • Fully transferable
  • As low as $2,895 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 tuition.

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.ca/courses/140pf.htm