The Prepare phase

Question 1

It is the process of creating diagrams that visually represents how data is organized?

Answer 1

Data Modeling

Question 2

It is the process of changing the data’s format, structure, or values?

Answer 2

Data Transformation

Question 3

Differentiate Wide data from Long data?

Answer 3

Wide Data has single row with multiple column. Long Data is quite the opposite, it only has one column with multiple rows.

Question 4

It is the preference in favor of something?

Answer 4

Bias

Question 5

A type of error that systematically skews result in a certain direction?

Answer 5

Data Bias

Question 6

Differentiate the 3 types of Data Bias; Observer, Interpretation and Confirmation Bias?

Answer 6

1. Observer Bias - the tendency of people to observe same thing differently.
2. Interpretation Bias - to always interpret ambiguous situations in a positive or negative way.
3. Confirmation Bias - the tendency to search information that confirms pre existing beliefs.

Question 7

Give me your ROCCC in identifying good data sources?

Answer 7

RELIABLE
ORIGINAL
COMPREHENSIVE
CURRENT
CITED

Question 8

It is a well-founded standards of right and wrong that dictate how data is collected, shared, and used?

Answer 8

Data Ethics

Question 9

Refers to how a person have primary control over something.

Answer 9

Ownership

Question 10

Algorithms should be completely explainable and understood by the individual who provided their data?

Answer 10

Transaction Transparency

Question 11

Refers to financial transactions resulting from the usage of their personal data?

Answer 11

Currency

Question 12

Preserving a data subject’s information

Answer 12

Privacy

Question 13

Free access, usage, and sharing of data?

Answer 13

Open Data

Question 14

The importance of Data Privacy

Answer 14

• Protection from unauthorized access to private data
• Freedom from inappropriate use of data
• The right to inspect, update, or correct data
• Ability to give consent to use data
• Legal Rights

Question 15

It is the process of protecting people’s private or sensitive data by eliminating that kind of info?

Answer 15

Data Anonymization

Question 16

It is the process used to wipe data clean of all personally identifying infos?

Answer 16

De-Identification

Question 17

The ability of data system and services to openly connect and share data

Answer 17

Data Interoperability

Question 18

These are data or information that is reasonably likely identify a person?

Answer 18

Personal Identifiable Information

PII

Question 19

Collected by an entity who doesn’t have a direct relationship with the data

Answer 19

Third-party Data

Question 20

It is the process of ensuring your data is accurate and correct by setting specific rules in a a spreadsheet?

Answer 20

Data Validation

Question 21

It is a function that is used to capitalize the first letter of each word in a given text string?

Answer 21

PROPER Function
=PROPER(cell)

Question 22

Returns a substring from the beginning of a specified string?

Answer 22

LEFT Function
=LEFT(text, [number_of_characters])

Question 23

It is used to change the appearance of cells in a range based on your specific conditions?

Answer 23

Conditional Formatting

Question 24

It is a specific kind of data attribute that tells what kind of value the data is?

Answer 24

Data Type