Cleaning Messy Data | Power Query Case Study

This video is dedicated to a user's question on Data Cleansing, which I thought was nearly impossible but Power Query makes it super easy to clean messy data sets. There are ton of learnings you can draw from this data cleansing case study. Enjoy!

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== CHAPTERS =====
0:00 Intro
1:08 The Data Cleaning Problem
4:20 Power Query Clean Up
12:48 My Online Courses

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[JoseMariaGomezMartinez]

Hi Chandeep! Thanks again gentleman! Superb solution

[alphamaniac]

Great example. It forces someone to logically think about what to do, and allow PQ to do the rest. It's a powerful tool. Thanks for your insight and great explanation!

[krishnakishorepeddisetti]

Chandeep... You are awesome man.... Your content is great... I work in power bi day in and day out... But after seeing your videos... I feel... There is still a lot to learn

[cherianiype]

Super terrific Chandeep! Incredible stuff man! Thank you for this!

[somanathking]

This is literally superb sir..I was like mesmerised no words. Thankyou sir .

[CraigDG]

Thankyou Goodly, your info helped a little. I have a very messy daily data dump to clean up every day coming from external software within the company. The cleanup of the data becomes crucial in enabling an accounting reconciliation of the data, and until the data is clean, the manual reconciliation process is long and arduous and takes me away from my other work. I have found no one yet on You Tube, who has the exact problem I have and provides an exact solution, but bit by bit I am putting pieces together from different people like you that will hopefully give me the right solution i need.

[judyrodbryanvicente]

More power to your channel.. Good stuff mate

[martyc]

Brilliant Chandeep, great practical content.

[dikushnukenjeh]

This is not data cleaning; this is data rearranging. Cool applications.

[querobinenator]

I too came across the exact hurdle and used similar techniques in PQ. Great work Chandeep

[cblondhe]

Chandeep, this was another amazing video, thanks for sharing.

[RandomlyWisdom]

I paused the video at the start and tried on my own. The solution was not easy. Thanks for new data cleaning tricks.

[ArmanAper]

Hi Chandeep!, thanks for your videos. Do you have any advice for my case where I have an excel file downloaded from an accounting system and this file is nothing but a banch of grouped rows and number of levels (subgroups) vary all in one column. The report which is the goal is supposed to be dynamic. Is there a way to transform grouped excel file into flat file? Thanks in advance

[decentmendreams]

Thanks. I would have used if column A = null then give me column B else null to get the months . But happy to learn this technique of isolating cells by data type . Also, I love your technique of getting the date/month/year . I have projects that I would like to visit after watching this vid.

[ahmedbenchaoued]

Perfect bro keep going, you are good 🤙

[wayneedmondson]

Hi Chandeep. Awesome solution! Well explained and very instructive. Thanks for demonstrating. Thumbs up!!

[maheshmulik]

Thanks for the video, helped me a lot. Just one question wouldn't it be better to add one more column called present/absent and shift the "H" value there and replace "H" with 0 in the attendance column, so the whole column becomes numeric and we can perform numeric operation like sum on it ??

[vashisht]

👌 awesome.. I like these challenge video...also the logic to the problem was great 👍

[asiansalim]

Hi Chandeep @ you are always Power Query Data cleaning Super Hero

[GosCee]

Thanks for that, Chandeep. Impressive! This will undoubtedly help me in my quest to master power query.