Power BI & Primavera P6 Integration for planning & control

Create Project Control Dashboard for planning Engineers and QS directly from Primavera without Excel for Construction

What you'll learn
Explain the Power BI Concept and data arrangement
Adjusting primavera p6 settings for Power BI and avoid wrong practices
Integrate Primavera P6 with Power BI without using Excel
Transform data, model the data, Learn DAX to create measures, and create visuals
Develop progress measurements, cashflow, manpower histogram, full and detailed analysis
Create interactive layouts and add progress photos interactive with the selection
Create full dashboard from zero step by step along with the formatting options for Real Project (12 buildings)
Create Gantt Chart in Power BI for delay analysis and viewing other information
Automate the data collection from site daily reports to power bi for manpower and costs
Detailed analysis of manpower (man-days)
Create commercial (Payments, Variations) Reports and Establishing Their Integration with Power BI.
Developing Comprehensive Dashboards and Conducting In-Depth Data Analysis.


Requirements
Primavera p6
Description
Learn how to prepare the Primavera P6 file ready to be linked with Power BI (Baseline and Update) directly without using excel, then transform and restructure the data, and adding relationships to model the data to create a full interactive dashboard containing Progress analysis, time and delay analysis, interactive layouts and sections, progress photos, track the Engineering works progress, analyze the manpower (man-days) planned vs budget vs actual from site daily report automatically, and finally analyze the project commercial stratus by tracking the payments and variations using automated excel-Power BI integration.
A pivotal aspect lies in the capability to delve into any project phase, enabling the retrieval of its status during that specific period.
use the interactive layout to reflect the data for the selected floor / building / block .. etc. and to shoe the related progress photos as well
you will also learn the methodology that Power BI handle the data and the relationships assigned between the data tables
finally, you can update the dashboard by clicking "REFRESH" after you finish the primavera p6 update
Track the Engineering works progress and highlight the maximum delayed package with detailed analysis
Save time in data analyzing, to gain time for the project
A pivotal aspect lies in the capability to delve into any project phase, enabling the retrieval of its status during that specific period.
Who this course is for:
Planning Engineers
Planners
Quantity Surveyors
Project Managers
project control

More Info