02- Easiest way to Create PBI and Excel Dashboards from Primavera. setup and cleaning Data.

[@motazmsa5524]

تسلم يا باشمهندس.. مجهودك مقدر جدا.. اشكرك على نشر هذه المادة العلمية المهمة والقيمة

[@osama.hassanin]

انا في مرحلة نقل لشغل جديد وان شاء الله قريبا هارجع بقوة🤗

[@abduallahalwadey3930]

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

[@mkd.2023]

Very very very ...good work, this is what i was realy looking for

[@ahmedsaeed6311]

من زمان نفسي أتعلم كيف أعمل داشبورت إحترافي في الباور بي أي والاكسل شكرا لك مهندس منتظرين بقية السلسلة.

[@osama.hassanin]

احنا لسه بنقول ياهادي

[@mohialaa6431]

بجد شغل عظيم جدا وكمل حضرتك اكتر وكنت عاوز ان حضرتك تشرح في ال primavera ازاي بطبق الprogress عليه عشان فعلا مفيش حد وصل وشرحها كويس وبشكر حضرتك جدا

[@osama.hassanin]

شكرا لكلامك الجميل،،، انا بس في مرحلة بانقل من شغل لشغل جديد وان شاء الله هارجع قريب وبقوة🤗

[@ming3020]

Amazing eng osama keep going, i turn notifications on to be update with new videos

[@7mbolon_pande73]

Good Idea Sir, Thank you so much

[@abdulwahedissa.8175]

Excellent Great work simple and Clear I wish to do PV and EV Cum and interval

[@osama.hassanin]

EV in the second part of the series PV you can do it like EV

[@linhhuynhnhat5915]

Your video really awesome. Thank so much

[@mohialaa6431]

ومضوع ال cost كله في الprimavera وكمان الresources ال graphs بنطلعها ازاي والتعامل معاها عشان ال basics سهل انما الadvance primavera هو اللي محتاجينوا

[@osama.hassanin]

This is easy way to do reasonable reports. But for advanced, we should connect to XER or the database of standalone or EPPM. You'll find sample in my first video. I'm using them in my work. May be in the future I can make videos, but it depends on my time and the interaction with my videos which is discouraging until now.

[@razalpa1741]

Hi sir When i change data type of startdate into date formate . Its showing error. Could you please reply

[@osama.hassanin]

I think the solution is, change the Start date to Date Time Foramt, then in the next step change it to date format.

[@tariqalanazi1589]

الله يعطيك الصحة والعافية ، مشكور على الجهد طيب

[@husseinseraj6563]

مجهود محترم وملعومات قيمة جدا جزاك الله خيرا عندي مشكلة صغيرة مش عارف حلها لو حضرتك ممكن تساعدني لما بغير كل اعمدة التواريخ من transform لdate data type بيظهرلي error في عامود remaining early start ومش عارف اعالجه ابدا( العامود الوحيد اللي في اعمدة التواريخ قبل التحويل بيكون على شمال العنوان ABC و الباقي ABC123) وبتطلع رسالة data format error we couldn’t parse the input provided as a date value 10:50

[@osama.hassanin]

حول العمود لdate time وبعدين الخطوة اللي بعدها date لو لسه المشكلة ابعتلي الملف علشان اشوفه

[@nazirahmad4712]

MashaAllah very good

[@ahmedabdelsalam7947]

لو سمحت هو ايه الفرق بين Bl Total Cost و Planned Cost لكل نشاط

[@osama.hassanin]

Total cost هوا اجمالي الاعمال للمشروع Planned cost هوا قيمة الاعمال المخططة تنفيذها عند data date Earned value قيمة الاعمال التي تم تنفيذها عند data date

[@ahmedabdelsalam7947]

@@osama.hassanin طيب ليه مش بندخل معاهم مثلا ال Actual Cost

[@ahmedabdelsalam7947]

@@osama.hassanin ياعني مش المفروض Earned Value : قيمه الاعمال الاتنفذت علي الحقيقه بسعر الجدول الزمني Planned Cost : دي قيمه الاعمال المفروض اكون نفذتها علي حسب الجدول الزمني لو كنت ماشي عليه Bl Total Cost : دي قيمه الاعمال الكليه لو انا الاسعار او الكوست عندي ماشيه علي حسب البلان Actual Cost : قيمه الحقيقه الانا دفعتها في الاعمال الاتنفذت كده انا فاهم صح ولا ايه ؟

[@osama.hassanin]

الcost loading للبرنامج بيستخدم لتقييم الاعمال فقط. فال actual cost مش المفروض يتحمل على البرنامج لان الموضوع صعب جدا ودا بيبقى مع ال cost control.

[@osama.hassanin]

موضوع الcost دي نسبة للcost loading اللي هيا تحميل قيمة عقد المشروع على انشطة البرنامج الزمني من وجهة نظر المقاول في التعامل مع الملك المالك مالوش دعوة بالcost وهيا بتتقال cost مجازا فال total cost بتبقى الcontract value. Earned value لما تعمل ابديت للبرنامج،،، قيمة الاعمال المنفذة على البرنامج الزمني Planned value قيمة الاعمال المفروض تنفيذها عند تاريخ الابديت Actual cost دا لمقارنة التكاليف الحقيقية،،، ودي شغالانة الcost control لانها خاصة بالتكاليف الخاصة بالمقاول

[@yamin207eb]

Thank You, Engineer

[@AtifMjd]

Sir, I'm facing problem while loading the Pivot table, where a message is prompted that "Data source is not valid" kindly let me know how to cater it? Thanking You

[@osama.hassanin]

I don't get the problem. Give me more details about which part and what you did before this step

[@muhammadsarkar4778]

Salam. during the data cleaning process. My remaining early start and remaining early finish is showing null after converting to date from the transform. Do you have any idea, what to do?

[@osama.hassanin]

send me that file.

[@muhammadsarkar4778]

@@osama.hassanin Thank you so much. I have resolved this issue. To solve this issue , 1st I converted all the dates to number. then it was working well

[@fadiwarth875]

Thank you, it's really useful

[@salimmdslml065]

Sir, how to add a filter for the different data dates ?

[@osama.hassanin]

What you mean by different data dates? The project has one data date. If you want to have the previous reports?

[@salimmdslml065]

@@osama.hassanin yes sir, I want to see the previous Data dates progress.

[@osama.hassanin]

In this case you should have the multiple exported files in one folder and identify each data exported from each file by data date or you can easily identify the data date in the file name which can be extracted. It's not easy task to discuss in this chat. I can do video about the idea. But keep in mind your database will be huge and slow. My suggestion to keep last report and data of each month. This data can be used also of trends. After completing the series, I'll do it ISA👌

[@osama.hassanin]

But be ready for some advanced Power Query

[@salimmdslml065]

@@osama.hassanin Thank you sir for the advise and suggestion. much appreciated. Waiting for the video.

[@tariqalanazi1589]

Mr. Osama, I believe that there is something wrong p6 file, When I assign the baseline on project, it is given another year Thank

[@osama.hassanin]

What you mean by another year Send me the details and snapshot and let me study it and reload the files if required [e-mail]

[@bilalmakki2323]

Sir can u make one more video to explain how to add progress to each WBS level

[@osama.hassanin]

Next video ISA

[@bilalmakki2323]

@@osama.hassanin waiting sir

[@osama.hassanin]

You've the videos 3.4 and 3.5

[@asfarali225]

Great lecture sir, but i am facing an issue in pivot table fields, my base_start_date is not changing to min_base_start_date, just showing number. I tried to follow you but not working

[@osama.hassanin]

Did you changed the type of the field to data before using min

[@asfarali225]

@@osama.hassanin Yes i changed all dates fields/columns to Date type

[@osama.hassanin]

Send me your exported xlsx file from primavera, or your pbix

[@asfarali225]

@@osama.hassanin Kindly tell me your gmail

[@asfarali225]

@@osama.hassanin and one more request sir, please make complete tutorial on primavera planning, schedule and monitoring, after that monitoring tutorial on P6 to Power BI.

[@fadiwarth875]

Dear Mr. Osama , If you can please update the link files. Thank you

[@osama.hassanin]

I'll do But you'll find almost the same links in the next videos🌷

[@tariqalanazi1589]

before assign the baseline, BL project Start was 01 Jan 2021 after assign the baseline, BL project Start is 01 Jan 2022 thanks

[@osama.hassanin]

I think you should recalculate the baseline before assigning. Anyway the method I'm using until now is applicable for any primavera project with cost loading. The difference will be in the next videos when dealing with WBS.

[@osama.hassanin]

you can re-download the attachment as I fixed the dates in the Baseline XER

[@tariqalanazi1589]

@@osama.hassanin will done

[@gala_fan_1905]

great video. thanks Osama

[@jitu251105]

Thanks 👍👍