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.:
MS480
Experience Level:
Intermediate

Cost: $1,500

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 Onlineand 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