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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

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.

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Advanced SSRS - What you need to get started

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Manuel Quintana

Data Engineer (Azure) Trainer

Manuel Quintana has been teaching and developing training content for Pragmatic Works for the past 6 years. The areas of knowledge he has worked with includes the Microsoft SQL BI Stack (T-SQL, SSIS, SSAS, and SSRS), the Power Platform (Power BI, Power Automate, and PowerApps), and other various Azure services. Manuel has also authored a couple of books around Power BI and the Power Platform and participates within the community by presenting topics at various SQL Server or Power BI User groups.

Learn More

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8, Windows 10 - 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 or higher (Some features discussed are Enterprise/Developer edition only) - SQL Server Database Engine - SQL Server Reporting Services - SQL Server Analysis Services - SQL Server Data Tools (SQL 2012 or higher) or Business Intelligence Development Studio (SQL 2008/2008R2) - SQL Server Management Studio - Follow this [installation guide](https://www.youtube.com/playlist?list=PLcwrIWK7WBcRXS59lktaU9SJwb3cGgvCw) to ensure all items are installed correctly - Optional Full Visual Studio .Net Components. Used for only one module so this is not mandatory. - AdventureWorks and AdventureWorksDW databases installed on the instance. - AdventureWorks Cube installed on the Analysis Services instance.

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

7+ hours hours of training
Access on mobile and browser
Certificate of Completion