Before watching this video,using power query was a real nightmare for me 😢.But I got enough confidence to use it after watching your videos .Learning with case studies is the best approach to master power query .I highly appreciate your work .Thank you so much for your valuable content ❤
This video will help you understand the practical aspect of POWER QUERY… watch till the end to get all the insights. Dataset shared for your practice. 🙏🙏🙏🙏
Very kool tutorial. All the Power Query tutorials videos I've watched deal with getting tables or files from a folder and combining and transforming. Your tutorial goes way beyond that with the practical cases. They provide useful templates for dealing with similar cases in the future. Thanks so much for such a comprehensive tutorial. I note that you also have a tutorial on PBI. I will watch that later.🥇🏆
This is my solution for case study 2, all is done in Power Query. I will put my sudo code here and will use adding custom columns for better understanding. I know there will be much better solution. 1. Using text.split to turn text of all employees in each project into list of employees in each project 2. Using list.count to count employee in each project. 3. Using list.repeat with column in step 2 as a second parameter, first parameter will be project total cost / column in step 2 => result is a list of the Each employee project cost. 4. Using record.fromlist with inputs from columns just created(step 3 and step 1) 5. Using record.totable to turn column in step 4 into table 6. Using table.expandtablecolumn on result on step 5. 7. Using table.group on columns from step 6( employee name and with function sum on value each project)
Thank you for the great video on power query. I had some coffee and really enjoyed following along with your lesson. I just subscribed and really look forward to learning with you.
Dear sir, your video is really helpful. Thanks for uploading this. Your knowledge & teaching style is really at different level. Please upload more case studies.
Hi Magda, I am glad you found this video helpful.. Could you please tell me what was the best insight from this video? and would you like to make a video on some other topic?
Hi, I am starting my own business of FMCG product as a manufacturer. I need your help to please make a video where I want to know how much profit margin should I provide to my Distributor and Retailers. As your calculations are best so that video would b help full for me to let them also understand the margins
![[#SHORTS CLIP] ใช้ของของตัวเองไปเลยสิคะ l ซานิเบาได้เบา l One Playground](http://i.ytimg.com/vi/Ea_mTywx2p4/mqdefault.jpg)
I admit to subscribing to these types of underrated content.
Thanks!❤
Before watching this video,using power query was a real nightmare for me 😢.But I got enough confidence to use it after watching your videos .Learning with case studies is the best approach to master power query .I highly appreciate your work .Thank you so much for your valuable content ❤
Thanks fermion, glad you liked it. :)
This video will help you understand the practical aspect of POWER QUERY… watch till the end to get all the insights.
Dataset shared for your practice.
🙏🙏🙏🙏
The dataset link are not open. plz paste correct link
Best watched more than 10 videos of power query- I can say this is the most helpful video
I’m glad this video helped 🙏👍 let me know if you need clarification on any other topic…
True 100%
@@kristennaa Thanks for your support.
It's an outstanding explanation, primarily when you teach us how we will do it in Excel and then the Power Query method. Awesome.
Thank you Ajit 🙏
Very kool tutorial. All the Power Query tutorials videos I've watched deal with getting tables or files from a folder and combining and transforming. Your tutorial goes way beyond that with the practical cases. They provide useful templates for dealing with similar cases in the future. Thanks so much for such a comprehensive tutorial. I note that you also have a tutorial on PBI. I will watch that later.🥇🏆
Thanks for this video, it really helped me in my real time project where I was struggling to unpivot and transpose 🙂
Great effort bro, keep it up 🤝
Thanks Sanju, I’m glad it helped you 🙏
Great tutorial. Teaching using case studies is so much more informative - thank you so much.
I’m glad you found this video informative. 🙌
This is completely best video that i have watched till now.
Thanks for the appreciation mate!
This is my solution for case study 2, all is done in Power Query. I will put my sudo code here and will use adding custom columns for better understanding. I know there will be much better solution.
1. Using text.split to turn text of all employees in each project into list of employees in each project
2. Using list.count to count employee in each project.
3. Using list.repeat with column in step 2 as a second parameter, first parameter will be project total cost / column in step 2 => result is a list of the
Each employee project cost.
4. Using record.fromlist with inputs from columns just created(step 3 and step 1)
5. Using record.totable to turn column in step 4 into table
6. Using table.expandtablecolumn on result on step 5.
7. Using table.group on columns from step 6( employee name and with function sum on value each project)
such a useful video. thank you so much for providing a thorough and intuitive introduction to power query.
You’re welcome. czech
Best explanation how to clean the data, wonderful.
I am glad it was useful to you. Thank you 🙏
You are just awesome to make such kind of real situation in Power BI. I am unable to click like button due to not visible. But excellent thought.
I’m glad you liked it 🙌
Thank you for the great video on power query. I had some coffee and really enjoyed following along with your lesson. I just subscribed and really look forward to learning with you.
Thank you sir
you're welcome :)
Thank you so much for this video. Its very helpful.
You're welcome Anjali. :)
Very helpful. Thank you 🙌
@@nazlcelikbilek1360 I’m glad it was helpful :)
Good Noon, nice work and nice way to explain, and got much knowledge in the 5 cases...
Glad you liked it
Dear sir, your video is really helpful. Thanks for uploading this. Your knowledge & teaching style is really at different level. Please upload more case studies.
Thanks Manoj for your kind words. I’ll be uploading more case studies related to Power Query, Power BI, SQL, Python etc in coming days.
Sir waiting for your more case studies on power BI @@analyticalguy
@@manojchavan8688 Soon I will be uploading more.
Very wonderful, thank you so much
Hi Magda, I am glad you found this video helpful.. Could you please tell me what was the best insight from this video? and would you like to make a video on some other topic?
Great content 👍
Thanks Govind for your kind words 🙏
Great tutorial 👍
Thank you Kevin 🙏
great sir
You’re welcome Khalid.
Hi, I am starting my own business of FMCG product as a manufacturer. I need your help to please make a video where I want to know how much profit margin should I provide to my Distributor and Retailers. As your calculations are best so that video would b help full for me to let them also understand the margins
Hi Bisma, You can share the product description, place of business, pricing that you have set. Once you share the details, I can suggest you.
You can mail me at analyticalguys@gmail.com
Ammmazing Sir. Can I have the slides for this and previous power query video, please.
Hi Qasim, I have added the dataset on which I have done all the steps, it’s better to download the dataset and practice yourself for better results.
Sir I have downloaded the dataset but I am making collection of all the scenarios so I can refer it later on.
@@qasimjan5258 Qasim, pls mail me on analyticalguys@gmail.com
I’ll share the ppt on your email id. 👍
Qasim, Hope you have received the file.
@@analyticalguy yes Sir thank you very much. Please also share the future power query files with me Sir. Once again thank you very much Sir.
Thank you! This is very good
I’m glad you liked it, Orlando 👍