Advanced SSRS
On-Demand Training

Starting At: $495.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Advanced SSRS
Per User Per Year
Business Intelligence Pack
Per User Per Year
Unlimited Elite Pack
Per User Per Year
Free Trial

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?


Course Details

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.

What You Will Learn?

  • 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 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.

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 (https://file.ac/4hcCTUOoLgk/Pragmatic%20SSRS%20Master%20Installation%20Guide.docx)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

Curriculum For This Course


Devin Knight

Director of Training

Devin Knight is our Training Lead overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books: "Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services", "Knight’s Microsoft Business Intelligence 24-Hour Trainer" and "SharePoint 2010 Business Intelligence 24-Hour Trainer." He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server User Group in Jacksonville, Florida (JSSUG).

Related Courses

Course Info
16 Comprehensive Modules
14 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
9h 58m
Download Syllabus
Enrollment Price:
Share this course with your friends