Business Intelligence

Preferred method of contact:

SQL Server Reporting Services



Course Number



4 Days

View Schedule

Gain an in-depth introduction to leverage SQL Server Reporting Services (SSRS), and glean business intelligence from your data. Attain the knowledge and skills to produce compelling reports with enhanced visualization features. This training course enables you to go beyond the physical limitations of your organization to deliver data and share information with others — when you want and how you want. Starting in Spring 2017, this course will transition to the following Microsoft version: "Implementing Data Models and Reports with Microsoft SQL Server 2014 (20466)" (Course 8468)

You Will Learn How To

  • Produce reports with enhanced visualization features
  • Leverage SSRS to extract business intelligence from your data
  • 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

Important Course Information


  • Working database knowledge at the level of:
    • Course 2107, SQL Server Introduction, or equivalent experience with Access or Oracle

Recommended Experience:

  • Visual Studio knowledge and a fundamental programming background


  • This course uses Microsoft SQL Server 2014, running on Windows Server 2013 R2
  • This course is applicable to those using earlier versions of SQL Server

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.

Apr 25 - 28 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Guaranteed to Run

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






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.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

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



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.

Earn 23 Credits from NASBA

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


Please Choose a Language

Canada - English

Canada - Français