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

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.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
SQL101: Introduction to Transact SQL
SQL250: Transact-SQL for Developers

Detailed Class Syllabus

Module 1 – Introduction: SSRS and the SSRS-verse

Lesson 1: What Is SSRS and How Is It Used?
Lesson 2: SSRS and Business Intelligence
Lesson 3: OLTP and OLAP
Lesson 4: SSRS Architecture and Tools

Module 2 – Data Objects

Lesson 1: Data Sources
Lesson 2: Data Sets

Module 3 – Building and Deploying a Basic Report

Lesson 1: Report Designer Solutions
Lesson 2: Data Binding
Lesson 3: The Tablix Table and List
Lesson 4: Simple Formatting
Lesson 5: Working with Expressions
Lesson 6: Using Grouping for Formatting and Aggregation
Lesson 7: Overview of Report XML
Lesson 8: Deployment to the Web Portal
Lesson 9: Report Designer vs. Report Builder

Module 4: Working with Summarized Data

Lesson 1: Hierarchical Group Objects
Lesson 2: Expression Scope
Lesson 3: Document Maps
Lesson 4: Recursive Hierarchies
Lesson 5: The Matrix Data Region
Lesson 6: Adjacent Groups

Module 5: Working with Parameters

Lesson 1: Query Parameters and Report Parameters
Lesson 2: Server-Side vs Client-Side Filtering
Lesson 3: Parameter Dropdowns
Lesson 4: Cascading Parameters
Lesson 5: Optional Parameters

Module 6: Advanced Parameters and Bookmarks

Lesson 1: Drilldown
Lesson 2: Drillthrough
Lesson 3: Using Parameters to Sort
Lesson 4: Using Parameters to Show/Hide Matrix Groups
Lesson 5: Subreports vs Nested Data Regions
Lesson 6: Go to Bookmark Action

Module 7: Formatting

Lesson 1: Headers and Footers
Lesson 2: Rich Text Formatting
Lesson 3: Placeholders
Lesson 4: Conditional Formatting
Lesson 5: Repeating and Freezing Column Headers
Lesson 6: Formatting for Excel

Module 8: Data Visualizations

Lesson 1: Charts
Lesson 2: Databars
Lesson 3: Sparklines
Lesson 4: Gauges
Lesson 5: Indicators
Lesson 6: Maps
Lesson 7: KPI Reports

Module 8: Web Portal Basics

Lesson 1: Web Portal Overview
Lesson 2: Creating Folders
Lesson 3: Managing Shared Objects
Lesson 3: Web Portal Report Properties
Lesson 4: Report Comments
Lesson 5: Branding the Web Portal

Module 9: Caching and Snapshots

Lesson 1: Report Processing Steps
Lesson 2: Caching Reports & Filtering
Lesson 3: Snapshot Reports & Filtering
Lesson 4: Historical Snapshots

Module 10: Automating Report Execution and Distribution

Lesson 1: Simple Subscriptions
Lesson 2: Data-Driven Subscriptions
Lesson 3: Shared Schedules

Module 11: Administering Reporting Services

Lesson 1: Configuration Managers
Lesson 2: Securing the Web Portal
Lesson 3: Monitoring Performance

Module 12: Mobile Reports

Lesson 1: Mobile Reports Overview
Lesson 2: Understanding and Preparing Mobile Reports Data
Lesson 3: Navigators and Visualizations
Lesson 4: Parameters and Drillthrough