Aantal dagen

1 day(s)

Audience

Candidates for this course are System Administrators, Project Managers and Team Leaders who operate in medium to large computing environments who want to create reports about the projects managed in the Project Server Environment.

Prerequisites

Before attending this course, students must have a good knowledge of Microsoft Project in general. Having a working knowledge of basic project management concepts is also needed.

Objectives

This training provides students the knowledge and skills necessary to effectively create and manage reports via different connections and tools about managed projects.

Methods

Class training alternated with exercises. Each student disposes of a workstation. For each module, the explained items will be performed in practice.

Description

Project Server users can choose between different connection methods and different tools to create reports about project data. This training describes each of these methods and tools, with best practices and recommendations. Power Bi is actually the first choice for reporting purposes, and will in detail been explained. Other tools as Excel and SQL Server reporting services will be explained, but less intensively used. By creating DAX measures we will calculate the most common KPI's for the project manager.

Contents

• Connection options
  • Connection to Odata
  • Connection to SQL Server Reporting tables/views
• Connection Tools
  • Excel Power Tools : Power Pivot, Power Query
  • Power BI
  • SQL Server reporting services
• Using the Microsoft Project online Content Pack in Power BI
  • Project Portfolio Dashboard/Timeline/Costs/Milestones/Risks/Issues
  • Resource availability/Overview/Assignments/Details/Demand forecast
  • Project status/Risks/Issues
• Creating your own reports and dashboards in Power BI
  • Gantt Chart by MAQ Software
  • Timephased Resource work/cost overview(matrix visual)
  • Task work/cost overview (table visual)
  • Using the Advanced Timeline Slicer to filter projects/resources
• DAX usage to create columns and measures
  • NRofTasksComplete
  • NRofTasksBusy
  • NRofTasksUnstarted
  • Cost KPI (CKPI)
  • Cost variance State
  • Cost Health indicator
• Security in reporting : Apply Row level Security in Power BI
  • Securing access to project information via RLS
  • Securing access to resource information via RLS