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

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

[@jayminsuthar6124]

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

[@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. :)

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

[@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 🙏

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

[@tarlankazimlii626]

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

[@analyticalguy]

Thanks for the appreciation mate!

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

[@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 🙌

[@nazlcelikbilek1360]

Very helpful. Thank you 🙌

[@analyticalguy]

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

[@rkhan8375]

Best explanation how to clean the data, wonderful.

[@analyticalguy]

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

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

[@CzechCzar]

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

[@analyticalguy]

You’re welcome. czech

[@tariqhussain1497]

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

[@analyticalguy]

Glad you liked it

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

[@perfectionist6624]

Thank you sir

[@analyticalguy]

you're welcome :)

[@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. :)

[@govindc682]

Great content 👍

[@analyticalguy]

Thanks Govind for your kind words 🙏

[@khalidmajeed2886]

great sir

[@analyticalguy]

You’re welcome Khalid.

[@kebincui]

Great tutorial 👍

[@analyticalguy]

Thank you Kevin 🙏

[@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]

[@ohdjrp4]

Thank you! This is very good

[@analyticalguy]

I’m glad you liked it, Orlando 👍