Data Cleaning Project in EXCEL | Portfolio Project for a Data Analyst |Data Scientist Beginner Guide

Data Cleaning usually takes 50-60% of data analysts or data scientists' time. So how do we do data cleaning? What are the steps that can be taken?
In this video, we will talk about data cleaning from the beginner's point of view. These videos will become a backbone for my upcoming complex data cleaning projects.
In this tutorial, we have taken an example of Sales data of 4 states with 5 categories.
When we fetch the data from various software using APIs or in-house tools, the data most of the times is not clean or it is not reable. So, our first step automatically becomes - to clean that data so that any one can work on it and make sense out of the data.
If you face any challenge while working on any of the data, then comment below and I will try to address that problem statement.
00:00 Introduction to Data Cleaning
00:55 Data Challenges
02:25 Two Approaches to clean data
03:00 Get Data from source (Importing)
03:27 Power Query Editor
04:05 Solution
08:00 Summarize the data as per the required template
08:16 Working with SUMIFs
11:30 Automatic refresh (No Manual Intervention)
EXCEL + POWER BI PLAYLIST ----
Create a Power BI Dashboard for free | Interactive Sales Report for Salesmen | Grow your career
• Create a Power BI Dash...
Web Scraping from Multiple Web Pages using Power Query | Automate your Data | @Microsoft Power BI
• Web Scraping from Mult...
Pivot Tables & Charts in EXCEL | Excel Tutorials for beginners | Data Analyst Jobs | Productivity
• Pivot Tables & Charts ...
What IF Analysis in Excel | GOAL SEEK | SCENARIO MANAGER | TARGET vs ACHIEVEMENT | Sales Training
• What IF Analysis in Ex...
Data Storytelling Explained using CONDITIONAL FORMATTING in Excel for SALESMEN | Sales Data Analysis
• Data Storytelling Expl...
Excel formula for a salesmen Job interview in HINDI | Jaaniye Important Excel Tricks for success
• Excel formula for a sa...
#excel #exceltutorial #powerquery #dataanalytics #datascienceproject

[@analyticalguy]

The Dataset used in this tutorial --> bit.ly/3Lvnb1r

[@keya-je3sj]

can you please check the link ?? dataset is not available in the link

[@analyticalguy]

@@keya-je3sj hi Keya, it is available. Pls check again.

[@keya-je3sj]

@@analyticalguy still it shows site cannot be reached

[@analyticalguy]

@@keya-je3sj can you try at some other place, I have cross checked at my end. It’s working. Otherwise you can send me a mail, I’ll share the original file over there.

[@kristennaa]

This is such an expert tutorial. Great amount of helpful information packed and explained with real life scenario. Please keep on making such helpful videos 😊

[@analyticalguy]

Thank you 🙏

[@sudipto1992]

Thank you for this tutorial. Please share more data cleaning tutorials for excel.

[@analyticalguy]

I’m glad you liked it. I’ll be uploading more data cleaning videos in excel and power bi. Later on, I’ll add the videos on SQL as well. 🙂

[@shreya6115]

Great video and with really helpful content

[@analyticalguy]

I'm glad you liked it.

[@knowledgefactz85]

Please Share more critacal dataset to cleanit and for practising.

[@analyticalguy]

Sure thing. I’m planning to upload such videos soon. What else would you like me to share ?

[@knowledgefactz85]

@@analyticalguy Actually i want mentor like u who can clear my doubts related to powerbi, sql , excel, python and from other part like interviews questions. it will be more easy if u hare ur Discord Username or any thing else.
Sorry for my english.

[@analyticalguy]

@@knowledgefactz85 hi, I don’t have discord. You may connect with me at topmate.io/analyticalguy

[@knowledgefactz85]

@@analyticalguy Ok. but there is no chat section area