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.
The course is around 8 hours of recorded videos, along with practice file which expected to take from you around 22 hours. So if you spent 30 hours in this course you will learn a new amazing skills which could add much more power to your reports and enhance your monitoring and controlling skills in just 30 hours.
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.
- Lectures 32
- Quizzes 0
- Duration 8 hours Videos + 22 hours practice
- Skill level All levels
- Language English
- Students 120
- 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
Course Completion Certificate
P6 Power Bi Integration
Excellent course. Down to earth, with simple example explain how to apply Power BI to report the Primavera P6 information in a way that can be understood by non planning people, helping to boost the planning role within the project. It does a mature organization to have discipline within the planning function in order to allow the magic to happen in Power BI. Explain some good tricks in using Power BI with Primavera P6 extracted data.
Very useful and creative thx a lot
The Required Program in Reporting System
Very Good Cource I Highly Recommend this Cource to ALL Who is Involved in The Field of Monitoring and ControlingThis is the Future Realy