Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Business Intelligence Training









Preferred method of contact?

SQL Server Reporting Services

COURSE TYPE

Practitioner

Course Number

140

Duration

4 Days

Enroll

About This Course: SQL Server Reporting Services meets demanding requirements by providing a powerful and versatile reporting platform for 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.

You Will Learn How To

  • Leverage SSRS to extract Business Intelligence from your data
  • Produce reports with enhanced visualization features
  • Integrate parameters, filters and interactive components into reports
  • Deploy reports through Report Server and SharePoint
  • Create reports on SSAS cubes with Report Builder and Report Designer

Course Outline

  • Introduction to SQL Server Reporting Services
  • Identifying deployment: native, integrated or single-server
  • Managing web farm deployment with/without SharePoint
  • Developing Reports

Leveraging Reporting Services tools

  • Web reporting using Report Builder
  • Accessing the power of Visual Studio

Designing fundamental reports

  • Connecting to relational and multidimensional sources
  • Generating a Tablix reporting structure

Composing expressions

  • Computing custom fields
  • Linking expressions to properties

Arranging and sorting data

  • Multiple-level grouping and categorizing 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
  • Constructing cascading report parameters
  • Transmitting parameters to stored procedures

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
  • Navigating reports with document maps
  • Deploying and Delivering Reports

Deploying reports to the server

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

Identifying delivery options

  • Enhancing performance with cached instances
  • Configuring snapshot history

Dispatching subscription reports

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

Integrating reports with SharePoint

  • Deploying reports to SharePoint
  • Viewing results in Report Center and Data Connections
  • 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
  • Generating parameterized reports with MDX Builder

Designing reports for data visualization

  • Improving data visualization with sparklines, data bars, maps and indicators
  • Implementing Key Performance Indicators (KPIs)

Delivering reports to users

  • Accessing and controlling reports using URLs
  • Embedding reports in applications with the Report Viewer
  • Delivering reports through SharePoint
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Nov 8 - 11 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 15 - 18 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 13 - 16 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 19 - 22 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 3 - 6 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 10 - 13 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 14 - 17 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 21 - 24 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 14 - 17 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 4 - 7 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 18 - 21 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 25 - 28 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 9 - 12 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 16 - 19 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 23 - 26 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 11 - 14 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 8 - 11 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 22 - 25 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Sep 5 - 8 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“I benefited a great deal from the course materials, as well as the knowledge and helpfulness of the instructor. I look forward to putting to use everything I learned in this SSRS 2008 course.”

- B. Reed, Applications Systems Analyst
University of Virginia Medical Center

Prev
Next