Mohamed Hisham Aboadma – Advance S-Curve using Power BI – English

Description

Mohamed Hisham Aboadma – Advance S-Curve using Power BI – English download , Mohamed Hisham Aboadma – Advance S-Curve using Power BI – English review , Mohamed Hisham Aboadma – Advance S-Curve using Power BI – English free

Mohamed Hisham Aboadma – Advance S-Curve using Power BI – English

This course includes:
2.5 hours on-demand video
10 downloadable resources

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

Introduction

• Introduction

Baseline Data

• Baseline Export
• Adjust the week in Power Query.
• Getting the Interval PV%
• Getting the Cumulitve PV%

Update

• Setup the Finanical period
• How to Store the updates
• Bring update to Power BI
• Getting Interval |Cumulative EV%
• Links the PV & EV in one Curve | Date Table
• Getting the Activity Codes in Power BI
• Links the Code with S-Curve
• Getting the Trend Analysis
• Getting the Variance | variance wt% | SPI

Dashboard

• Create Dashboard

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

Instructor

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

I am planning & control engineer ,PMP, PMI-SP & CCP certified and i take PRMG from  American university in Cairo.

i interested in project management  and the tools that enable me monitor and control my projects in right way to deliver a successful projects .

i interested in sharing my knowledge with any one want to learn.

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.