Microsoft Project for the Web: Reporting with Power BI
1h 40mIntermediate2022-06-07
Authors

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