Advanced SSRS


  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • How to master advanced topics of reporting services like scaled-out deployment, .Net integration and monitoring reporting services usage
This course includes:

Course Description

Advanced report developers must hold unique traits to set themselves and their work apart from others. This course is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.


Click here for a downloadable PDF



Module 00 | Class Introduction
06m 06s total


Module 00A | Class Introduction
06m 06s


Module 01 | Report Design Patterns
19m 36s total


Module 01A | Report Design Patterns
19m 36s


Module 02 | Using SSAS as a Data Source
85m 01s total


Module 02A | Designing a Basic Report – Multidimensional
15m 53s


Module 02B | Designing a Basic Report – Tabular
16m 14s


Module 02C | Building a Dynamic Report
34m 20s


Module 02D | Tips and Tricks
18m 34s


Module 03 | .Net Integration
51m 42s total


Module 03A | Why Use Custom Code
05m 39s


Module 03B | Embedded Custom Code
25m 19s


Module 03C | External Assemblies
20m 44s


Module 04 | Advanced SSRS Expressions
59m 35s total


Module 04A | Advanced Functions
35m 51s


Module 04B | Launch Office Tools From Your Reports
15m 04s


Module 04C | Launching Bing Maps
08m 40s


Module 05 | Report Manager
19m 31s total


Module 05A | Linked Reports
07m 59s


Module 05B | Object Visibility
04m 49s


Module 05C | My Reports
06m 43s


Module 06 | Report Builder
20m 22s total


Module 06A | Train the Trainer
10m 59s


Module 06B | Using Report Parts
09m 23s


Module 07 | SSRS Configuration
19m 39s total


Module 07A | Setting up your SSRS Server
19m 39s


Module 08 | Report Utilization
19m 31s total


Module 08A | Setting up the Solution
12m 38s


Module 08B | Usage Reports
06m 53s


Module 09 | Security
21m 08s total


Module 09A | Assigning Report Server Permissions
16m 25s


Module 09B | Creating Custom Security Roles
04m 43s


Module 10 | Performance Tuning
46m 26s total


Module 10A | Report Snapshots
21m 13s


Module 10B | Report Caching
11m 51s


Module 10C | SSRS Performance Counters
13m 22s


Module 11 | Planning a Web Farm Architecture
19m 24s total


Module 11A | Planning a Web Farm Architecture
19m 24s


Module 12 | Data Driven Subscriptions
29m 26s total


Module 12A | Building a Basic Subscription
16m 35s


Module 12B | Using Data Driven Subscriptions
12m 41s


Module 13 | Accessing Your Report Server Remotely
06m 59s total


Module 13A | Accessing Your Report Server Remotely
05m 59s


Module 14 | Miscellaneous
29m 56s total


Module 14A | Creating Report Templates
07m 03s


Module 14B | Using Document Maps
04m 49s


Module 14C | Reporting On Recursive Data
06m 31s


Module 14D | Refreshing Report Data From Word, PowerPoint, Etc
05m 59s


Module 14E | Using Reports to Start SQL Agent Jobs
04m 34s


Module 15 | Power BI Integration
16m 03s total


Module 15A | Deploying SSRS Report Visuals to Power BI
10m 43s


Module 15B | Power BI Report Server
05m 50s



Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.


Click Here To Learn More About Manuel And See Certifications And Reviews

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
    • **Optional** Full Visual Studio .Net Components. Used for only one module so this is not mandatory.
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • AdventureWorks Cube installed on the Analysis Services instance

What to Know Before Class

This class assumes attendees have a strong understanding of SSRS fundamentals. For example, students should already know and use the majority of the toolbox items before attending this class. It is not mandatory, but ideally attendees should have an instance of SharePoint to follow some sections of the class.

I learned a lot and have been able to implement some of the things in my reports.


Excellent trainer.



- Behailu M.

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!