Data Cleaning With Power Query (Better than Excel)

Stop cleaning data with Excel formulas. Try using Power Query Instead.

Data cleaning in Excel is a slow and tedious process due to all the manual steps. Instead, a much faster and easier alternative experts use is Power Query. So in this video, we teach you how to clean data using Power Query. This includes removing duplicates, merging multiple columns into one, adding new custom columns, subtracting dates, formatting data, cleaning up spaces with TRIM, and Capitalize, and much more. You'll also learn advanced features like adding an IF ELSE IF statement as a custom column, using group by to analyze data in new queries, etc. By the end of the video, you'll know all the key steps to data cleaning in Power Query.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Data Cleaning
1:10​ - Removing Duplicates
2:01​ - Cleaning Dates & Adding Date Columns
3:00​ - Name Formatting
5:04​ - Merging Columns
5:43​ - Custom Columns
7:48​ - Add Columns
8:33​ - Group By Data Analysis

[ATnT-blues]

I underestimated Power Query, spent a while here. First, there's no data profiling tools in my Power Query editor (probably my Excel version is old) - the column distribution, column profile, so had to go back to remove duplicates in Excel first, after hours. And had to do the basic replace values instead of Custom column, the PQ formulas didnt show up as I typed it in the Custom Column dialog box.
Managed to get it done still, thanks for the video man!

[markpodesta]

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

[mozaffarhassan]

Hello Kenji, All of your video teaching is really great. Really Appreciated. Keep it up. Thanks.

[shaikhataurrehman]

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

[AlbertDinata]

This is really useful! Thanks a lot Kenji for sharing this

[Siwaphiwemzinyana]

Bro your channel is priceless we appreciate you ♥

[AbdulRahman-ypoy]

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.

[abdelhakimhilmi]

Muchas gracias Kenji, you're an amazing Teacher

[zafarmadjidov]

Thank you for your helpful videos, Kenji!

[petlover]

Amazing techniques. Thanks a lot for the video.

[shuaibbandeally]

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

[bruhmoment]

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

[patrickkinbonso]

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

[TheLaopi]

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

[shimaamohamed]

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 ?

[naortie.]

Good, I tried downloading the free data analytics guide but is requesting my company website which I don't have because am working as an individual. how do i go about it without company website. Thank you

[zainolariffin]

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.

[HenningMoeller]

how to find douplicates in a row like you explained for columns?

[noobsplace]

There's no "column distribution" in my Power Query Editor, so what should do?

[assiabouhadouza]

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 :)