Project Online Reporting with Power BI
1h 33mIntermediate2020-01-23
Authors
John Riopel
Program and Project Manager
Course details
Learn about how to create clear, visually compelling project reports with the Power BI interactive data visualization tools in Microsoft Project Online. In this course, John Riopel, PMP, offers an overview of 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 demonstrating how to work with tables, filter the right data using slicers, and format a basic report. Next, John covers intermediate features such as using samples and content packs, working with measures, and using conditional formatting. Finally, John shows how to work with advanced features such as creating and fine-tuning dashboards, merging datasets, and adding custom visuals to a report.
Topics include:
- Getting Started with Power BI
- Creating a Project Online data connection
- Creating a basic report
- Using samples and content packs
- Working with Power BI measures
- Creating calculated columns
- Working with conditional formatting
- Developing DAX expressions
- Fine-tuning reports and dashboards
- Adding custom visuals
- Merging datasets
- Sharing and publishing reports
- Embedding reports in Project Online
Topics include:
- Getting Started with Power BI
- Creating a Project Online data connection
- Creating a basic report
- Using samples and content packs
- Working with Power BI measures
- Creating calculated columns
- Working with conditional formatting
- Developing DAX expressions
- Fine-tuning reports and dashboards
- Adding custom visuals
- Merging datasets
- Sharing and publishing reports
- Embedding reports in Project Online
Skills covered
Microsoft Project OnlinePower BIOffice 365Business AnalyticsBusiness IntelligenceMicrosoft 365Data AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Creating detailed project reports with Power BI
- 02 - What to know before starting this course
1. Getting Started with Power BI
- 03 - How Power BI licensing works
- 04 - Understanding Power BI security
- 05 - Power BI architecture
- 06 - Using apps, samples, and content packs
- 07 - Creating a data connection
2. Creating a Basic Report
- 08 - An overview of Power BI visualizations
- 09 - Understanding Relationship View
- 10 - Working in tables and filters
- 11 - Creating slicers
- 12 - Formatting the report
- 13 - Publishing reports
- 14 - Saving a template
3. Intermediate Reporting Features
- 15 - Working with Power BI measures
- 16 - Creating calculated columns
- 17 - Working with conditional formatting
- 18 - Developing DAX (data analysis expressions)
- 19 - Preparing a mobile view
4. Advanced Features
- 20 - Creating a dashboard
- 21 - Fine-tuning reports and dashboards
- 22 - Adding custom visuals
- 23 - Merging datasets
- 24 - Using parameters
- 25 - Working with inner joins
- 26 - Embedding reports in Project Online
- 27 - Refreshing reports and dashboards
Conclusion
- 28 - Next steps