• Home
  • |
  • Blog
  • |
  • Data Cleaning – 5 Productivity Tips

May 30, 2019

Data Cleaning – 5 Productivity Tips

In this video I’m going to give you my top 5 productivity tips for efficient data cleansing in Excel.

In fact, you can get these tips – and loads more – in my FREE video course Practical Data Cleaning, which you can get here:

 ​Practical Data Cleaning - FREE!

​Here’s a quick rundown of what you’re going to learn:

  • ​Tip 1: you’ll learn how to create a plan of action, so you’re not stabbing in the dark (and making things worse!) when it comes to cleaning your data
  • ​Tip 2: you’ll learn how – and more importantly, why – you should be version controlling your data
  • ​Tip 3: you’ll learn about the Holy Trinity of data cleaning
  • Tip 4: you’ll learn which data cleaning functions and formulae to use
  • Tip 5: you’ll learn the importance of reporting data errors back to the original source
  • Bonus Tip - where I encourage you to Back Up, Back Up, Back Up!!!

In the end, you’ll have a handful of actionable strategies that you can use in your data cleaning processes to get your data clean and analysis-ready in no time – and be disaster-proof too.

#PJStats #datacleaning #statistics

​Follow me on YouTube

For more stats and machine learning hints & tips, follow my YouTube channel here:

​Related Videos

​Related Blog Posts

​Find me on TwitFace (and elsewhere)

Related Posts

Statistical Hypothesis Testing – 4 Steps to the Correct Test

4 Types of Data in Statistics – Definitions, Uses & Examples

Lee Baker

Tweet0
Share0
Share0
Share0

Lee Baker is an award-winning software creator that lives behind a keyboard in a darkened room. Illuminated only by the light from his monitor, he aspires to finding the light switch. With decades of experience in science, statistics and artificial intelligence, he has a passion for telling stories with data, yet despite explaining it a dozen times, his mother still doesn’t understand what he does for a living. Insisting that data analysis is much simpler than we think it is, he creates friendly, easy-to-understand video courses that teach the fundamentals of data analysis and statistics. As the CEO of Chi-Squared Innovations, one day he’d like to retire to do something simpler, like crocodile wrestling.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
Do NOT follow this link or you will be banned from the site!