Advance S-Curve using Power BI | English

Name: Advance S-Curve using Power BI | English
Rating: 4.5 (31 reviews)

Advance S-Curve using Power BI

Highest Rated

Created byMohamed Hisham Aboadma

Last updated 10/2023

English

English [Auto],

What you'll learn

Adjusted the weeks setup from P6 in Power Query
Getting the interval and cumulative plan value
Setup the financial period in P6 to store the update values every week
Setup the date table to get the PV and the EV in one curve
Getting the activity codes to Power BI
Link the codes with the curve to create dynamic chart interactive with the areas-zones etc.
Get the trend analysis
Get the variance, weight of variance, SPI, and the weight % for each activity

Course content

4 sections • 15 lectures • 2h 34m total length

Introduction3:15
Explore how to build a dynamic S-curve model in Power BI to track progress data from Primavera P6, generate earned value, baseline, and forecast for management decisions.

Baseline Export8:59
Export the Primavera baseline curve via resource assignment, then build an s-curve in Power BI using a flip-flop pivot (cumulative budget unit, budget unit, cumulative remain late, remain late unit).
Adjust the week in Power Query.8:14
Learn how to dynamically compute the maximum date in Power Query, convert dates to numbers, and add a custom column to create a robust weekly progress s-curve in Power BI.
Getting the Interval PV%11:32
Build an s-curve weekly and interval in Power BI by creating a decks table and measures to compute pv percentage from paget and budget units, while filtering out total value.
Getting the Cumulitve PV%9:31
Learn to compute cumulative PV% in Power BI by using DAX and CALCULATE with date filters, turning interval values into a cumulative curve and validating against total budget units.

Setup the Finanical period9:34
Learn to set up a financial period in Power BI, store weekly actuals, and align updates with the plan to prevent redistributing actuals and ensure accurate weekly trends.
How to Store the updates12:17
Learn how to store updates for trend analysis by recording the financial period and actuals in Primavera P6, using earned value, cumulative periods, and forecast adjustments.
Bring update to Power BI11:27
Learn how to bring updates into Power BI from an Excel update, clean headers, pivot and unpivot data, manage dates, and compute the estimate at completion from earned value.
Getting Interval |Cumulative EV%11:35
Create update curves in Power BI by building EV and AV measures, linking update to baseline, and computing cumulative and forecasted earned value metrics including estimate at completion.
Links the PV & EV in one Curve | Date Table4:47
Link PV and EV into a single S-curve by using a date table in Power BI for project planning and control, aligning activity dates and baselines with updates.
Getting the Activity Codes in Power BI6:51
Import and map activity codes in Power BI by creating a codes table in Excel, cleaning headers, and trimming spaces to guarantee a correct activity ID link.
Links the Code with S-Curve12:11
Learn to link activity codes to updates and baselines in Power BI and reflect earned value metrics on an s-curve, using advanced measures, filters, and calculate with all except area.
Getting the Trend Analysis13:27
Master trend analysis in Power BI by comparing earned value, plan, and actual with cumulative weekly data, and visualize area trends with filters and previous values.
Getting the Variance | variance wt% | SPI8:20
Compute variance and its weight in Power BI using earned value concepts, deriving variance percentage from EV and PV, and applying budget unit totals with phase-wise impact and SPI.

Requirements

Basics Power BI
Basics Primavera P6

Description

This course is designed to provide participants with the skills and knowledge required to create and analyze advanced S-curves using Power BI. The course covers more advanced topics such as cumulative S-curves, project forecasting, P6| Financial period, and advance Dax formula. Participants will learn how to use Power BI to create and analyze S-curves, and how to apply this knowledge to real-world scenarios in their own work.

Creating interval and cumulative S-curves in Power BI
Using financial periods in P6 to store updated project values.
Analyzing interval and cumulative EV %
Setting up a date table to join PV and EV data into one curve.
Developing custom measures and DAX formulas to calculate key project metrics.
Importing activity codes to Power BI
Linking activity codes with the S-curve to create dynamic and interactive charts.
Trend analysis using the S-curve.
Variance, weight of variance, SPI, and weight % analysis for each activity
Real-world examples of S-curve analysis
Best practices for S-curve analysis in Power BI
Ongoing support and resources for participants

Overall, this course is designed to equip participants with the skills and knowledge needed to optimize project performance and resource utilization using advanced S-curve analysis and Power BI.

This Course was built based on actual experience in presenting the progress for one of the Mega projects to the top management to allow and support the decision making.

Who this course is for:

Planning Engineers
Project Control
Project managers

Advance S-Curve using Power BI | English

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Baseline Data4 lectures • 38min

Update9 lectures • 1hr 30min

Dashboard1 lecture • 23min

Requirements

Description

Who this course is for: