سلام عليكم يا بشمهندس انا لما بنفذ علي مشرع حقيقي واجي عند خطوه split column لل wbs id في بعض من wbs مش بيظهر لما بخفي null زي مثلا Construction او Engineering وعشان اظهرهم لازم احط نشاط تحت ال construction علي طول 5:21 حلها ايه لان كده مش هعرف اعمل wbs علي power bi
@jaberfarhat28782 күн бұрын
Your explanation is on another level. Please keep this regular. Good content is really hard to find nowadays.
@jaberfarhat28782 күн бұрын
Your content is really really useful. Totally can relate with real Project scenario. Keep up the good work.
@mohammedalshamli767112 күн бұрын
ما شاء الله ، تبارك الرحمن 🌿 أنا جدًا منبهر بشمولية وكم المعلومات الموجود في dashboard. 👏🏻👏🏻 أريد أعرف هل ممكن مشاركة هذا العمل؟ أو تقدموا كورسات في Power BI ؟
@yjamous13 күн бұрын
Very good report. Can you please make a video explaining how to establish the connection between Power BI and Aconex?
@theanhnguyen194414 күн бұрын
It is easy to understand. I am waiting for your next guide. Thank Osama Hassanin. (Power BI beginner comes from Vietnam)
@osama.hassanin10 күн бұрын
This series is up to 03.7, watch next videos 🌹🌹🌹
@mrefai8920 күн бұрын
When i did the measure in power bi to calculate the Performance % and Schedule %, the output does not match the values in P6... how can i solve this?
@osama.hassanin19 күн бұрын
It should match because our calculation of these PCT is based on exported values. Assuming that you're not applying any filter in primavera, May be something wrong in the measure. Share with me the measure text to review it.
@user-so4rw7dk1x21 күн бұрын
شكرا لحضرتك ومجهودك الرائع م.اسامة استاذنكاخر pbi file مش موجود مع الداتا
@osama.hassanin20 күн бұрын
الافيد يتعمله بنفسك هتستفيد اكتر
@claudiesoondar357723 күн бұрын
Sir I've look at all your videos and it is brilliant. I will now attempt to create my own with my project. Thank you so much💯
@claudiesoondar357726 күн бұрын
I would like to join your classes as well↗
@osama.hassanin25 күн бұрын
Sorry, I've no time to do training🌹
@claudiesoondar357726 күн бұрын
Absolutely great Dashboard
@ramikashef26 күн бұрын
ماشاء الله Excellent
@muhammadsarkar477827 күн бұрын
Hi Brother, Assalamu Alaikum. To update the power BI report with new excel spread sheet, Do I need to do any change in the new exported excel file from Primavera? I am using activity code instead of WBS/Phase table you have done, so it is showing code error. like actv_code_work_phase_5666_id error. What should I do? This code is changing in every update.
@osama.hassanin25 күн бұрын
Hi, this files for training purpose only, not a template. I'm using WBS not activity codes. Try to learn and you can do activity codes method by yourself
@muhammadsarkar477825 күн бұрын
@@osama.hassanin Thank you so much for your reply. Your video are very helpful. May Allah bless you with good health and serenity here and hereafter
@elcinkobyaimanci821Ай бұрын
Thank you very much sir. It is very informative.
@cfelts922Ай бұрын
I don not understand the reason needed for adding a new .xer path at the end. You transform data (edit Parameters) @ 12:45 in the video and it updates the count of task from 47 to 2449. Why do you need to do this if your reading the latest .xer file? I would always want it to read the latest .xer file in a folder and not an old file. However, mine is also giving me a count that is much less than my actual .xer has in it. Is there a way to make this accurate using the latest .xer?
@osama.hassaninАй бұрын
I'm adding new xer to make it clear that you can use any xer in this report, not the same project only. To read the latest xer in folder. In power query, before read the xer read the folder and sort by file date desc then select the first record, then read the xer. For giving you less count, it should give you accurate count. I cannot predict what's wrong.🌹🌹🌹
@irfanahmed7231Ай бұрын
Hi sir could you make a complete video of this dashboard on how to insert data and how to connect .
@monaalee3515Ай бұрын
How to Join your power bi classes?
@ahmed.elnebishiАй бұрын
م اسامه .. ما الفائدة من اضافة عمود index ?
@osama.hassaninАй бұрын
الاندكس بيخليني ارتب wbs بترتيب البريمافيرا.... لما تستخدم الslicers الWBS هتترتب ابجدي يعني هتلاقي مثلا construction قبل Engineering. لكن بترتيب الاندكس اقدر ارتب wbs على اساس الاندكس فالترتيب ييجي منطقي زي اللي موجود في البريمافيرا. هتوضح معاك في اعداد الريبورت🌹
@ahmed.elnebishiАй бұрын
@@osama.hassanin ما شاء الله عليك استاذنا و معملنا الله يجزيك كل خير.. سؤال مهندسنا الحين انا عندي مشروع بطبق عليه محمل عليه جميع ال activity codes لان طريقة ال wbs ما ظبطت و صعب اضيف dummy لكل wbs فاضي .. فهل انا محتاج اسوي شئ يخص ال activity codes مع العلم انها محملة باعمدة في جدول الانشطه
@ahmed.elnebishiАй бұрын
م اسامه الرائع ممكن تعمللنا فيديو يشرح طريقة ال activity codes
@ahmed.elnebishiАй бұрын
شرح ال planned value مفهوم الى حد ما يا مهندس اسامه . شرح ال earned value و خصوصا ال dax formula كتير معقد و يحتاج المزيد من التوضيح اذا تكرمتم بفيديو اخر لتوضيح توزيع ال earned value بصورة اكثر وضوح وتفصيل ..
@osama.hassaninАй бұрын
هيا الفيديوهات دي المفروض انها ادفانسيد حاول تمشي وراها وهتفحمها ان نزلت في الشرح لمستوى هيخلي اكتر من كده الفيديو هيكون ساعات كتير
@ahmed.elnebishiАй бұрын
م اسامه الرائع و المتميز على هذا الشرح المتقدم .. سؤال هل ممكن استخدم هذا التقرير لاي مشروع عن طريق تغيير ملف الريسورس و لا هذا التقرير خاص بهذا المشروع فقط ؟؟ كل الشكر
@osama.hassaninАй бұрын
شكرا ياباشا طبعا ممكن تستخدامه لاي مشروع بشرط انه يكون طبعا cost loading🌹🌹🌹
@ahmed.elnebishiАй бұрын
@@osama.hassanin طبعا مع الالتزام با layout المستخدم في اول فيديو و كذلك اسماء الاعمدة .. هل في شى اخر يجب الالتزام به
@ahmadhabbash275Ай бұрын
thank you for your valuable information Mr Osama can you please share the Power BI file Please with the Data shared
@osama.hassaninАй бұрын
For Data or the exported excel file you'll find in the description or you can use any exported excel file from p6 project cost loading. For PBI file, better to do it by yourself, to learn.🌹🌹
@amrhassan87062 ай бұрын
سلام عليكم لو امكن حضرتك تشرحلنا طريقة عمل الداش بورد العبقرى ده ولحضرتك جزيل الشكر
@osama.hassanin2 ай бұрын
وعليكم السلام،،، هتلاقي فيديوهات كتير في القناة فيها شرح لمعظم الأجزاء
@usmanchauhdary2 ай бұрын
Thank you Engineer Osama. Your videos are providing a great value for Planners indeed. We are waiting for the next videos.
@samuealwoldesemayat2 ай бұрын
Thank you very much, I waiting the next topics
@muhammadyusran45442 ай бұрын
Amazing Video, Still waiting FOr Next Amazing Learning From Mr. Osama
@IhabLotfi2 ай бұрын
Very informative coaching. Many thanks my dear brother
@osama.hassanin2 ай бұрын
واحشني أوي يا إيهاب 🌹🌹🌹🌹🌹🌹🌹🌹🌹
@adeniyifiyinfoluwa27722 ай бұрын
Thanks very much
@mohamedfaslan43163 ай бұрын
Very clear explanation videos Thank you very much sir
@osama.hassanin2 ай бұрын
Keep watching 🌹
@adeniyifiyinfoluwa27723 ай бұрын
Sir, I am impressed by all that you have put into these videos, i am a data analyst, i would want to ask if possible to get the dataset to learn along as i watch. Thanks
@osama.hassanin2 ай бұрын
You'll find the xer, exported files and pbi with the next videos, the series contains many videos. 🌹
@adeniyifiyinfoluwa27722 ай бұрын
Thanks very much
@CristianaCosta-gi9is3 ай бұрын
Hi, thanks for this tutorial. I'm following the step by step, however at the end of the video, 6:12 there more tables in your model. How to create the table Measure?
@osama.hassanin3 ай бұрын
This series is up to 03.7 continue and you'll find them🌹
@CristianaCosta-gi9is3 ай бұрын
@@osama.hassanin Alright, thanks.
@jamescullis3 ай бұрын
Hi Osama, which Gantt chart visual are you using in this report?
@osama.hassanin3 ай бұрын
Open power bi store, search for gantt chart, you'll find it (free).
@SuryanarayananRevathi3 ай бұрын
Hi Osama , there should be atleast one activity in the WBS then only power bi will Consider that WBS ? in my case i have main WBS under Sub WBS only Sub WBS have activities . it is not considering my main WBS . How to overcome this
@osama.hassanin3 ай бұрын
Yes in this method (easy one) you should have activity under each level of WBS. But you can add Start Milestone (as example) under it. also we can solve this problem by using: - Reading WBS from XER so you can hav the full hierarchy (I'll discuss this in my videos later). - Using User Defined codes. so, we can create -as Example- 3 Codes, one for Discpline, second for Work, and third for Floors. and Export these data in the excel file and use it for the hierarch 🌹🌹🌹
@SuryanarayananRevathi3 ай бұрын
@@osama.hassanin Thank you very much for the response. Waiting for u r other videos.
@kambizradman73783 ай бұрын
lovely, cheers Osman
@muhammadsarkar47783 ай бұрын
Why the button name is work even though the cost is by phase? or vice-verse
@osama.hassanin3 ай бұрын
can you elaborate in your question?
@issambenchaita3763 ай бұрын
Great job بارك فيك وجعله في ميزان الحسنات
@ajumelton3 ай бұрын
you are a good elaborator ... much appreciated help!
@AnthonyFabito-ec4dh3 ай бұрын
how much the training?
@osama.hassanin3 ай бұрын
Sorry, I've no time traning, but you'll find alot of usefull videos in the channel
@DesertObserver4914 ай бұрын
Excellent dashboard. Very thorough yet not overcrowded.
@DesertObserver4914 ай бұрын
This is a very useful video. Detailed yet simplified. Thank you so much, sir.
@samser11504 ай бұрын
Thanks Eng. Osama, would be great if you address the solution to the discrepancy noted in your last slide of this video. Thanks in advance.
@osama.hassanin4 ай бұрын
Remined me because I always foreget the video content after finishing it.
@mohammedabdulmoiz50245 ай бұрын
Dear sir, In blank query and file content reading I am getting error message as below. Dataaformat.Error:The supplied file path must be a valid absolute path. What would be solution for this? Kindly help
@osama.hassanin5 ай бұрын
Check if the path in the parameter query contains high quotations in the begin and end, remove them
@mohammedabdulmoiz50245 ай бұрын
It's resolved thanks a lot for your guidance. You have the deepest knowledge of excel power bi and Primavera p6
@osama.hassanin5 ай бұрын
@@mohammedabdulmoiz5024 old man experience 😃🌹
@mohammedabdulmoiz50245 ай бұрын
@@osama.hassanin Many of us can be benefited from your experience. Kindly keep posting as per your convenience.
@RafaelArneiro5 ай бұрын
Many thanks for the video, great tutorial!
@nazirahmad47125 ай бұрын
Excellent
@nazirahmad47125 ай бұрын
Ma sha Allah Excellent
@GABSIAN18385 ай бұрын
Hi Mr Osama thank you for sharing, i have a question if i want to compare between BL & up how can i do?
@osama.hassanin5 ай бұрын
In the next vidoes we'll discuss manythings. Anyway, upload the two XERs in the same way. Then create to task table. You can compare these tables by task_code field in power query, excel or power bi.🌹
@GABSIAN18385 ай бұрын
@@osama.hassanin I greatly appreciate your effort to share knowledge.
@user-xs7hq5yl1g5 ай бұрын
Thanks for your Effort Engineer Osama, Really excited for the next tutorial about the in accurate values
@jithinchellappan5 ай бұрын
Thank You So Much Sir.How i can contact your for P6 BI Training
@ahmadhabbash275Ай бұрын
@@osama.hassanin can you suggest Valuable course from others ?