Note: Academy classes require a separate registration.
Click here to register.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