Advanced SSRS


What Will You 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


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.



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.


What to Know Before the 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.

Curriculum For This Course

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

You may also like…