In this video, you would learn the fundamentals of project control for the success of any project. This tutorial on how to build a report or dashboard in Power BI Desktop. This will give you inspiration and ideas on how to create and design your own reports in PowerBI platform. If you enjoy this video 🔥🔥🔥. Don't forget to like and subscribe! 🔔🔔🔔
Project Controls is a process that encompasses the resources, procedures, and tools for monitoring, and controlling all phases of the project lifecycle. This includes estimating, cost and schedule management, risk management, change management, earned value progressing, and forecasting.
Unleash Power BI in Project Control.
- Build interactive, beautiful and eye-catching dashboards.
- Develop Progress Curves based on Cost and Manhours.
- Create Progress Matrix. - Carry out Variance and Trend Analysis.
- Cost Variance and Earned Value Breakdown.
- After the schedule update is completed in Primavera P6, it takes "less than 30 seconds" to have everything ready in Power BI
PROJECT CONTROL AND AUTOMATION CONTENT
MODULE 1
1. Review of P6 data and layout
2. Exporting data from P6
MODULE 2
1. Power Bi user interface
2. Importing data to power Bi
3. Cleaning/Transforming the imported data
MODULE 3
1. Creating a template using PowerPoint
MODULE 4
1. Data visualization in power Bi
MODULE 5
2. Grouping the Data
3. Renaming the Fields
MODULE 6
Display the following Using card, slicer etc
1. project start
2. Finish date
3. Current date
4. Project planned man-hours
5. Project Actual man-hours
MODULE 7
Display the following Using card, slicer etc
1. Project budgeted cost.
2. Project total duration
3. Project elapse duration
4. Project remaining duration
5. Create SPI and CPI
MODULE 8
1. Creating and Managing relationship between tables
MODULE 9
1. Creating WBS level
MODULE 10
2. Creating look-ahead using slicer
3. Editing Interactions
4. Formatting the page
MODULE 11
1. Exporting data for Scurve
2. Clean/Transforming the Scurve Data
MODULE 12
1. Plotting Scurve with Budgeted labour unit.
2. Plotting Scurve with Budgeted Cost
MODULE 13
1. Formatting the chart
2. Creating calendar date
MODULE 14
1. Creating navigators
2. Creating filter cleaner
MODULE 15
1. Updating of Scurve SPI and CPI
MODULE 16
1. Adding image layout
MODULE 17
1. Adding HSE KPI and Conditional formation
MODULE 18
1. Connecting Power Bi to P6
Tags for search: #microsoftpowerbi #kevinstratvertpowerbiinspired #Microsofthowtopowerbi #powerbiprofessionals #guyinacubepowerbiinspired #powerbiupdated2023 #powerbiparkinspired #powerbicustomvisuals #nextlevelpowerbikpi #powerbidataanalyst #powerbidaxfunction #powerbiinspired #projectcontrol #projectcontroltechniques #projectplanning #projectmanagement #pmp #projectcontroltools #projectcontroltutorial #pmp #microsoftpowerbi #projectmanagement #microsoftpowerbi #kevinstratvertpowerbiinspired #Microsofthowtopowerbi #powerbiprofessionals #guyinacubepowerbiinspired #powerbiupdated2023 #powerbiparkinspired #powerbicustomvisuals #nextlevelpowerbikpi #powerbidataanalyst #powerbidaxfunction #powerbiinspired
27 июн 2024
