Timedora
Free Online Flashcard Deck

Data Profiling and Quality Free Online Flashcards

Study Data Profiling and Quality with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

Why profile data before changing it?

Back

Profiling reveals what the data contains and helps assess its quality and fitness for the intended analysis before changes are made.

02
Front

What is the goal of data preparation?

Back

Prepare data to fit a stated purpose, not to make every dataset look perfect; identify and communicate its limitations.

03
Front

What should you establish before changing data?

Back

Before changing data, establish its source, collection period, grain, fields, data types, expected ranges, and how it was produced.

04
Front

In data profiling, what does “grain” mean?

Back

Grain describes what one row in the dataset represents.

05
Front

What does completeness assess?

Back

Completeness checks whether expected rows or values are missing.

06
Front

What does validity assess in a dataset?

Back

Validity checks whether values follow the rules for their fields, such as whether dates are valid dates.

07
Front

What does uniqueness assess?

Back

Uniqueness checks whether records that should be unique are duplicated.

08
Front

What does consistency assess in data?

Back

Consistency checks whether equivalent values are represented with different formats or labels.

09
Front

What can distribution profiling reveal?

Back

Distribution profiling examines whether values are concentrated, unusually rare, or outside expected ranges.

10
Front

What do row and column counts summarize?

Back

Row and column counts summarize the dataset’s size and structure.

11
Front

What do missing-value rates and distinct-value counts summarize?

Back

Missing-value rates show how often values are absent; distinct-value counts show how many different values occur.

12
Front

What does a frequency table help summarize?

Back

Frequency tables summarize how often values or categories occur.