Choose your language:

Hong Kong
New Zealand
United Kingdom
United States

Introduction to Power BI for Microsoft PPM

Course Code



2 Days

Power BI is Microsoft’s cloud reporting and business analytics tool suite used to analyze data and share insights. With Power BI, you can supercharge your PMO’s ability to monitor your projects, programs, and resources and get answers quickly with rich dashboards available on every device. This course teaches the core techniques that your business analysts and PMO need to use this powerful data mashup and report authoring tool against your Microsoft PPM environment. Participants of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.
This course is designed for project managers or business analysts.

In this course, participants will:

  • Describe the components of the Power BI suite and its benefits to a PMO
  • Display an understanding of the Project Online data schema
  • Perform basic transformations of Project Online data
  • Select appropriate visualizations for the data being reported
  • Apply appropriate filters to reports and dashboards
  • Build a PMO dashboard and deploy it to the online Power BI service
Learn the Power BI Solution
Power BI Solution Benefits
Key concepts in business intelligence
Components of the Power BI suite
Understand Layering of Reports & Report Features

Get Project Online Data
Accessing Reporting & Project Online data (ODATA)
Selecting and mining relevant tables

Basic Data Transformations
Building simple queries
Filtering queries
Table relationships
Changing data types
Introduction to custom columns and measures

Creating Power BI Reports
Understanding the hierarchy of datasets, reports, and dashboards
Creating tables and matrices
Selecting appropriate visualizations
Filtering visuals, pages, reports

Publishing Reports in Power BI Service
Publishing reports
Establish Data refresh for Reporting
Creating dashboards & multi-report dashboards
Sharing and distributing dashboards

Note: Detailed course objectives will be tailored based on client configuration
Send Us a Message
Choose one