Practical Data Cleaning


Course Description

Data cleaning is a waste of time.

If the data had been collected properly in the first place there wouldn’t be any cleaning to do, and you wouldn’t now be faced with the prospect of weeks of cleaning to get your dataset analysis-ready.

Worse still, your boss won’t understand why your analysis report isn’t on his desk yet, a mere 48 hours after he’s asked for it. Bless him, he doesn’t understand – he thinks that cleaning data is just about clicking a few buttons in Excel and – ta da! – it’s all done. Even a monkey can do that, right?

And – for good reason – you won’t get any help from statistics books either. Data is messy and cleaning it can be difficult, time-consuming and costly. Not to mention it’s the least sexy thing you can do with a dataset.


Yet you’ve still got to do it, because, well, someone has to…

But it doesn’t have to be so difficult. If you’re organised and follow a few simple rules your data cleaning processes can be simple, fast and effective.

Not to mention fun!

Well, not fun exactly, just not quite as coma-inducing.


Practical Data Cleaning explains the 19 most important tips about data cleaning with a focus on understanding your data, how to work with it, choose the right ways to analyse it, select the correct tools and how to interpret the results to get your data clean in double quick time.

Best of all, there is no technical jargon – it is written in plain English and is perfect for beginners!

Practical Data Cleaning is a thorough introduction to the basics of data cleaning and takes you through:

  • Data Collection
  • Data Cleaning
  • Data Classification *Enhanced Section*
  • Data Integrity
  • Working Smarter, Not Harder


Why do things the difficult way when you can do them simply? It really is all about spending a little bit of quality time with your data, organising yourself and applying a simple, but repeatable process.

If you watch this video course you WILL:
  • learn to organise your datasets in a way that will save you time
  • reduce the amount of mistakes you make when entering data into Excel
  • become more productive
  • get your results much faster



At the end of this course you will receive a certificate of completion. Post it to Facebook, your LinkedIn page or print it out and stick it on your wall. Just don’t throw darts at it, ok…


What You’ll Get

  • 36 minutes of video content
  • Practical Data Cleaning Excel Template
  • Practical Data Cleaning Cheat-Sheet


Learning Outcomes

  • Learn the basic principles of data handling
  • Learn how and why you should use multiple Excel worksheets
  • Learn how to build a chronological flow to your data cleaning processes
  • Learn how to detect when, how and why errors were introduced to your data
  • Best suited for beginners
  • Excel is used as a learning tool, but the lessons learned are transferable to other media
  • Data files are provided for the student to practice with
  • Practical learning experience with real data


Course Content

Total learning: 5 lessons Time: 36 minutes


Admin bar avatar

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.



  • 36 minutes on-demand video
  • Language: English
  • Certificate of Completion
Do NOT follow this link or you will be banned from the site!