Week 2

Question 1

Validity

Answer 1

The concept of using data integrity principles to ensure measures conform to defined business rules or constraints.
Data collected five years ago used technology that is not approved or supported by the business.

Question 2

Accuracy

Answer 2

The degree of conformity of a measure to a standard or a true value.
Addresses in the business database are identified as incorrect when compared to the public postal service database.

Question 3

Completeness

Answer 3

The degree to which all required measures are known.
NULL/missing value for the item “Number of employees per store”.

Question 4

Consistency

Answer 4

The degree to which a set of measures is equivalent across systems.
Date of store opening stored in both MM/DD/YYYY and MM/YY formats.

Question 5

Compatibility

Answer 5

How well two or more datasets are able to work together.

Question 6

Data merging

Answer 6

The process of combining two or more datasets into a single dataset.

Question 7

Dirty data

Answer 7

Data that is incomplete, incorrect, or irrelevant to the problem to be solved.