Week 2 - Mastering the Data I

Question 1

What sources can you find data in?

Answer 1

• Internal (e.g. under the ERP system)
• External (e.g. open source (Kaggle.com), government websites, commercial providers).

Question 2

In most cases, where is data stored?

Answer 2

In relational databases.

Question 3

What do relational databases ensure when it comes to data?

Answer 3

• Ensures that data is complete.
• Ensures that data isn’t redundant, so they don’t take up too much space.
• Follows business rules and internal controls.
• Aid communication and integration of business processes.

Question 4

What are the four types of attributes in a relational database?

Answer 4

• Primary keys are unique identifiers.
• Foreign keys are attributes that point to a primary key in another table.
• Composite keys are a combination of two foreign keys used for line items.
• Descriptive attributes include everything else.

Question 5

What are the 5 steps for the extraction, transformation and loading (ETL) techniques.

Answer 5

1. Determine the purpose and scope of the data request.
2. Obtain the data.
3. Validate the data for completeness and integrity.
4. Clean the data.
5. Load the data for data analysis.

Question 6

What are the 6 ethical considerations of data collection and data use?

Answer 6

• Informed consent
• Privacy
• Transparency
• Ownership
• Bias
• Misuse