SQL Server Reporting Services (SSRS) - Authoring, Deploying, and Managing Reports

Master the art of authoring, deploying, and managing SQL Server Reporting Services reports to empower your organization's data analysis capabilities, tailored for database professionals and power users aiming to excel in self-service BI solutions.

Course Category Icon

Essential Skills Gained

Checkmark

Design comprehensive reports using SQL Server Reporting Services development tools.

Checkmark

Implement self-service BI solutions utilizing mobile reports and data modeling.

Checkmark

Manage and deploy reports through the SSRS Web Portal for efficient data analysis.

Checkmark

Understand and configure various report services data sources.

Format

  • Instructor-led
  • 5 days with lectures and hands-on labs.

Audience

  • Database professionals
  • BI developers
  • Power information workers
  • Report designers

Description

This course is an overview of how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.

Calendar icon

Upcoming Course Dates

August 25-29, 2025

7:00 AM - 3:00 PM

Virtual: Online - America/Los_Angeles

Enroll

$2995

November 3-7, 2025

8:00 AM - 4:00 PM

Virtual: Online - America/Denver

Enroll

$2995

Course Outline

Download PDF

Module 1 – Introduction: SSRS and the SSRS-verse

  1. What Is SSRS and How Is It Used?

  2. SSRS and Business Intelligence

  3. OLTP and OLAP

  4. SSRS Architecture and Tools

Module 2 – Data Objects

  1. Data Sources

  2. Data Sets

Module 3 – Building and Deploying a Basic Report

  1. Report Designer Solutions

  2. Data Binding

  3. The Tablix Table and List

  4. Simple Formatting

  5. Working with Expressions

  6. Using Grouping for Formatting and Aggregation

  7. Overview of Report XML

  8. Deployment to the Web Portal

  9. Report Designer vs. Report Builder

Module 4: Working with Summarized Data

  1. Hierarchical Group Objects

  2. Expression Scope

  3. Document Maps

  4. Recursive Hierarchies

  5. The Matrix Data Region

  6. Adjacent Groups

Module 5: Working with Parameters

  1. Query Parameters and Report Parameters

  2. Server-Side vs Client-Side Filtering

  3. Parameter Dropdowns

  4. Cascading Parameters

  5. Optional Parameters

Module 6: Advanced Parameters and Bookmarks

  1. Drilldown

  2. Drillthrough

  3. Using Parameters to Sort

  4. Using Parameters to Show/Hide Matrix Groups

  5. Subreports vs Nested Data Regions

  6. Go to Bookmark Action

Module 7: Formatting

  1. Headers and Footers

  2. Rich Text Formatting

  3. Placeholders

  4. Conditional Formatting

  5. Repeating and Freezing Column Headers

  6. Formatting for Excel

Module 8: Data Visualizations

  1. Charts

  2. Databars

  3. Sparklines

  4. Gauges

  5. Indicators

  6. Maps

  7. KPI Reports

Module 9: Web Portal Basics

  1. Web Portal Overview

  2. Creating Folders

  3. Managing Shared Objects

  4. Web Portal Report Properties

  5. Report Comments

  6. Branding the Web Portal

Module 10: Caching and Snapshots

  1. Report Processing Steps

  2. Caching Reports & Filtering

  3. Snapshot Reports & Filtering

  4. Historical Snapshots

Module 11: Automating Report Execution and Distribution

  1. Simple Subscriptions

  2. Data-Driven Subscriptions

  3. Shared Schedules

Module 12: Administering Reporting Services

  1. Configuration Managers

  2. Securing the Web Portal

  3. Monitoring Performance

Module 13: Mobile Reports

  1. Mobile Reports Overview

  2. Understanding and Preparing Mobile Reports Data

  3. Navigators and Visualizations

  4. Parameters and Drillthrough

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.