I help planners and project controls teams move from manual monthly reports to automated P6/XER to Power BI dashboards. Learn to build the system yourself, or have me build it for your project.
Every service is built on the same pipeline I use on live EPC projects: XER files in, a clean Power BI model out, refreshed every reporting period without rework.
An 8-session live course where you build the full P6 to Power BI reporting system on a real EPC portfolio.
Private live sessions from basics to advanced, paced to your projects and your gaps.
I build an automated Power BI dashboard for your project or portfolio. You drop the new XER in a folder and refresh.
Each page answers a question a project director asks at the monthly review. Pick the pages your project needs.
Traces each milestone back through its driving predecessors to the activity that pushed it.
Breaks period-on-period milestone movement into its contributing changes.
Added, deleted and modified activities, logic and durations between two XERs.
Tracks total float by activity and WBS across updates before it turns critical.
Baseline Execution Index (BEI) and forecast hit rate by period and by contractor.
Missing logic, leads and lags, hard constraints, high float and other DCMA checks.
Baseline and period start/finish variances for every activity, sortable and filterable.
Planned, actual and remaining manpower by week and by resource.
PV, EV, AC, SPI, CPI and S-curves across one project or a whole portfolio.
On my own FIDIC EPC projects, each reporting cycle took about two days of manual Excel work. With this pipeline, a new update is a file drop and a refresh.
From two days of manual Excel work each month to a folder drop and a refresh.
~2 days → seconds
Trace any late milestone back to the activity that is actually pushing it.
Driving path · added delay
Spot activities that will turn critical before they reach the critical path.
Critical within 2 updates
Why cost SPI makes a schedule look better than it is, and what SPI(t) shows.
SPI 0.85 vs SPI(t) 0.49
Every delay scenario and the best recovery plan for a live P6 schedule, in seconds.
859 activities · 45 s · 4 s
The real chance of meeting the P6 finish date, with P50 and P80 dates.
0.4% chance of the P6 dateWhich delay hurts the finish date most, and the best way to recover it. Read the case study →
Several P6 projects rolled into one Power BI portfolio view. Read the case study →
P6 XER files in a folder, the whole monthly report on refresh. Read the case study →
The real chance of meeting the P6 date, with P50 and P80 finishes. Read the case study →
Eight live sessions over 4 to 5 weeks. I build on screen, you practise as homework on the same dataset, and you leave with a working dashboard you can reuse on your own projects.
How P6 data is structured, what an XER holds and how Power BI reads it.
Parse the XER, keep the columns you need and set the right data types.
Turn your steps into a function and load every update from one folder.
Bring in baseline dates and budgets, then build measures, S-curves and KPIs.
Starting soon, finishing soon, at-risk and critical filters for the weekly meeting.
Planned, actual and remaining manpower from P6 resource assignments.
Layout, drill-downs and sharing the report with your team.
Find out which activity moved each milestone, and by how much.
I am a planning and project controls engineer with more than five years on EPC projects in data centres, oil and gas, and energy, worth over USD 100 million combined and delivered under FIDIC contracts.
Reporting was the bottleneck on every one of them. Each cycle meant about two days of copying P6 exports into Excel. So I built a P6 to Power BI pipeline that reads the XER files directly and refreshes the whole report in seconds.
Since 2024 I have built dashboards and delivered planning work for clients in the US, UK, Australia and the Middle East, and trained more than 100 professionals through my live course and one-to-one P6 coaching.
No. The course starts from how Power BI reads data. You should be comfortable with Primavera P6 basics: activities, WBS, baselines and updates.
Every session is recorded and shared with the batch, and you can ask questions about it in the support group.
Yes. It reads standard XER exports, so it works with any P6 project. If your schedule is not cost-loaded, the dashboard runs schedule-only and EVM can be added later.
It depends on the pages you need and whether it covers one project or a portfolio. Send me a sample XER and your current report, and I will give you a scope and a timeline.
Yes. Your files are used only to build your dashboard and are not shared or reused in training material.
All 14 schedule quality checks on one page, with the target for each and where to find it in Primavera P6.
Join the course waitlist, book P6 coaching or ask for a dashboard quote. Send a short note with your role and what you report on today, and I will reply within one working day.
Project Controls 360