Primavera P6 & Excel Integration with Power BI Dashboard

<div>In today’s infrastructure projects, data-driven decision making is essential. Planning engineers and project control professionals must go beyond schedules and spreadsheets to create clear, professional dashboards for management and clients.</div><div><br></div><div>This course is designed specifically for infrastructure and construction professionals who want to transform Primavera P6 and Excel data into powerful Power BI dashboards.</div><div><br></div><div>You will learn how to:</div><div><ul><li><span style="font-size: 1rem;">Import and connect Primavera and Excel data into Power BI</span></li><li><span style="font-size: 1rem;">Clean, structure, and transform raw project data using Power Query</span></li><li><span style="font-size: 1rem;">Create data models and build relationships between multiple project datasets</span></li><li><span style="font-size: 1rem;">Create different types of visualizations</span></li><li><span style="font-size: 1rem;">Build S-Curves and Planned vs Actual analysis</span></li><li><span style="font-size: 1rem;">Develop KPI dashboards for SPI, CPI, and progress monitoring</span></li><li><span style="font-size: 1rem;">Perform cost and delay analysis using advanced visuals</span></li><li><span style="font-size: 1rem;">Design interactive dashboards using slicers, filters, and drill-down features</span></li><li><span style="font-size: 1rem;">Create dynamic reports suitable for client presentations and management reviews</span></li><li><span style="font-size: 1rem;">Create a complete live project dashboard from start to finish</span></li></ul></div><div><span style="font-size: 1rem;">This course goes beyond theory and focuses on real-world application. You will work with practical infrastructure project data similar to metro rail, elevated corridor, and large-scale construction projects. Each concept is explained step-by-step so that even beginners can follow, while experienced professionals can enhance their reporting and analytical skills.</span></div><div><br></div><div>By the end of this course, you will confidently build professional, management-level dashboards that improve transparency, reporting efficiency, and project decision-making.</div>

What you'll learn:

• Strong foundation in project data structure covering WBS, activity codes, baselines, and resource loading for accurate reporting and control.
• Primavera P6 data extraction at real project level covering activities, baselines, resources, costs, relationships, and clean data export for reporting and anal
• Advanced Excel skills for planning engineers including pivot tables, S-curves, earned value analysis, look-ahead tracking, dashboards, and schedule performance
• Power BI integration with Primavera P6 for real-time dashboards, S-curves, SPI/CPI tracking, critical path monitoring, and automated project performance reporti
• This case study is based on an elevated metro corridor package comprising pier, pier cap, and segmental viaduct construction.
• Comparison of progress between Baseline and Updated Schedule.