SSRS Training Classes

SSRS Training Classes (Inhouse)

SSRS Training at SQL School Training Institute - carefully designed to offer complete real-time training on Report Design, Development, Testing, Tuning of Enterprise / Adhoc Reports and Email Subscriptions. Sessions are completely practical and Realtime with a real-time Project.

Prerequisites: Participant should have knowledge on SQL Server T-SQL Queries & Tuning to join this Real-time Practical SSRS Training Course.


Schedules for MSBI SSRS Classroom Training (Instructor Led)

Schedules Timings Free Demo
1: 8 AM to 9:30 AM Register Today
2: 8 PM to 9:30 PM Register Today

This MSBI SSRS Classroom Training Course (with PowerView) includes ONE Real-time Project.
Trainer Profile, Duration, Pricing
Trainer: Mr Sai Phanindra T (10+ Yrs Exp, MS FTE)
Duration: 2.5 Weeks (Mon - Fri/Sat)

Total Course Fee: INR 5500/-
Training Location & Lab:
SR Nagar - Ameerpet, Hyderabad (India). Map
Course includes Real-time Project, Placement, Support.

If none of the above SSRS Classroom Training schedules work for you? please opt for On-demand, 24x7 MSBI SSRS Training Videos


Module I: Basic SSRS Development
Module II: Advanced SSRS Development
Module III: SSRS Deployment and Security

Introduction to SSRS & Usage

  • SSRS Architecture and Tools
  • Three-Phase Report Life Cycle
  • Reporting Services Configurations
  • Report Server Database and TempDB
  • SSRS 2012 and Web Service URLs
  • SSRS 2014 and Web Service URLs
  • SSRS 2016 Report DB, Report Portal
  • Communication Ports & Encryptions
  • Execution Accounts and Usage
  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • RSCONFIG Tool and Limitations
  • PowerBI with SSRS - Desktop
  • PowerBI with SSRS - Mobile

Report Planning and Design

  • SSRS Report Authoring Options
  • Data Sources (RDS) Connections
  • Credentials and Security Options
  • Toolbox Items and Dataset Options
  • Table Reports and Matrix Reports
  • Report Images, Textbox and Globals
  • Dynamic Expressions and Options
  • Reporting Functions and Formatting
  • Report Headers and Report Footers
  • Enterprise and Ad-hoc Reports

Report DataSets and Joins

  • Working with Multiple DataSets
  • Joining Local and Shared Datasets
  • Configuring Dynamic DataSets
  • Working with Remote Datasets
  • Reusing XML and Shared Datasets
  • Dataset Import Options in RDL
  • LOOKUP Functions - Limitations
  • Sub Reports and Report Actions
  • Joining Rectangle & List Reports

Report Design and SubReports

  • Designing Wizard based Reports
  • Custom Reports and Report Groups
  • Row Drilldown and Column Grouping
  • Advanced and Static Options in SSRS
  • Chart Based Reports and Images
  • Using SSRS Expressions & Globals

Report Parameters & Usage

  • Report Parameters & Properties
  • Dynamic Report Parameters and Filters
  • Dependent Parameters & Usage
  • Multi Valued Nullable Parameters
  • Report Filters - Options and Types
  • Toolbox Filters and Limitations
  • Sub Reports and Report Actions
  • Parent-Child Report Parameters

Enterprise Reports in SSRS

  • Gauge Reports, Indicator Reports
  • Pie Charts, Bars and Spark Lines
  • Report Testing and Auto Refresh
  • Map Reports and Report Dashboads
  • Multiple Chart Areas in Dashboards
  • Report Dashboard & Limitations
  • Report Scorecards with SQL Queries
  • Exporting RDL Reports in SSRS

Map Reports and Cube Reports

  • Map Reports and Stored Procedures
  • Indicators with Map Reports
  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries with Cube Reports
  • MDX Filters with Sub Reports
  • Scorecards with MDX and DAX
  • Sub Reports versus Report Actions
  • Accessing and Controlling Reports

Report Builder & Power View

  • Designing DataSets in Report Builder
  • Chart and Map Wizard in Report Builder
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Publishing Report Parts with RB
  • Stored Procedures with Report Builder
  • Report Downloads and Edit Options
  • Power Pivot & PowerView Addins
  • Power View for RDLX Reports
  • Understanding Data Models
  • Tables, Charts and Data Bars
  • SparkLines and Data-Mashup
  • Report Builder Vs PowerView
  • New ReportBuilder Extensions
  • ReportBuilder Mobile Edition

Report Management Options

  • Report Manager Configurations
  • SSRS Report Builds and Deployment
  • Managing Data Source Security
  • Exporting and Importing Reports
  • Snapshot Management & Schedules
  • ReportServerTempdb Usage & Tuning
  • Linked Reports & Null Parameters
  • Report Caching and Memory Refresh
  • Managing Reporting Engine & Tuning
  • Report Execution Audits & Events
  • Tuning SSRS Reports & Memory Options

Subscriptions and Report Builder

  • Global and Shared Schedules
  • Report Subscriptions and Advantages
  • Email and Fileshare Subscriptions
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Data Source Credential Store Options
  • Subscription & Logging Options
  • Report Uploads and Downloads
  • Report Parts and Sub Reports
  • Report Sites and Parameter Options
  • Report Builder Connections & Caching
  • Report Builder Reports to RDL Entries

Report Security and Upgrades

  • Data Source Security Credentials
  • Report Server Security Levels
  • Security Options and Report Users
  • Content Manager and My Reports
  • Cloning Report Roles and Schedules
  • Report Browser and Report Publisher
  • Report (RDL) Configuration Options
  • Managing Configurations Files
  • RSConfig & Encryption (snk) Keys
  • SSRS Reports Upgradations
  • Scale-out Deployments in SSRS

Power View with SSRS

  • Managing RDL and RDLX Reports
  • Comparing PowerView and Report Builder
  • Drillthrough Report Management Options
  • Migrating Reports with SSRS and Excel
  • New SSRS Tuning Features in 2016
  • Migrating Reports from 2014 to 2016


SSRS Classroom Training Course Curriculum : Download Brochure


Our SSRS Trainings are completely practical, realtime. Register today for free Demo


Benefits of our SSRS Training Course:

After the SSRS Classroom Training participant should be able to:

  • Completely Practical and Realtime
  • Theory material provided in Advance
  • Highly Interactive and Interesting
  • Daily Tasks and Weekly Assignments
  • Certification Guidance and FAQs
  • 24x7 Server Access with Realtime DBs
  • Understand Report design, Identify DataSets, Joined Queries
  • Work with Report Parameters, Dataset Parameters and Filters
  • Design Linked Reports with Dynamic Filters and Parameters
  • Design Report variants including Gauge, Map & Indicator Reports
  • Tuning OLTP Reports and OLAP Reports - Caching and Snapshots
  • Deploy, Secure and Deliver Subscriptions and Email Reports


Trainer : Mr. Sai Phanindra T, 10+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

SQL School Reviews

Register Now



SQL Server, SQL DBA, MSBI DWH Trainings @ SQL School Training Institute


[+] More Courses

Register Today


Register Today For Free Demo