Advance S-Curve using Power BI | English

Advance S-Curve using Power BI | English, available at $49.99, has an average rating of 4.35, with 15 lectures, based on 15 reviews, and has 119 subscribers.

You will learn about 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 This course is ideal for individuals who are Planning Engineers or Project Control or Project managers It is particularly useful for Planning Engineers or Project Control or Project managers.

Enroll now: Advance S-Curve using Power BI | English

Summary

Title: Advance S-Curve using Power BI | English

Price: $49.99

Average Rating: 4.35

Number of Lectures: 15

Number of Published Lectures: 15

Number of Curriculum Items: 15

Number of Published Curriculum Objects: 15

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Planning Engineers
Project Control
Project managers

Target Audiences

Planning Engineers
Project Control
Project managers

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Baseline Data

Lecture 1: Baseline Export

Lecture 2: Adjust the week in Power Query.

Lecture 3: Getting the Interval PV%

Lecture 4: Getting the Cumulitve PV%

Chapter 3: Update

Lecture 1: Setup the Finanical period

Lecture 2: How to Store the updates

Lecture 3: Bring update to Power BI

Lecture 4: Getting Interval |Cumulative EV%

Lecture 5: Links the PV & EV in one Curve | Date Table

Lecture 6: Getting the Activity Codes in Power BI

Lecture 7: Links the Code with S-Curve

Lecture 8: Getting the Trend Analysis

Lecture 9: Getting the Variance | variance wt% | SPI

Chapter 4: Dashboard

Lecture 1: Create Dashboard

Instructors

Mohamed Hisham Aboadma
Project Control Manager , PMP, PMI-SP, CCP, P3O

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 2 votes
5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu