Primavera P6 & Excel Integration with Power BI Dashboard

Descripción

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. This course is designed specifically for infrastructure and construction professionals who want to transform Primavera P6 and Excel data into powerful Power BI dashboards. You will learn how to: • Import and connect Primavera and Excel data into Power BI • Clean, structure, and transform raw project data using Power Query • Create data models and build relationships between multiple project datasets • Create different types of visualizations • Build S-Curves and Planned vs Actual analysis • Develop KPI dashboards for SPI, CPI, and progress monitoring • Perform cost and delay analysis using advanced visuals • Design interactive dashboards using slicers, filters, and drill-down features • Create dynamic reports suitable for client presentations and management reviews • Create a complete live project dashboard from start to finish 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. By the end of this course, you will confidently build professional, management-level dashboards that improve transparency, reporting efficiency, and project decision-making.

Lo que aprenderás

• 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.

Requisitos

• Basic Primavera P6 knowledge, working Excel skills, understanding of project terms, and a laptop with P6, Excel, and Power BI installed are required.