In today’s Live Virtual class on YouTube, I will guide you through the process I used to clean this extremely messy data in less than 1 hour. I will help you address some of the questions you’ve asked me in the past:
1. How do I determine what needs to be cleaned?
2. What is the structural algorithm in data analytics?
3. Why is Power Query one of the most efficient data cleaning tools, and how do you use it?
4. How do you optimize data and automate the cleaning process?
5. What are the top 20 data cleaning steps every data analyst should know?
Download the dataset here:
https://docs.google.com/spreadsheets/...
ASSIGNMENT
Here’s your brief:
• You’ve just been hired as a data analyst for the Federal Ministry of Health.
• Your first task is to CLEAN THE DATASET, that will be used to visualize actionable insights that will lead to cost savings, improved equipment quality, and better patient outcomes for the Ministry.
Click below or follow the LinkedIn post to get the dataset!
https://lnkd.in/dkvAd2ss
How to submit your assignment?
Post your work on your LinkedIn profile and tag Anietie Etuk: ( / etukanietie .
Click below to watch Part 2 of this series:
• Part 2: How to optimize a Data Model ...
Click below to watch Part 3 of this series:
• Part 3: Modern Dashboard Design using...
The class is FREE, but you need to subscribe to my channel for notifications:
/ @learnwithetuk
It will be an engaging session. Feel free to invite someone!
#dataanalytics #dataanalysis #data #analytics #analysis #analyst #dataanalyst