PBI-P6 XML connection-construction project report 🔍Key Features
- Integration of Primavera P6 data using XML export
- Automatically generated S-Curve to monitor planned vs actual progress
- Gantt chart visualizing task durations and dependencies
- Baseline variance visuals to compare current vs original plans
- Custom DAX measures for project progress KPIs
- Clear layout optimized for project reporting and stakeholder reviews
🔧 Tools & Technologies
- Power BI Desktop
- Primavera P6 (XML Export)
- Power Query (M)
- DAX (Data Analysis Expressions)
📌 Business Use Case
Project planners often rely on Primavera P6 for scheduling, but its built-in reporting is limited for visual analysis. This dashboard bridges that gap by transforming XML exports into an interactive, visual Power BI report — giving project managers and stakeholders a clearer view of schedule performance and variance. 🧠 What I Demonstrated
- Parsing and transforming Primavera XML data in Power Query
- Developing variance metrics using DAX
- Building professional Gantt charts and S-curves in Power BI
- Presenting data in a clean, stakeholder-friendly layout
- Applying project planning expertise within modern BI tools
This project is licensed under the Creative Commons Attribution-NonCommercial 4.0 International (CC BY-NC 4.0).
- ✅ You may view and share the dashboard for personal or educational use.
- ❌ Commercial use or redistribution is not permitted.
- 🔗 View the license