In this video, learn about the issues with dirty data and how to distinguish between clean and dirty data. You need to be using clean data to perform a good analysis.
- Before you do any data analysis, … you need to make sure that your data is ready. … This means you need to ensure your data is clean. … There's an important distinction … between clean data and dirty data. … Dirty data can have all kinds of problems with it. … There might be columns that don't align, … rows that don't align. … The units of measure or the currencies could be wrong. … You might also find duplicative data or missing data, … and other data may have somehow shifted around. … All of these things need to be controlled for … in order for your data to be considered clean, … and the only data you should be analyzing is clean data. … After all, if you analyze dirty data, … it's a little bit like garbage in, garbage out, … and the results of all your hard work and analysis … will be something that's probably meaningless … and could even point you in the wrong direction … when it comes to deriving implications. … Furthermore, all the work you will have done … will have been wasted, …
Note: This course was created by Jason Schenker. We are pleased to host this training in our library.
Skill Level Beginner
Excel: Economic Analysis and Data Analyticswith Michael McDonald1h 37m Intermediate
Economics for Everyone: Understanding a Recessionwith Jason Schenker36m 31s Intermediate
Economics for Everyone: Job Markets and the Economywith Jason Schenker41m 42s Intermediate
2. Best Practices
3. Project Management
4. Evaluating Work
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.