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
4 ай бұрын
Thanks fermion, glad you liked it. :)
@jayminsuthar6124
Ай бұрын
I admit to subscribing to these types of underrated content. Thanks!❤
@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 🙏
@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
8 ай бұрын
The dataset link are not open. plz paste correct link
@fha4908
8 ай бұрын
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.🥇🏆
@philym2519
7 ай бұрын
Great tutorial. Teaching using case studies is so much more informative - thank you so much.
@analyticalguy
7 ай бұрын
I’m glad you found this video informative. 🙌
@tarlankazimlii626
7 ай бұрын
This is completely best video that i have watched till now.
@analyticalguy
7 ай бұрын
Thanks for the appreciation mate!
@nsanch0181
11 ай бұрын
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.
@samratdas735
8 ай бұрын
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
8 ай бұрын
I’m glad you liked it 🙌
@CzechCzar
Жыл бұрын
such a useful video. thank you so much for providing a thorough and intuitive introduction to power query.
@analyticalguy
Жыл бұрын
You’re welcome. czech
@rkhan8375
8 ай бұрын
Best explanation how to clean the data, wonderful.
@analyticalguy
8 ай бұрын
I am glad it was useful to you. Thank you 🙏
@manojchavan3606
11 ай бұрын
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
11 ай бұрын
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
8 ай бұрын
Sir waiting for your more case studies on power BI @@analyticalguy
@analyticalguy
8 ай бұрын
@@manojchavan8688 Soon I will be uploading more.
@tariqhussain1497
6 ай бұрын
Good Noon, nice work and nice way to explain, and got much knowledge in the 5 cases...
@analyticalguy
4 ай бұрын
Glad you liked it
@sangtrinh7371
7 күн бұрын
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)
@nazlcelikbilek1360
3 ай бұрын
Very helpful. Thank you 🙌
@analyticalguy
3 ай бұрын
@@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. :)
@govindc682
Жыл бұрын
Great content 👍
@analyticalguy
Жыл бұрын
Thanks Govind for your kind words 🙏
@perfectionist6624
4 ай бұрын
Thank you sir
@analyticalguy
4 ай бұрын
you're welcome :)
@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 analyticalguys@gmail.com 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.
Пікірлер: 60