paccpro.com

Power BI – Essential Training (Primavera P6 + MS Excel)

Power BI – Essential Training (Primavera P6 + MS Excel)

Learn Power BI step by step for project management and scheduling. This beginner-friendly course uses real Primavera P6 project data to create dashboards, cashflow reports, S-curves, and progress visuals used on real projects.

30 Lesson Series
5.0 ★
Beginner Level
4–6 weeks to complete
Self Paced

What you'll learn

  • Understand the Power BI interface and build a strong foundation in data analysis
  • Import, clean, and transform project data using Power BI and Power Query
  • Create proper data models with table relationships and cardinality
  • Design clear and professional project dashboards and reports
  • Build cashflow reports and cumulative cashflow charts for projects
  • Import and analyze Primavera P6 schedule data in Power BI
  • Use DAX basics to create calculated columns, measures, and progress metrics
  • Create progress S-curves and plan vs actual visuals for project tracking
  • Format, export, and publish Power BI reports for sharing and presentation

Prepare for a Career in Project Reporting & Analytics

  • Learn Power BI from scratch with no prior experience required
  • Understand how Power BI is used in real project management and scheduling environments
  • Develop reporting and data visualization skills used by planning and project controls teams
  • Gain practical experience working with Primavera P6 project data
  • Build a strong foundation for advanced Power BI, project controls, and data analytics roles
  • Prepare for entry-level roles such as Junior Planner, Project Controls Assistant, or Power BI Analyst
Python Developer
Build a Reporting Portfolio Create dashboards for real project scenarios
Upto 6 Weeks Average Practice Time

Power BI for Project Management & Reporting – Complete Beginner Training

Learn Power BI the right way—step by step, without prior experience. This practical course takes you from beginner to confident project reporting professional, using real project and Primavera P6 data to build dashboards, cashflow reports, S-curves, and progress visuals in Power BI.

With Power BI skills in high demand across construction, engineering, infrastructure, and EPC projects, this self-paced training develops job-ready data analysis and reporting skills used in project management, planning, and project controls roles.

Why people choose PACCPRO for their career

"Faraz taught me project planning and Primavera P6 through personalized training, sharing his industry experience with real-life project examples and clearly addressing all my doubts."
testimonial4 free img.jpg
- Anas Ansari
(Planning Engineer, Valencia LLC, KSA)
"I learned practical planning and scheduling from Faraz, which helped me secure a job in Saudi Arabia. His strong technical knowledge and effective use of Primavera P6 made it easy for me to understand construction projects."
- Mohd Aazam
(Planning Engineer, CEPCO, KSA)
"Participated in a Primavera P6 Course where Faraz was our instructor. Faraz clearly has a deep understanding and knowledge of the software, was clear and delivered his lectures with confidence. Faraz contributed to a very positive, collaborative and calm atmosphere during our lecture and i would recommend Faraz to anyone who is looking into deepening their knowledge with Primavera P6."
- Ragnar Clausen
(Business Manager, Verkis Consulting, Iceland)
"Faraz’s mentorship played a key role in helping me secure a job. He guided me through job searching, interview preparation, and patiently cleared all my doubts. His practical advice and industry-focused approach gave me confidence and clarity throughout the process."
- Sima Ailim
(Scheduling Coordinator, Michels Canada Inc, Canada)

Course Content

Module 1: Getting Started with Power BI and Data Analysis
7 Topics
1. Welcome: What You’ll Learn in This Course
2. Introduction to Power BI for Project Management
3. Installing Power BI Desktop
4. Exploring the Power BI Interface
5. Understanding Data Structure: Unpivot & Transform in Power BI
6. Importing and Formatting Project Data in Power BI
7. Understanding Cardinality & Relationships between Tables
Module 2: Report Design & Primavera P6 Integration with Power BIa
11 Topics
1 Quiz
8. Creating Your First Cashflow Report
9. Formatting and Styling Your Report for Clarity
10. Building a Cumulative Cashflow Dashboard
11. Setting Up Power BI Data Source Connections
Assignment : Capstone Practical Assignment
12. Reviewing Primavera P6 Exported Data for Power BI
13. Preparing Activity Codes and Excel Files for Import
14. Importing Primavera P6 Data into Power BI
15. Building Reports with Matrix and Card Visuals
16. Interactivity, Slicers, and Report Formatting
Practical Assignment 2
Power BI – Essential Training Module 2 Quiz
Module 3: Advanced Analytics with DAX & Measures in Power BI
8 Topics
17. Introduction to DAX and Quick Measures
18. Creating Calculated Columns in Power BI
19. Using Measures to Simplify Analysis
20. Importing Baseline Program Data from P6
21. Building a Progress S-Curve in Power BI
22. Tracking Actual Progress (Part 1)
23. Tracking Actual Progress (Part 2)
24. Creating Plan vs Actual % Visuals
Module 4: Formatting and Publishing Power BI Reports
6 Topics
25. Formatting and Printing Your Report
26. Selecting Data and Exporting Reports
27. Designing Mobile-Friendly Reports
28. Publishing to Power BI Service
29. Course Wrap-Up & Key Takeaways
30. What’s Next: Continue Your Power BI Journey
Final Quiz
Power BI – Essential Training Final Quiz
jQuery(document).ready(function($){ $('.wc-proceed-to-checkout a.checkout-button br').remove(); });