Part 1: Top 20 Data Cleaning Tricks in 2024 - Excel / Power BI

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:
docs.google.com/spreadsheets/d/1YKmswx1zl3CyVIFP2d…

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!
👉 lnkd.in/dkvAd2ss
----------
How to submit your assignment?
Post your work on your LinkedIn profile and tag Anietie Etuk: (www.linkedin.com/in/etukanietie/).

Click below to watch Part 2 of this series:
   • Part 2: How to optimize a Data Model in 20...  

Click below to watch Part 3 of this series:
   • Part 3: Modern Dashboard Design using Exce...  

//////////
You can build a 4-year data analytics portfolio in 4 weeks.
HOW?

Here's your golden opportunity:
1. Master the art of crafting stunning portfolio websites on GitHub effortlessly.
2. Ace interviews with confidence after completing four interview-ready data analytics projects in just four weeks! (Valued at N40,000).
3. Learn the crucial skill of effectively documenting and presenting your projects to impress employers and industry experts.
4. Gain six months of exclusive access to not just one, but two of my top-tier data analytics courses (Valued at N20,000).
5. Access downloadable videos of two additional courses to broaden your knowledge horizon (Valued at N80,000).
6. Join a close-knit community of aspiring analysts, fostering growth and networking opportunities.
7. Experience unparalleled guidance with my personal mentorship for four weeks (Valued at N100,000).

And here's the deal you can't miss out on: Secure all of this for an incredible price of just N25,000!
But act fast – enroll now and pay only N20,000 if you seize this limited-time offer before Monday, 3rd June, when classes commence.

Ready to invest in your future success? Don't let this chance slip away. Reserve your spot today by sending N20,000 to:
• 📌 Anietie Etuk
• 📌 2018321155
• 📌 First Bank

Hurry! Send proof of payment via WhatsApp to: +234 816 763 7212 to claim your discount and embark on your journey to data analytics mastery.
I'll see you in class.

You can check out my profile on these social platforms:
• LINKEDIN: www.linkedin.com/in/etukanietie
• YOUTUBE:    / @learnwithetuk  
• FACEBOOK: web.facebook.com/AnietieEtukNG

#dataanalytics #dataanalysis #data #dax #dashboard #analytics #analysis #analyst #dataanalyst