Course 4: Module 4 Flashcards
Verification
A process to confirm that a data-cleaning effort was well-executed and the resulting data is accurate and reliable
Changelog
A file containing a chronologically ordered list of modifications made to a project
Find and replace
A tool that looks for a specified search term in a spreadsheet and allows you to replace it with something else
CASE statement
The CASE statement goes through one or more conditions and returns a value as soon as a condition is met
Documentation
The process of tracking changes, additions, deletions, and errors involved in your data-cleaning effort
Documentation involves
Recover data-cleaning errors
Inform other users of changes
Determine quality of data