<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / SQL Server / Advanced SSRS

Advanced SSRS

Our advanced SQL Server 2016/2017 Reporting Services (SSRS) class empowers report developers. Blend lectures with hands-on labs, learn to create complex reports using Analysis Services and custom code assemblies.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Report Developers must hold unique traits to set themselves and their work apart from others. This class is designed to take you to the next level in your understanding of SQL Server 2016/2017 Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage.

Course Outline ( Free Preview)

Advanced SSRS - What you need to get started

Module 00 - Class Introduction

Module 01 - Report Design Patterns

Module 02A - Using SSAS as a Data Source (Designing a Basic Report - Multidimensional) 16 min.

Module 02B - Using SSAS as a Data Source (Designing a Basic Report - Tabular) 16 min.

Module 02C - Using SSAS as a Data Source (Building a Dynamic Report) 34 min.

Module 02D - Using SSAS as a Data Source (Tips and Tricks) 19 min.

Module 03A - .Net Integration (Why Use Custom Code) 6 min.

Module 03B - .Net Integration (Embedded Custom Code) 25 min.

Module 03C - .Net Integration (External Assemblies) 21 min.

Module 04A - Advanced SSRS Expressions (Advanced Functions) 36 min.

Module 04B - Advanced SSRS Expressions (Launch Office Tools From Your Reports) 15 min.

Module 04C - Advanced SSRS Expressions (Launching Bing Maps) 9 min.

Module 05A - Report Manager (Linked Reports) 8 min.

Module 05B - Report Manager (Object Visibility) 5 min.

Module 05C - Report Manager (My Reports) 7 min.

Module 06A - Report Builder (Train the Trainer) 11 min.

Module 06B - Report Builder (Using Report Parts) 9 min.

Module 07 - SSRS Configuration (Setting up your SSRS Server) 20 min.

Module 08A - Report Utilization (Setting up the Solution) 13 min.

Module 08B - Report Utilization (Usage Reports) 7 min.

Module 09A - Security (Assigning Report Server Permissions) 16 min.

Module 09B - Security (Creating Custom Security Roles) 5 min.

Module 10A - Performance Tuning (Report Snapshots) 21 min.

Module 10B - Performance Tuning (Report Caching) 12 min.

Module 10C - Performance Tuning (SSRS Performance Counters) 13 min.

Module 11- Planning a Web Farm Architecture 19 min.

Module 12A - Data Driven Subscriptions (Building a Basic Subscription) 17 min.

Module 12B - Data Drive Subscriptions (Using Data Driven Subscriptions) 13 min.

Module 13 - Accessing Your Report Server Remotely 7 min.

Module 14A - Miscellaneous (Creating Report Templates) 7 min.

Module 14B - Miscellaneous (Using Document Maps) 5 min.

Module 14C - Miscellaneous (Reporting On Recursive Data) 7 min.

Module 14D - Miscellaneous (Refreshing Report Data From Word, PowerPoint, Etc) 6 min.

Module 14E - Miscellaneous (Using Reports to Start SQL Agent Jobs) 5 min.

Module 15A - Power BI Integration (Deploying SSRS Report Visuals to Power BI) 11 min.

Module 15B - Power BI Integration (Power BI Report Server) 6 min.

This course includes:

  • 7+ hours of training
  • 37 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing