Advanced Power Query Tutorial | 5 Practical Use Cases and Tips for Excel & Power BI Users | M Query

[@serdip]

Brilliant video on advanced Power Query data cleansing techniques! Thanks for sharing your knowledge. For the exercise with student marks and results, I decided to create a custom column and use List.Zip() to pair corresponding [UNIT CODE], [UNIT MARK], and [RESULT] values with the following formula: List.Zip( { Text.Split([UNIT CODES], " "), Text.Split([UNIT MARKS], " "), Text.Split([RESULT], " ") } ) This created a new column of lists, which I expanded into new rows, each of which contained a list of {[UNIT CODE], [UNIT MARK], [RESULT}}. Splitting the lists in that column results in a separate column each for [UNIT CODE], [UNIT MARK], and [RESULT], after renaming the default column names, of course. Thank you kindly.

[@aboalbraa2119]

Thats Greate ,keep posting amazing and valuable contents such this , thanks a lot and keep going we are waiting a new things

[@analyticalguy]

Thanks for the support. 🙏

[@avinashgupta3879]

After a long time, Keep Posting amazing content, waiting for the advanced-level content

[@analyticalguy]

Thanks Avinash.

[@kebincui]

Excellent。Thanks for sharing 👍❤

[@analyticalguy]

Thanks Kebin for your kind words 🙌

[@asdpal2463]

Good to see you after a longtime sir, please make SQL queries + power bi advance project other than sales domain.❤

[@analyticalguy]

Thank you so much, hopefully this time I post videos regularly.

[@koushikmitra99]

Excellent, Keep it up! Hoping to connect soon on topmate...

[@analyticalguy]

Thanks Koushik 🙏

[@santoshkiran5858]

❤❤❤ Brilliant

[@analyticalguy]

Thank you.

[@EmailPublicidade]

excellent tip. and if we want to add a list of columns, using a list of names query, how is it done?

[@PreMathSci]

Thank you very much @analyticalguy for your detailed and insightful videos. I am a beginner in Power Queries, and I have watched and practiced twice using your previous video, which is 55 minutes and 10 seconds long. I found the content very easy to understand. If possible, could you kindly share the practice file related to this video? It would be greatly appreciated and helpful for us. I watched along with the first example, but I had difficulty understanding the formula creation part. I also checked the shared files for practice, but I couldn’t find the exact data used in the video. Thank you once again, and greetings from Sri Lanka!

[@analyticalguy]

I’m glad you liked, did you check the video description? I have added the excel file which has been used in this video.

[@PreMathSci]

@@analyticalguy Atikant Jain, that is useful for the practice. Thank you for the content and resource. Really appreciated.

[@analyticalguy]

@@PreMathSci that’s wonderful 👌

[@shubhamsharma4666]

hey, please make a complete list of SQL from basics to advanced projects. it would be really helpful for us.

[@analyticalguy]

did you check other SQL videos? Also: kzbin.info/www/bejne/l56QmqxogKZki6M

[@rahulamesar5387]

Excellent sir, only voice was low pitch but content was high quality. Thanks

[@analyticalguy]

Oh if that’s the case, I’ll try to improve the voice pitch. Thanks for your support🙌

[@ajityadav-db7qq]

Hi Atikant, Regarding your Power BI Dax and Data Modeling course....Thanks for creating such a great content...this is Gold 🥇 so please complete that remaining part...is there any update regarding the module 7 and 8 . And please provide the Quick Guide (PPT) along with all the Modules, as you did for the Module 1 it will help us to maintain and refer the notes for the same.

[@analyticalguy]

Hi Ajit, thanks for your kind words. There are few changes in how DAX and Power BI will go ahead. If you have seen the updates from Microsoft, I’ll be modifying those content so that it will help everyone even more. The work is in progress. And yes, I’ll share the PPT for each module. 👍

[@GagandeepSingh-vd9hd]

Thanku for making videos❤ please can you make a detailed video how to explain a dashboard in linkedin

[@analyticalguy]

Hi Gagandeep, could you please elaborate. What do you mean by this?

[@GagandeepSingh-vd9hd]

@@analyticalguy I want to say can you make a video how to write dashboard post on linkedin (problem statement , solution)

[@analyticalguy]

@@GagandeepSingh-vd9hd okay, I’ll try but I cannot commit to record a video for that. You may connect 1 on 1 where I can explain you in depth. :)

[@AdityaSingh-rl8is]

Make the dataset publicly available. Ty

[@analyticalguy]

Hi Aditya, it has been made public. You can access now with the same link. :)

[@nandagopalsura]

Hi please make videos on power pivot

[@analyticalguy]

Hi Nandagopal, let me know what all you want me to cover in power pivot. If you have any specific questions.

[@nandagopalsura]

@@analyticalguy power pivot using DAX functions in excel

[@analyticalguy]

@@nandagopalsura That's a good suggestion. I will work on it, and share after my other scheduled videos :)

[@nandagopalsura]

@@analyticalguy thank you so much I'm waiting for it

[@analyticalguy]

@@nandagopalsurasure.

[@Abioladavid01]

Good video but technically, this are basics, not advanced in Power Query. Advanced Power Query Cleaning and Transformation involves writing code in the Advanced Editor to perform specialized data cleaning ans transformation that is impossible using the Graphical User Interface

[@analyticalguy]

Thanks Abiola.