Posts

Showing posts from July, 2023
Image
  Types of data validation This reading describes the purpose, examples, and limitations of six types of data validation. The first five are validation types associated with the data (type, range, constraint, consistency, and structure) and the sixth type focuses on the validation of application code used to accept data from user input.  As a junior data analyst, you might not perform all of these validations. But you could ask if and how the data was validated before you begin working with a dataset. Data validation helps to ensure the integrity of data. It also gives you confidence that the data you are using is clean. The following list outlines six types of data validation and the purpose of each and includes examples and limitations. Purpose : Check that the data matches the data type defined for a field. Example : Data values for school grades 1-12 must be a numeric data type. Limitations : The data value 13 would pass the data type validation but would be an unacceptabl...