This interactive LAB based class is intended to teach administrators, power users, and managers how to build SQL Server Reporting Services reports.

Participants will learn how to create functioning reports that utilize filters, parameters, sub-reports, graphs and charts. They also will learn more advanced SSRS Report building techniques and features. We will introduce the Power BI / SSRS relationship and show what is possible.

SSRS Report Builder

• Installation

• Functions and uses

• Report Types & Uses

Report Filters

• Report filtering

• Query Parameters

Report Data Regions

• Table

• Matrices

• Lists

Report Security

• Report Level

• Folder Level

• Active Directory Connections

Graphs / Charts

• Indicators

• Embedded Charts

Report Filters (Adv)

• Active Directory Relationships

• Dynamics GP Relationships

Report Types

• Linked Reports

• Snapshot Reports

• Click through Reports

• Drill Down/Through

SSRS Portal

• 2016/17 feature

• Custom Branding

• KPI’s / Dashboard

Graphs / Charts

• Tree Maps

• Sunbursts

Preparation

• User need to have computer that is able to connect to the internet

• Have pre downloaded 2017 SQL developer addition ( https://go.microsoft.com/fwlink/?linkid=853016 )

• Be on time and ready to learn and ask questions

Audience

• SQL Programmers

• IT Professionals

• Dynamics Data / Report Professionals

• Power Users

Level

Beginner & Intermediate