Integrated power bi and primavera 6 dashboard

Name: Integrated power bi and primavera 6 dashboard
Rating: 3.9 (7 reviews)

Learn to build powerful integrated dashboards with Power BI & Primavera P6

Created byHamed Zolfaghari

Last updated 9/2025

English

English [Auto],

What you'll learn

Understanding the Basics of Microsoft Power BI and Primavera P6
Data Integration Techniques
Creating Interactive Dashboards
Advanced Data Visualization Techniques

Course content

7 sections • 16 lectures • 3h 7m total length

Introduction1:22

Download and Installation of Power BI report Server10:09
In this section you will learn how to download and install power BI report server.
Power BI Report Server is the on-premises solution for reporting today, with the flexibility to move to the cloud tomorrow. It's included with Power BI Premium so you have the ability to move to the cloud on your terms as Microsoft said.
by the means of Power BI report server you can Create, publish, distribute your Power BI reports
Download and Installation of Power BI Report Server Desktop2:55
Download and install Microsoft Power BI Report Server Desktop by following on-screen steps, then publish dashboards to the report server; the desktop version is similar to Power BI Desktop.

08-Dynamically flatten Parent-Child Hierarchies9:41
Connect SQL Server databases to Power BI and load project, webs, and task tables. Build dynamic parent-child hierarchies with M code to mirror Primavera P6 WBS structures.
09-Flatten Parent Child manually20:58
Build a hierarchical WBS by manually flattening parent–child relationships with Power Query and DAX, then validate in a Primavera 6 dashboard in Power BI using slicers.
Date Table By M Query7:49
Create a date table in Power Query editor using M query, define start and end dates, compute duration, and add year, month, month name, day, and day name.
Main Metrics Calculations by measure16:34
Create dax measures like duration and elapsed days using date diff on start and finish dates, with holiday adjustments and dynamic not-started status for Power BI and Primavera 6.
Organizationa Breakdown Structure15:34
Learn to build an organizational breakdown structure (OBS) in Power BI Desktop from Primavera six data, using custom visuals and a hierarchical slicer for dynamic insights.
Organizational Breakdown Structure with xViz Performance Flow16:25
14-Draw plan S_ Curve25:59
Draw Actual S_Curve31:32
Draw the actual S-curve by updating the plan and shaping data in Power Query, exclude weekends, and compare with Primavera 6 for labor cost insights.

Requirements

Basic Understanding of Project Management
Basic Knowledge of Data Visualization Concepts
Familiarity with Microsoft Excel
Willingness to Learn and Explore

Description

Master Integrated Power BI and Primavera P6 Dashboards
Transform your project data into stunning, interactive dashboards with this comprehensive course on Power BI and Primavera P6 integration. Whether you're a project manager, data analyst, or professional seeking to elevate your reporting skills, this course guides you step-by-step from extracting Primavera P6 data to building dynamic dashboards in Power BI. Learn to create professional visualizations that drive better decision-making and impress stakeholders.

What You'll Learn

Extract and prepare project data from Primavera P6 for Power BI
Design interactive and professional dashboards in Power BI
Integrate Primavera P6 data with Power BI for seamless analysis
Apply advanced visualization techniques for project reporting
Build actionable reports tailored to project stakeholders
Optimize dashboards for faster, data-driven decisions

Who This Course Is For

Project managers aiming to deliver impactful visual reports
Data analysts interested in mastering Power BI with Primavera P6
Professionals in project management seeking in-demand skills
Students or engineers looking to boost their resume with practical expertise

Course Features

Over 8 hours of high-quality video content
5 hands-on projects to build your portfolio
Downloadable resources and Q&A support
Practical exercises to reinforce real-world skills

Start creating powerful dashboards today and take your project management and data analysis skills to the next level!

Who this course is for:

Project Managers
Data Analysts
Business Analysts
Anyone Interested in Data Visualization

Integrated power bi and primavera 6 dashboard

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Prerequisites2 lectures • 7min

Primavera and SQL server Integration1 lecture • 9min

Download and Installation of Power BI Desktop1 lecture • 3min

Direct Connection of primavera 6 and Power BI1 lecture • 9min

Download and Installation of Power BI report Server2 lectures • 13min

Start To Build Dashboard8 lectures • 2hr 25min

Requirements

Description

Who this course is for: