Search
Close this search box.

Progress Measurement sheet (PMS)

Progress Measurement Sheet (PMS) – A Comprehensive Guide

In today’s dynamic project management landscape, the essence lies in accurately tracking and measuring progress. The Progress Measurement Sheet (PMS) stands out as an instrumental tool, offering a methodical way to oversee every aspect of a project.

What is PMS?

The PMS is a versatile tool crafted to capture a project’s real-time status. It consolidates crucial metrics, activities, and milestones, presenting them in a clear and concise manner. For project managers, stakeholders, or team members, the PMS is a beacon of clarity, ensuring everyone stays on the same page.

Why Pair Plannex Excel Tool with PMS?

 I present the Plannex Excel tool, which I developed to assist planning engineers in enhancing repetitive Excel tasks. The series offers insights into data transition from P6 to Excel, understanding resource distribution nuances, and the practical application of the Plannex tool in crafting a PMS. Here’s how:

  1. Automation: Gone are the days of manual data entry. With Plannex, you can automate various tasks, from data import to generating reports, saving valuable time and reducing errors.

  2. Support for P6: While Plannex doesn’t directly integrate with Primavera P6, it offers robust support for it. This means you can easily incorporate data from P6 into your PMS, ensuring a comprehensive view of your project’s status.

  3.  

  4. Advanced Analytics: Dive deep into your project’s metrics with Plannex’s advanced analytics capabilities. From trend analysis to predictive modeling, gain insights that drive informed decision-making.

Conclusion

The combination of PMS and the Plannex Excel tool offers a robust solution for project managers and teams. It not only streamlines the tracking process but also provides actionable insights, ensuring projects stay on track and achieve their objectives.

“Progress Measurement sheet (PMS) ” Training:
I’ve crafted a comprehensive Udemy course, available for free in both Arabic / English.
Additionally, this course is accessible on YouTube: Arabic playlist , English playlist 

Explore these videos to unravel the depths of PMS and Plannex. Whether you’re just starting out or are a seasoned expert, this content is designed to bolster your project management acumen.

Leave a Reply

Your email address will not be published. Required fields are marked *

Create Progress Measurement Sheet (PMS)

Progress Measurement Sheet PMS
ARABIC
ENGLISH

About the Course:

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.

—————————————————————————————————————————–

تهدف هذه الدورة إلى تزويد المشاركين بالمهارات والمعرفة اللازمة لإنشاء وتحليل منحنيات التقدم (S-Curve) , الكورس يغطي العديد من المهارات المتقدمه في اني كيفيه انشاء (S-Curve) و اظهاره داخل Power BI و كيفيه استخدام خاصيه Financial Period  داهل البريمافيرا و عمل التحديد و تخزينها حتي نستطيع  اخراج ال Trend Analysis  للمشروع و التقسيمات المختلفه .

كما سنتناول معادلات متقدمه ال DAX  ستمكننا منا عرض نسم التقدم و التأخير في المشروع و اي الاقسام اكثر تأخيرا , كل هذا بشكل تفاعلي و محدث باستمرار.

1-انشاء ال S-Curve  الاسبوعي و التراكمي للBaseline داخل ال Power BI.

2-  استخدام ال Financial Period  في عمل التحديثات و حفظها.

3- انشاء و تحليل منحني تقدم المشروع EV% الاسبوعي و التراكمي.

4- انشاء ال Date Table و شرح كيفيه ربط الPV%  مع ال EV% .

5- شرح معادلات متقدمه من ال DAX  كفييه استخدامها في عرض المؤشرات المشروع (KPIs) بشكل دقيق.

6- كيفيه استخدام ال Activity Code  لعرض تقدم المشروع بأكثر من طريقه .

7- تحليل Trend Analysis و معرفه نسبه تأخشر المشروع و حجم التأخير لكل منطقه في المشروع .

8- الكورس مبني علي خبره عمليه .

9- دعم مستمر للكورس.

————–

الكورس مبني علي خبره عمليه في اظهار تقدم المشروع لاحد اكبر البرامج و المشاريع و رفع التقارير للاداره العليا حتي يتمكنوا من اتخاذ قرارت مهمه تتحكم في سير المشروع