Microsoft Project for the Web: Reporting with Power BI

Microsoft Project for the Web: Reporting with Power BI

1h 40mIntermediate2022-06-07

Authors

John Riopel

John Riopel

Program and Project Manager

Course details

Create clearer, more visually compelling project reports using Power BI, the data visualization tool included with Office. In this course, John Riopel, PMP, gives project management professionals a crash course in Power BI, explaining how it can be used to create more robust project reports. John starts with the basics, explaining the main components of Power BI and showing you how to work with tables, filter the right data using slicers, and format a basic report. Next, John covers more intermediate features of Power BI, such as using samples and content packs, working with measures, and using conditional formatting. Finally, John explains how to work with advanced features, like creating and fine-tuning dashboards in Power BI, merging datasets, and adding custom visuals to your report.

Skills covered

Microsoft ProjectProject Management SoftwarePower BIOffice 365Business AnalyticsBusiness IntelligenceMicrosoft 365Project ManagementData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off

Concepts

Introduction

  • Microsoft Project for the web - Reporting with Power BI
  • What you should know
  • Exercise Files

Getting Started

  • Determining licenses
  • Understanding Power BI terms
  • Working with the Project for the web Power BI template
  • Understanding the Dataverse
  • Modifying a query

Power BI Basics

  • Overview of Power BI visualizations
  • Working in tables
  • Creating slicers
  • Using formatting in Power BI
  • Finalize a basic report
  • Create a reusable connection

Power BI for Project for the Web - Intermediate

  • Creating a parameter and staging tables
  • Building report tables
  • Working with measures
  • Creating calculated columns
  • Working with conditional formatting
  • Developing DAX expressions
  • Preparing a mobile view

Power BI for Project for the Web - Advanced

  • Building a dashboard
  • Tuning reports
  • Adding custom visuals
  • Working with relationships
  • Merging data sets
  • Sharing and publishing reports
  • Working within Teams with Power BI
  • Refreshing reports and dashboards

Conclusion

  • Review and next steps
40,000 Toman