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

Become an EPIC Affiliate

To view the class schedule you need to become an Affiliate

  • Largest “Guaranteed To Run” public technical training schedules available
  • Easy to become an Affiliate – no charge or fee
Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

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.

Audience Profile

The primary audience for this course is database professionals who want to learn about creating reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.

At Course Completion

Outline

Module 1 – Introduction: SSRS

Lessons:

  • What Is SSRS?
  • SSRS Architecture
  • SSRS Tools

Module 2 – An overview of OLTP & OLAP

Lessons:

  • OLTP and OLAP databases
  • Dimensional Model
  • OLTP and OLAP
  • OLAP query considerations

Module 3 – Authoring Fundamentals in SSDT

Lessons:

  • Report Designer Solutions
  • Data objects
  • The Tablix object
  • Simple Formatting
  • Expressions
  • Interactivity
  • Report XML
  • Deployment to the Web Portal
  • Report Designer vs. Report Builder

Module 4: Summarized Data

Lessons:

  • Data vs report grouping
  • Hierarchical Group Objects
  • Expression Scope
  • Document Maps
  • The Matrix Data Region
  • Adjacent Groups
  • Recursive Hierarchies

Module 5: Formatting

Lessons:

  • Headers and Footers
  • Test box formatting
  • Other formatting

Module 6: Working with Parameters

Lessons:

  • Introducing parameters
  • Applying parameters
  • Displaying parameters values

Module 7: Visualizations

Lessons:

  • Charts
  • Other chart visualizations
  • Maps
  • KPI Reports

Module 8: Introducing the Web Portal

Lessons:

  • Web Portal basics
  • Cached reports
  • Snapshots
  • Subscriptions

Module 9: Administering Reporting Services

Lessons:

  • Configuration manager
  • Securing the Web Portal
  • Monitoring Performance

Module 10 Mobile Reports

Lessons:

  • Mobile Reports Overview

Prerequisites

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

or

SQL250: Transact-SQL for Developers