Advanced Power Query Tutorial | Complete End-To-End CASE STUDY | Practical guide with Dataset

[@UduakEtukudo-x9x]

just stumbled on this video from Leila Gharani's KZbin page, and I'm freaking BLOWN AWAY!!! So much useful info on Power Query, I feel like I just gained superpowers, lol. An ardent follower of your page henceforth!

[@analyticalguy]

@@UduakEtukudo-x9x this is the kindest comment, thank you so much 🙏

[@fermion4945]

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 ❤

[@analyticalguy]

Thanks fermion, glad you liked it. :)

[@satishvishwakarma8273]

Great learning experience thankyou ♥️

[@analyticalguy]

@@satishvishwakarma8273 you’re welcome 🙏

[@ohdjrp4]

Thank you! This is very good

[@analyticalguy]

I’m glad you liked it, Orlando 👍

[@shreya6115]

Best watched more than 10 videos of power query- I can say this is the most helpful video

[@analyticalguy]

I’m glad this video helped 🙏👍 let me know if you need clarification on any other topic…

[@kristennaa]

True 100%

[@analyticalguy]

@@kristennaa Thanks for your support.

[@taizoondean689]

Thanks for sharing God bless you

[@analyticalguy]

@@taizoondean689 I’m glad it was helpful to you.

[@tarlankazimlii626]

This is completely best video that i have watched till now.

[@analyticalguy]

Thanks for the appreciation mate!

[@ajityadav-db7qq]

It's an outstanding explanation, primarily when you teach us how we will do it in Excel and then the Power Query method. Awesome.

[@analyticalguy]

Thank you Ajit 🙏

[@philym2519]

Great tutorial. Teaching using case studies is so much more informative - thank you so much.

[@analyticalguy]

I’m glad you found this video informative. 🙌

[@elvischinedu5543]

Am learning a lot from u

[@analyticalguy]

@@elvischinedu5543 that’s great, I’m happy this video was helpful. What else would you like to learn?

[@rkhan8375]

Best explanation how to clean the data, wonderful.

[@analyticalguy]

I am glad it was useful to you. Thank you 🙏

[@DRIVETHEDATA3]

Thanks, i have been updated with some points, pls make a video for "how to resolve circular reference errors while merging tables in power query?

[@alexrosen8762]

Amazing tutorial. I learned a lot! Thank you 🙏

[@analyticalguy]

@@alexrosen8762 I’m glad it was helpful, Alex 👍

[@jayminsuthar6124]

I admit to subscribing to these types of underrated content. Thanks!❤

[@analyticalguy]

@@jayminsuthar6124 thank you Jay 🙏

[@CzechCzar]

such a useful video. thank you so much for providing a thorough and intuitive introduction to power query.

[@analyticalguy]

You’re welcome. czech

[@samratdas735]

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.

[@analyticalguy]

I’m glad you liked it 🙌

[@govindc682]

Great content 👍

[@analyticalguy]

Thanks Govind for your kind words 🙏

[@tariqhussain1497]

Good Noon, nice work and nice way to explain, and got much knowledge in the 5 cases...

[@analyticalguy]

Glad you liked it

[@nazlcelikbilek1360]

Very helpful. Thank you 🙌

[@analyticalguy]

@@nazlcelikbilek1360 I’m glad it was helpful :)

[@magdahassib694]

Very wonderful, thank you so much

[@analyticalguy]

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?

[@anjalikesarwani4970]

Thank you so much for this video. Its very helpful.

[@analyticalguy]

You're welcome Anjali. :)

[@Sanj20101]

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 🤝

[@analyticalguy]

Thanks Sanju, I’m glad it helped you 🙏

[@fha4908]

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.🥇🏆

[@analyticalguy]

@@fha4908 I’m glad it was helpful. 🙏

[@kebincui]

Great tutorial 👍

[@analyticalguy]

Thank you Kevin 🙏

[@manojchavan3606]

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.

[@analyticalguy]

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.

[@manojchavan8688]

Sir waiting for your more case studies on power BI @@analyticalguy

[@analyticalguy]

@@manojchavan8688 Soon I will be uploading more.

[@analyticalguy]

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. 🙏🙏🙏🙏

[@surbhirautaray6872]

The dataset link are not open. plz paste correct link

[@khalidmajeed2886]

great sir

[@analyticalguy]

You’re welcome Khalid.

[@nsanch0181]

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.

[@analyticalguy]

@@nsanch0181 I’m glad it was helpful 🙏

[@analyticalguy]

@@nsanch0181 I’m glad the video was helpful 🙏

[@perfectionist6624]

Thank you sir

[@analyticalguy]

you're welcome :)

[@afrozkhan2878]

Fantastic!! What is your name Sir?

[@sangtrinh7371]

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)

[@qasimjan5258]

Ammmazing Sir. Can I have the slides for this and previous power query video, please.

[@analyticalguy]

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.

[@qasimjan5258]

Sir I have downloaded the dataset but I am making collection of all the scenarios so I can refer it later on.

[@analyticalguy]

@@qasimjan5258 Qasim, pls mail me on [e-mail] I’ll share the ppt on your email id. 👍

[@analyticalguy]

Qasim, Hope you have received the file.

[@qasimjan5258]

@@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.

[@bismashaikh2215]

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

[@analyticalguy]

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.

[@analyticalguy]

You can mail me at [e-mail]