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

▶ Dataset Excel file for practice
bit.ly/3ZzbUE2
▶ Self Evaluate yourself if you can become a successful Business Analyst.
topmate.io/analyticalguy/132311
In this video, I have used various techniques to clean the raw data to generate better insights as desired. It is important to understand the technique on how to clean the data. One of the most powerful tools that can be used in Excel as well as Power BI is Power Query Editor. You can literally do magic in Power Query. But you need to understand all the functionalities of Power Query to make full use of it. Some of these functions can be Delimiters, Merge Columns, Pivot, Unpivot, Add Columns, DataTypes, Append | Merge, Fill, Custom, etc.
Dirty Data ▶▶▶ Clean Data (Microsoft Excel?)
▶ TIMESTAMPS:
00:00 Introduction
00:40 Exercise #1
06:50 Exercise #2
09:25 Exercise #3
12:50 Exercise #4
16:00 Exercise #5
💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization
• End-To-End Power BI Da...
📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples
bit.ly/3TZIKtG
🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?
www.youtube.com/watch?v=MCoZC...
Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity
www.youtube.com/watch?v=2uhKF...
💡 LEARN MORE
========================
▶ Power BI Playlist -- bit.ly/3U3NVts
▶ Data Analytics Projects -- bit.ly/3hb84zd
▶ Excel Training - bit.ly/3WvCUTs
💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!
bit.ly/3DB03ex
▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data
#powerbi #powerbitutorial

[@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?

[@successfulvictorypublisher6090]

Thank you so very much! Best!

[@analyticalguy]

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

[@sunnyblaze4912]

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?

[@anjalikesarwani4970]

Thank you. Its very helpful.

[@analyticalguy]

Thank you so much.

[@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 🙏

[@wmf_0779]

Great video! Very well explained.

[@analyticalguy]

Thank you for your kind words.

[@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 👍

[@spritual_p]

Thanks man May god bless you

[@analyticalguy]

Thank you too

[@user-bn9kh9zj5j]

A very crisp and clear way to do data cleaning

[@analyticalguy]

@@user-bn9kh9zj5j thank you 🙏

[@jeremysimmons9285]

Great Lesson!

[@analyticalguy]

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

[@TheSandipstar]

More vedios on data cleaning plz

[@sumitkoshti1171]

This is just awesome brother.. thank you..

[@analyticalguy]

You’re welcome Sumit. 👍

[@crazyboy6006]

EAGERLY WAITING FOR MORE TUTORIALS OF THIS TYPE.

[@analyticalguy]

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

[@mamtabhat5221]

Thanks sir, very well explained

[@analyticalguy]

I’m glad you found this useful.

[@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.

[@ShreyasAkode]

thank you so much

[@analyticalguy]

You’re welcome, Shreyas 🙏🙏

[@crazyboy6006]

EXCELLENTY SIR, YOU HAVE UPLOAD SUCH A WONDERFUL TUTORIAL.

[@analyticalguy]

You’re welcome 🙏

[@azeezwahab5188]

Thanks

[@analyticalguy]

I’m glad you liked it 🙏

[@qasimjan5258]

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

[@analyticalguy]

Sure Qasim, I’ll do that!

[@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 - kzbin.info/www/bejne/mamUoqKpls5_q5o

[@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.