Practical Data Cleaning
19 Essential Tips to Scrub Your Dirty Data
Course Description
We've moved! To get the course for FREE click here.
“Data is a lot messier and noisier than people want to acknowledge”
Nate Silver
If you want to get the most out of your data, you're going to need to treat it with respect.
Most textbooks on data tend not to dwell on practical issues because, well, it can get quite messy. But if you're organised and follow a few simple rules your data cleaning processes can be simple, fast and effective - saving you time and money.
Practical Data Cleaning is a thorough introduction to the basics of data cleaning, is perfect for beginners, 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 time to organise yourself and apply some neat tips and tricks to your process.
If you watch this video course you WILL:
- 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
What’s included in the course
When you get your data organised, your data cleaning processes become much easier and faster, giving you time to plan your next holiday on company time (I won't tell the boss if you won't...).
This is what you will be learning in the Practical Data Cleaning video course.
This FREE video course will introduce you to the basic principles of why and how your data should be entered onto a single worksheet.
It will also teach you how to utilise multiple worksheets in your workbook to build a chronological flow into your data cleaning processes so you can detect when, how and where errors were introduced.
Everything is explained in simple language and is perfect for beginners.
Some Extra Stuff for You:
- Free - Practical Data Cleaning eBook
CEO Chi-Squared Innovations
Lee Baker
I am an award-winning software creator with a passion for turning data into a story.A proud Yorkshireman, I now live by the sparkling shores of the East Coast of Scotland. Physicist, statistician and programmer, child of the flower-power psychedelic ‘60s, it’s amazing I turned out so normal!Every week, while I was working as a statistician at one of the largest research hospitals in Europe, somebody would bring me their new project data and give me the tightest deadline to get it analysed. The problem was that I had to clean it first, which took me weeks every time. So I had to develop a system to get the data analysis-ready quickly – and to also teach researchers how to reduce the errors and mistakes in their data before they gave it to me. This system was fine-tuned over several years of being a statistician, and is what I'll be teaching you in the Data Science University data cleaning courses.I hope you get as much value out of these courses as the hundreds of researchers I've helped over the past decade.
Course curriculum
-
1
Introduction
-
Meet Your Presenter (Video)
-
-
2
Practical Data Cleaning Video Course
-
The Problem With Data (Video)
-
Practical Data Cleaning (Video)
-
Your Next Step (Video)
-
-
3
Supplementary Material
-
Practical Data Cleaning (Notes)
-
Practical Data Cleaning (eBook)
-
Reviews
Abdikadar Osman
Darrell Prather
Fabulous title
Despina U
Fabulous content, fabulous course, I would recommend it to anyone working practically in the field.
Fabulous content, fabulous course, I would recommend it to anyone working practically in the field.
Read LessI wish I had found such a web-training five years ago
Sandra Seel
Mabel Bolivar-Rodriguez
Great course
Great course
Read LessReal applications
Anibal Fraquelli
This course from Lee is a focused and great way to learn one of the toughest parts of the data analysis. Practical and applicable information for the full p...
Read MoreThis course from Lee is a focused and great way to learn one of the toughest parts of the data analysis. Practical and applicable information for the full process, collection of the data, cleansing and making decisions with it.
Read LessIt's Excellent
Luis Eduardo Polania
It's Excellent
It's Excellent
Read LessGood course
evans kibet
A great course. Looking forward to more complex stuff.
A great course. Looking forward to more complex stuff.
Read Lessgood
Gunjan Roy
good- please suggest some tools
good- please suggest some tools
Read LessGreat Summary
john worona
This course really brings to the forefront 'best practices' when your trying to analyse data. I have been analyzing data as part of my job for most of my car...
Read MoreThis course really brings to the forefront 'best practices' when your trying to analyse data. I have been analyzing data as part of my job for most of my career. I learned the hard way of how to organize your data and Lee conveniently summarized them in the video. If you just starting out in this field, give them course a review and post all 19 items onto one sheet and affix them to your desk.
Read LessGreat first steps
Ian Watt
This short introductory course is a great primer for those working with data, and highlights not just many pitfalls arising from the design of the collection...
Read MoreThis short introductory course is a great primer for those working with data, and highlights not just many pitfalls arising from the design of the collection of data, mis-use of Excel and having no process - but also shows some practical steps to do things better!
Read LessFeedback
Joseph Manalang
The session is very easy to understand. It provided a clear and concise way of cleaning a data should be.
The session is very easy to understand. It provided a clear and concise way of cleaning a data should be.
Read LessTubay GEL EMREBAS
Short, clear and practical
Florens de Wit
"Practical data cleaning" is a call to data scientsts and other "data users" to be frugal with your time; Blogs, shares and articles on what data science is ...
Read More"Practical data cleaning" is a call to data scientsts and other "data users" to be frugal with your time; Blogs, shares and articles on what data science is and what it could be often contain a statement like "data scientists spend [some large percentage] of their time on preparing the data and only [a small percentage] on actually squeezing actionable insight from the data.". If this is a common problem then it is partially due to lacking the insight or the incentive to set up a system that avoids having to repeat the often uninteresting steps of cleaning and preparing data. Though I am not sure I will use the knowledge and tricks shown any time soon (I'm unemployed), I will remember this when the time is right.
Read LessMohan Kumar
Thank you
rank lord
Dear Lee, Thank you for the course! It is clearly can be seen that you know what you are talking about and you love your work. And as you have correctly to...
Read MoreDear Lee, Thank you for the course! It is clearly can be seen that you know what you are talking about and you love your work. And as you have correctly told it, we all learn from what is not so good :) So, once again, thank you for your time and free course! Cheers.
Read Less