480-MS: Extending Microsoft Project Server Reporting with Microsoft SQL Server Reporting Services (Private Only)

2016 Courses

This three-day, instructor-led course provides students with the knowledge and skills to create Microsoft SQL Server® 2016 Reporting Services reports using Microsoft Project Web App® data from Microsoft Project Server® or Microsoft Project Online®.

Reference Nr.:
Experience Level:

Duration: 3 Days

PDUs: 24.0, Talent Triangle: Technical 24PMI Talent Triangle

Recommended Prerequisites:

  • Experience creating and manipulating Business Intelligence views in Microsoft Project Server® or Microsoft Project Online®  and Microsoft Excel®
  • Basic understanding of writing Microsoft SQL Server® queries
  • Proficient in using the reporting features of Microsoft Access®
  • Microsoft Project Web App® data resides in a cloud or on premise Microsoft SQL Server® database

Intended Audience:

  • Professionals who manage or support a Microsoft Project Server® or Microsoft Project Online® enterprise project management solution (“EPM”)
  • Professionals who manage or support programs and desire more in-depth reporting out of Microsoft Project Server® or Microsoft Project Online®

Course Objectives:
Upon completing this course, the student will be able to:

  • Understand Microsoft Project Server® or Microsoft Project Online® data organization (database schema)
  • Create a SQL Server® 2016 Reporting Services report template using Microsoft Project Server® or Microsoft Project Online® data 
  • Deploy a SQL Server® Reporting Services 2016 report template
  • Manage access to SQL Server® 2016 Reporting Services report templates
  • Subscribe to SQL Server® 2016 Reporting Services reports
  • Use SSRS reports in a Power BI dashboard