🙂🙂🙂 Big thanks and regards to creator of such simple and yet helpful presentation
@Planicontrol2 жыл бұрын
You most welcome @51Sable! Many thanks for your kind words! dont forget to subscribe! all the best!
@santoshkumar-ek5ks8 ай бұрын
It's completely awesome You solved all my query ❤ I'll see all your video and I'm pretty sure from zero to be a hero in bi
@Planicontrol7 ай бұрын
You the man, Santos! thank you so much for your good vibes!
@darronbailey6743 жыл бұрын
That was the best youtube tutorial that I have ever experienced. Great job. Of course I have subscribed. Keep them coming!
@Planicontrol3 жыл бұрын
We love your good vibes Darron! We keep it up!
@strikerbabu90693 жыл бұрын
loved it will surely use this in my work cant wait for more to come
@Planicontrol3 жыл бұрын
More will come! that's for sure! Please subscribe!
@yavuzyldrm99812 жыл бұрын
fruitful, easy to understand and fluent. First video I watched in this channel but I didnt expected it !! Thanks a lot bro..
@Planicontrol2 жыл бұрын
Great to hear! Really appreciate your message!
@Howtoexcel14 Жыл бұрын
Wowwwww 🥰 happy for this powerful tutorial. But I missed out on the unpivot others. Though I have to rewatch severally. Thank you so much 🙏
@Planicontrol Жыл бұрын
Thank you @christianaja8064 !! indeed... the unpivot table feature is the 8th wonder of business intelligence! haha
@Howtoexcel14 Жыл бұрын
@@Planicontrol absolutely! I see that. Initially I thought that it's the transpose in excel but unpivot table is way above that.
@janssensmichiel3 жыл бұрын
Great stuff, love your enthusiasm!
@Planicontrol3 жыл бұрын
Many thanks Michiel! We love to have visitors on the channel who get value from what we do!
@luisdorta97802 жыл бұрын
Thank You!
@Planicontrol2 жыл бұрын
You are welcome Luis! pls subscribe if you like our videos!
@londonengland23092 жыл бұрын
Thank you!
@Planicontrol2 жыл бұрын
You are welcome London! If you liked our videos pls subscribe!
@jeanwemersonanalistaplanej58202 жыл бұрын
Very nice, man!!
@Planicontrol2 жыл бұрын
Appreciate your comment JEAN!
@nazirahmad47122 жыл бұрын
Great video . Teach us power bi with P6, sir.
@Planicontrol2 жыл бұрын
Hi Nazir, many thanks! We have plenty of Power BI courses (in Spanish) in our website: www.planicontrol.com.pe In addition, we partnered up with PCA to deliver a training in english, you can check this up under this link: members.projectcontroltraining.com/a/2147491015/FQYXkKQH
@ravikiran89833 жыл бұрын
Wow, this is soo amazing! Thanks for the Tutorial
@Planicontrol3 жыл бұрын
Thanks Ravi! we are really happy you find it useful! please share it with your peers!
@tahirhanif96693 жыл бұрын
Excellent video thanks Muey bein 👍 Muchas gracias
@Planicontrol3 жыл бұрын
Gracias a ti! Like your spanish Tahir!
@projectcontrols3 жыл бұрын
Congratulations. Great presentation. Couple of questions: 1. How to chart period actúals? 2. How to graph current vs baseline? I hope these are easy questions. Again. Thank you!,
@Planicontrol3 жыл бұрын
Thanks for the feedback, James. Are good questions.. not easy I am afraid. We provide a full training in that specific (in spanish though). But trying to provide at least some valuable hint: You will need to set your actuals tables up (get data) and then you will need to model and link all these tables together (using power pivot). In this quick video you will find the output look of what you are looking: kzbin.info/www/bejne/qJeVeYqLrtSXaq8
@rogeriopsvalle2 жыл бұрын
Could you please share the link. Thanks.
@shahidrazaq27063 жыл бұрын
Very impressive command. Please also demonstrate how to update actual values along with plan values
@Planicontrol3 жыл бұрын
Thanks Shahid! We are getting that request a lot, so that will be our next video.. dont forget to subscribe!
@mohamedabdelfatah54511 ай бұрын
your explanation amazing thanks bro
@Planicontrol11 ай бұрын
Appreciate the good vibes!
@nohandlebarmtb2 жыл бұрын
Muchas gracias Juan Carlos, justamente lo que necesitaba resolver (la parte de Unpivot). Lo tenia que hacer a mano a traves de MS Access y me tomaba mucho tiempo. Saludos desde Alemania
@Planicontrol2 жыл бұрын
Wohooo!! excelente eab! espero nos compartas tus curvas S! saludos hasta alemania!
@hb7197 Жыл бұрын
Thanks man.
@Planicontrol Жыл бұрын
You are welcome H B!!
@rajeshnair8516 Жыл бұрын
Awesome 🎉
@Planicontrol Жыл бұрын
Many thanks for your comment and support @rajeshnair8516
@ak-478214 ай бұрын
amazing presentation. i hope you can a make a project- based tutorial series on primavera p6
@ahmedmohsenzeid62563 жыл бұрын
this is so efficient, thank you! may i ask how to show planned, actual, forecast line curves ??
@Planicontrol3 жыл бұрын
Hi Ahmed! We will try to bring up some more videos on different subjects... however you might be interested in our PowerBI + Primavera P6 applied to Project Controls full training! You can check it up here www.planicontrol.com/curso/power-bi-integracion-primavera-p6-xml-y-xer
@wizoxD3 жыл бұрын
Sería bueno que hagas un vídeo similar en español, te lo agradecería mucho
@Planicontrol3 жыл бұрын
Hola Enzo, en realidad si tenemos el mismo video en espanol. Lo puedes encontar aqui! kzbin.info/www/bejne/rXezhXuho9SIpZI
@issambenchaita376 Жыл бұрын
great
@Planicontrol Жыл бұрын
You are welcome Issam!
@shanedavies9 Жыл бұрын
Great video. Any chance of demonstrating an S curve with Actual and Remaining? thanks
@chukwukaakpati98202 жыл бұрын
Good job. How can someone plot plan and actual progress curve in one graph
@Planicontrol2 жыл бұрын
Hola Akpati, we will release that video very soon!
@djokotriono7787 Жыл бұрын
not enough likes. Thanks!
@Planicontrol Жыл бұрын
You are awesome Djoko! thanks for the good vibes!
@arshidmahmood16993 жыл бұрын
Hi, Thank you so much for this video. Could you please explain how to creat 2 curves on the same graph in power BI. (I mean Baseline and actual curves)
@Planicontrol3 жыл бұрын
Hi Arshid, yes sure we will try a new video to address that soon! Please subscribe so you dont miss it!
@official_davidyte Жыл бұрын
Thanks my brother this is huge.. But pls is it also possible to integrate primavera to power Bi without data extraction???
@Planicontrol Жыл бұрын
Hi Official_David Yte! it is definitely possible using a Primavera P6 SQL connection. we have 2 videos showing how to do this connection. You can check it out here: kzbin.info/www/bejne/fKjCgXx5a7Z9jtk
@wildecorrea64773 жыл бұрын
Awesome class! Thank you for this video, very helpful! I have a challenge proposed. Can you construct a second line (graphic) as a mix, half as ACTUAL activities (until today, automatically) and half as activities REPLANNED for the future. Then, at a result, one can have 2 lines, one with FORECAST (=TARGET, GOAL, PLANNED) and the other one with ACTUAL+REPLANNED data (both at the same line: half ACTUAL + half REPLANNED). Could you do this?
@christopherolivertalag20163 жыл бұрын
I have the same question :). Do you have video for this?
@Planicontrol3 жыл бұрын
@@christopherolivertalag2016 This will be our next video! will publish it by mid September!
@@Planicontrol Great video subscribed to your channel. I am also interested in the same visuals @Wilde Correa has suggested but couldn't find it on your channel.
@lexdelija2138 ай бұрын
@@Planicontrolcan you please share a link for the video with actuals and more than 1 s curve?
@eduardodaher55572 жыл бұрын
Hi! I just bought the Power BI + Primavera P6 Training online, but I didn’t receive the email with the information or access. Please help.
@Planicontrol2 жыл бұрын
Hi Eduardo! Thanks so much! We just replied to your email! You course access credentials are on their way! Thanks for trusting Planicontrol!
@eduardodaher55572 жыл бұрын
@@Planicontrol all good now. Thanks very much!
@rorygrant48246 ай бұрын
@planicontrol Great video well done sir! How do you add the monthly data labels to the x axis? It's currently only showing the month every 6 months. Jan 2013 then Jul 2013. I want to show every individual month
@Planicontrol6 ай бұрын
This is a great question and fortunately an easy fix. On the right hand side panel (fields), find the data field you are applying on the x-axis of your visual (should be in a date format). Right click on this field and select GROUP. A new pop up window will show the settings. Choose to group it by months (interval 1). It will create a new "group" field. Replace this new field on the x-axis and you should get the desired outcome
@osquareo63643 жыл бұрын
I looked at your website, good courses. Are the trainings in English?
@Planicontrol3 жыл бұрын
Hi @Osquare O, for the momento only spanish trainings but we are getting quite a good motion from the english speaker audience so we might offer them in english in 1 month time
@osquareo63643 жыл бұрын
@@Planicontrol Thanks Will check in a month as am interested in the CCP track
@connordaly2882 Жыл бұрын
Do you have any experience making S-curves directly from an XER file? I would love to see a video on this!
@Planicontrol Жыл бұрын
Hi Connor, we do and we have produced SCurves directly from a XER file and from a P6 SQL connection. However, it gets tricky, as Primavera P6 doesnt store the time-phased data in its database (it is generated by P6 using complex algorythms). So what we do is try to mimic this algorythm in Power BI, using the budgeted units and the time frame. We dont have a video for this as it takes quite a long time to reproduce P6 algorythm, so we developed the step-by-step in our training here: members.projectcontroltraining.com/a/2147491015/FQYXkKQH
@rogeriopsvalle2 жыл бұрын
Mr. Good evening. I hope this message finds you well. Do you have by any chance, tips or Works related to criation of S Curve with primavera P6 conected to SQL DB If you could share I would aprecciated. Thanks in advance Regards.
@Planicontrol2 жыл бұрын
Hi Rogerio, we do.. But it takes longer to explain as we need to understand the P6 database schema. For that reason, we only include that level of detail in our training (paid)
@rogeriopsvalle2 жыл бұрын
@@Planicontrol thanks for your answer. Could you please release details regarding The course you pointed out?
@Planicontrol2 жыл бұрын
Hi Rogerio, thanks for your answer. We have two options: Spanish training: www.planicontrol.com/curso/power-bi-integracion-sql-con-primavera-p6-a-la-z English Training: members.projectcontroltraining.com/a/2147491015/FQYXkKQH They differ quite a bit in price. It is worth understanding that our English training is the compilation of all our individual Spanish training. Due to this, English training is a 35-hour course.
@rogeriopsvalle2 жыл бұрын
@@Planicontrol Dear JuanCarlo. I Appreciate your return but at this time I can´t afford such investment. Down here in Brasil exchange rate is 6 x 1. If you have any opening directed to free of charge line please let me know. Thank you very much.
@user-gl7tf9ug7b Жыл бұрын
Hi Jeancarlo, great demonstration, thanks for sharing this "straight to the point" tutorial. Just an open question : Would it be possible to, rather than copy/paste to an Excel, edit a report and make it as the input of the Process? I am used to export that way the Resources Manhours to develop my Excel Graphs. Cheers
@Planicontrol Жыл бұрын
Hi @user-gl7tf9ug7b! many thanks for watching it! Coming to your query... of course you can and I would advise you take that route (create a standard report in P6). Anything we can do to standardise the process is a way to go. Of course, there are also other options. If you check our youtube channel we have other videos in english where we show how you can also connect P6 XER files to BI, P6 XML files to BI and SQL database connection to P6 to report directly on BI.
@adityaduttapmp63943 жыл бұрын
Hi i found this video very helpful, actually i am looking for tutorials on integration of power BI with P6 for project reports in english,so do you have any such courses in english at udemy or somewhere ?
@Planicontrol3 жыл бұрын
Hi Aditya, Many thanks. We are about to release a complete course in English this September. You can read the full detail in this link: members.projectcontroltraining.com/a/2147491015/FQYXkKQH
@marcosengele Жыл бұрын
Hi How to create a S curve straight from P6 database, once powerBI is already connect to the database of course. Thanks
@Planicontrol Жыл бұрын
It is really a good question. once you get the SQL connection in place, the next thing is to learn about the Primavera P6 database schema, so you can learn how to model (connect) the different tables. The schema will tell you how the different tables are connected (by primary and foreign fields) and then you can model them in power BI. This is the link to P6 schema: docs.oracle.com/cd/F25599_01/helpmain.htm?toc.htm?55497.htm