Data Cleaning Exercises for Data Analyst | Excel tutorial | Practical Examples Challenge |Automation

[@analyticalguy]

Hi Guys, I have shared the excel file for you to practice.

[@VikasKumar-nn6hi]

I am getting this error in power bi while transpose step....i m getting 3 column name viz. Column 3, column 4, column 5 below consumer segment column. And column 8, 9 and 10 below corporate and so on. please help.

[@analyticalguy]

@@VikasKumar-nn6hi did you follow the steps I mentioned in the video?

[@shreya6115]

I was stuck with similar dataset a few days back. I was unable to think of this solution. Thank you for this.. truly helpful 🙏🙏

[@analyticalguy]

I’m glad it was helpful Shreya 👍

[@mrtharunprao]

Thank you sir
For this step by step data cleaning process...
A happy Makara Sankranthi to you sir....

[@analyticalguy]

Thanks and wish you the same Tharun 🙏

[@user-bn9kh9zj5j]

A very crisp and clear way to do data cleaning

[@analyticalguy]

@@user-bn9kh9zj5j thank you 🙏

[@SadafAkhtar-jy4dq]

This video is very helpful for me

[@analyticalguy]

@@SadafAkhtar-jy4dq I’m glad you liked it. 👍

[@claudiamorbi3150]

Amazing tutorial! A lot of know and practical excerices.

[@analyticalguy]

I’m glad you loved it Claudia. Anything you want me to share information on? Any particular topic that will help you at workplace?

[@successfulvictorypublisher6090]

Thank you so very much! Best!

[@analyticalguy]

I’m glad you liked this video. What else would you like to learn?

[@jeremysimmons9285]

Great Lesson!

[@analyticalguy]

Thanks Jeremy. I’m glad it was useful to you :)

[@crazyboy6006]

EAGERLY WAITING FOR MORE TUTORIALS OF THIS TYPE.

[@analyticalguy]

Sure, you’ll get such videos more often now.

[@azeezwahab5188]

Thanks

[@analyticalguy]

I’m glad you liked it 🙏

[@spritual_p]

Thanks man
May god bless you

[@analyticalguy]

Thank you too

[@crazyboy6006]

EXCELLENTY SIR, YOU HAVE UPLOAD SUCH A WONDERFUL TUTORIAL.

[@analyticalguy]

You’re welcome 🙏

[@anjalikesarwani4970]

Thank you. Its very helpful.

[@analyticalguy]

Thank you so much.

[@khalidmajeed2886]

mashallah sir I love it,,,,,,,we need more

[@analyticalguy]

Thank you Khalid. You can check POWER QUERY playlist, there are more videos on this concept.

[@sumitkoshti1171]

This is just awesome brother.. thank you..

[@analyticalguy]

You’re welcome Sumit. 👍

[@wmf_0779]

Great video! Very well explained.

[@analyticalguy]

Thank you for your kind words.

[@mamtabhat5221]

Thanks sir, very well explained

[@analyticalguy]

I’m glad you found this useful.

[@qasimjan5258]

Analytical Guy, please do more common real life data cleaning scenarios.

[@analyticalguy]

Sure Qasim, I’ll do that!

[@sunnyblaze4912]

Thank you

[@TheSandipstar]

More vedios on data cleaning plz

[@ShreyasAkode]

thank you so much

[@analyticalguy]

You’re welcome, Shreyas 🙏🙏

[@mehranbayat2130]

Hi , Can you explain how can I send a power query file to someone else that he can continue on that file.

[@analyticalguy]

If the data source is on cloud, then you can share it with all the people and they can work on Power Query. In short, just try to use Google Sheets instead of Excel (For Example)

[@pratyushnigam8956]

Can I have more different examples please share link or name website for the source

[@analyticalguy]

You can check this tutorial as well - ruclips.net/video/cx1qosaiLu8/видео.html

[@darshanchaudhari7969]

Hi @analytical guy fill down is not working in power bi power query

[@analyticalguy]

Hi Darshan, it should work. Pls share the screenshot of how you’re performing this step.

[@darshanchaudhari7969]

@@analyticalguy thanks analytical guy i got the solution actually when there is blank instead of null then fill down doesn't work. For that you have to replace blank values with null

[@analyticalguy]

@@darshanchaudhari7969 yes.

[@deshn21]

Thanks ma Indian dude!

[@analyticalguy]

you're welcome.