Built around the same real case study as our PPE course — 164 buildings, 170 villas, external works, infrastructure and landscape worth more than 600 million USD — this course shows you how to manage project data and report it clearly. You convert Excel sheets into a proper database, link tables with relationships, and build reports and dashboards for planned vs actual value, man-hours, quantities and cash flow at any WBS level.
20Lessons
20 HoursDuration
LifetimeAccess
CertificateWith QR verification
What you’ll learn
- Understand construction project data and why managing it matters
- Know the difference between an Excel sheet and an Excel database, and build a good database
- Convert columns to rows and restructure data for reporting
- Develop and test a project database and link tables with relationships
- Distribute values, man-hours and quantities by week and month using Primavera dates
- Build dashboards of planned vs actual values based on EVM and man-hours
- Find activities that exceeded their budgeted hours and report hours lost and saved
- Create cash flow, man-hour and quantity reports by any WBS level, zone or BOQ item
Who this course is for
- Planning engineers
- Project controls engineers
- Project and construction managers
- Site and technical engineers moving into planning
Requirements
- Basic knowledge of Primavera P6 and Excel
- Recommended: Primavera Online Basic Course (free)
- Microsoft Excel and Primavera P6 to follow the practical exercises
What you get
Lifetime accessWatch every lesson anytime, as many times as you like.
Course filesDownload the lesson files, templates and tools.
WhatsApp support groupAsk questions and get answers from our team in the course group.
Articles libraryPractical articles, files and ready-to-use templates.
Course Q&AAnswers to common student questions, curated by our team.
Certificate of completionVerified with a QR code when you complete the course.
FAQ
What is the price?
Prices are in US dollars and vary from one country to another. The price shown on this page is the price for your country.
Do I need an account?
No. If you don’t have an account, it is created automatically during checkout.
How do I start after checkout?
You are enrolled automatically. Open the course page and start the first lesson.
Is this course right for me?
Yes, if you produce or use planning reports and want to build them faster and more accurately from your schedule data. You need basic Primavera P6 and Excel skills; if you are new, start with the free Primavera Online Basic Course.
Which files and tools do I get?
Lesson files for every step, plus special Excel sheets and macros that distribute project values, man-hours and quantities by week and month using Primavera dates.
Will new reports be added?
Yes. We keep adding new reports and dashboards based on the ideas and requests learners share in the course WhatsApp support group.
Is this course part of a package?
Yes. It is included in the Advanced Planning Package, together with two more courses and a bonus course.
What is in the Articles Library?
The course includes a library of practical articles, downloadable files and ready-to-use templates on data management, reporting and planning topics. Anyone can browse it in the Library tab; enrolled trainees can download every file.