Try Power Query Instead of Excel for Data Cleaning

[@KenjiExplains]

🚀Get the FREE Data Analytics Guide from Hubspot:clickhubspot.com/ag9q

[@edidiongbassey919]

I don't have website for now,so how l can get the book because l really need it to start my journey as a data analyst.

[@markpodesta4605]

Thank you Kenji. I need to understand power query more.

[@KenjiExplains]

Thanks for your comment!

[@rockycodyjesse]

this is so interesting, thanks!

[@KenjiExplains]

Glad it was helpful!

[@shaikhataurrehman6620]

Great Video Nice to know more about Power Query! Would Love to see more content about.. in the future as well .

[@KenjiExplains]

Noted!

[@abdelhakimhilmi8923]

Muchas gracias Kenji, you're an amazing Teacher

[@KenjiExplains]

Thank you! 😃

[@postproduction_hu]

Thanks Kenji!

[@karolinab9749]

Thank you😊!

[@mghayadar]

So Good. Thank You.

[@alexrosen8762]

Very useful

[@zafarmadjidov4210]

Thank you for your helpful videos, Kenji!

[@camlex6310]

Very helpful!! Thanks Kenji

[@AbdulRahman-yp6oy]

I had been waiting for a long time for Sir Kenji to upload a tutorial on Power Query, and finally, he did! 😁😁It's really great and easy to understand. 🥰Now, please make more videos on Power Query as well.

[@KenjiExplains]

Thank you for watching :)

[@shuaibbandeally]

Hi Kenji. Would love a video on relationships, data model, and multiple power queries

[@philvuk]

Awesone content as usual thanks Kenji

[@zaissiddiqui8640]

Very informative 😃

[@KenjiExplains]

Glad it was helpful!

[@nishanth4323]

Amazing 😮

[@patrickkinbonso1809]

Thanks for the video. Any idea why you duplicate the query instead of referencing it, please ? Thanks

[@petlover6072]

Amazing techniques. Thanks a lot for the video.

[@shimaamohamed6658]

the step of custom column for payment types can we use replace value insteed of it ? replace credit card with card and blank transfer into transfer ?

[@bruhmoment1107]

Would like to see power query update to the excel course of yours!

[@zainolariffin4936]

Hi Kenji. Is there any way to convert whole number to decimal form in power query? I tried to do that, it can be display as decimal in power query but as soon i load it, the data become whole number again. I've read it elsewhere that this is one of the limitation of powerquery.

[@assiabouhadouza1927]

Hi, thanks for the video. I am desperate to retrieve data in power query from a microsoft list. I am using a Mac and when I get data from my SharePoint list, then I transform data. I have some columns where instead of the actual value it is mentioned "List". I searched everywhere and nothing works I can't believe I am the only one having this issue. All AI apps are suggesting to use the expand option but it is not available. Could you please help if you know how? Many thanks in advance. If you can't thats fine either :)

[@TheLaopi]

Great vidéo, where can i find all the functions like texte.contains, .....

[@sirajdun2550]

Plase upload the raw data so that we may practice it without any hudle

[@KenjiExplains]

i did...and i mention that in the video (it's in the description and its free to download)

[@willzinner8813]

1st

[@KenjiExplains]

yes!