Monitoring and Controlling Using Power Bi and Primavera P6 -PMC
Microsoft Power BI is the future of business intelligence (BI). I have been studying this amazing software by Microsoft for 1 year and I successfully implemented it in the field of planning, scheduling, monitoring, and controlling. I have a similar feeling to my first impression of learning Excel, Do you remember how was your feeling when you created your first formula in Microsoft Excel? Do you remember how you were amazed by the excel capabilities? I promise you that after taking this course you will feel similar or even much better.
Microsoft Power BI is very easy software. However, it is magically solved the slow performance of excel for large data, added new amazing interactive reports, and give you too many possibilities to innovate and make creative reports. Therefore, we in Planning Engineer Est. studied this software very well and developed a complete Monitoring and Controlling System using Oracle Primavera, Our Excel Tools, Microsoft Power Bi, and our planning technique.
Simply, in this course we will convert a primavera cost and resource loaded schedule into the following:
1- Floor wise Weekly Planned Value VS Actual Value Chart.
2- Cumulative Planned VS Actual Weekly Value per Floor.
3- Clone the Weekly Values Report and Convert it to Weekly Hours Report.
4- Weekly Resources Assignment Report
5- Activity Wise Detailed Weekly Report
6- Shop Drawings and Materials Reports.
7- Look Ahead Schedule Reports.
8- Delay/Ahead Activities Reports.
9- Cost Control (Actual V.S Budget Cost, Man Hours).
10- Project Summary DashBoards.
11- Enterprise Report for more than one project.
12- Convert your Resume to an interactive online resume and get ready for your next job!
13- Much more reports, ideas, tips and tricks in the course support forums.
This course is suitable for planning engineers, planning managers, project managers, construction managers, and anyone who is involved in monitoring and controlling project progress. You do not need any previous experience in Microsoft Power Bi, this course includes all the required knowledge to convert a primavera schedule into effective interactive reports.
Note: This Course is not yet completed 100% Some lessons still being recorded and expected to be completed by end of December 2018. You can check the completed lessons from the Curriculum tap as per the picture below.
- Lectures 22
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 23
- Assessments Yes
Start Using Power Bi
Get The Data From Primavera Schedule
- Convert WBS to Activity Codes Part 1
- Activity Codes Tips and Tricks
- Convert Primavera Expenses to Resources
- How To Get The Baseline Dates From Primavera using our Excel Tool
- How To Get The Cost Per Week From Primavera using our Excel Tool
- How To Get The Update from Primavera (cost and resources) using our excel tool
Weekly Progress Report
- Create Floor wise Weekly Planned Value VS Actual Value Chart
- Create Cumulative Planned VS Actual Weekly Value per Floor
- Clone the Weekly Values Report and Convert it to Weekly Hours Report
- Create Weekly Resources Assignment Report
- Activity Wise Detailed Weekly Report
- Review of Reports and Data- How to validate your data
Shop Drawings and Materials Reports
Look Ahead Schedule Reports
Delayed/Ahead Activities Reports
Cost Control (Actual V.S Budget Cost, Man hours)
Overall Project Summary Dashboard
Enterprise Report For More Than One Project
Create An Interactive Online Resume By Power Bi
Continuous Improvement and Access to Support Forums