S2-m5

Question 1

The Data Life Cycle

Answer 1

Describes the sequential steps all business data must go through from creation, through its use, storage, and final disposal.
1. Definition
2. Capture
3. Preparation
4. Synthesis
5. Analytical and usage
6. Publication
7. Archival
8. Purging

Question 2

Definition

Answer 2

defining what data a business needs and where to capture or retrieve such data

Question 2

Capture/Creation

Answer 2

Obtain the data by creating internally or capturing data from where it has been created externally

Question 2

Cleaning Data

Answer 2

1. Remove unnecessary headings or subtotals
2. Clean leading zeros and nonprintable characters
3. Format negative numbers
4. Identify and correct inconsistencies across data in general
5. Address inconsistent data types

Question 3

Preparation

Answer 3

to determine whether the data is complete, clean, encrypted, and user friendly

Question 3

Embanking Completeness and Integrity of Data

Answer 3

any time data is moved it is possible that some of the required data could have been lost. To validate the captured data:
1. Compare number of records that you intend to capture to the number of records in the source database
2. Compare descriptive statistics for numeric fields
3. Validate that field formats are consistent
4. Compare character limits for the attributes in the source file

Question 3

Data integration

Answer 3

when data is sourced externally, it is critical to design the data architecture to ensure that the data pipeline is integrated with the target location/database

Question 4

Data Encryption

Answer 4

The sensitivity of data and the consideration if integrity would generally require encryptions both in data transit and data storage

Question 5

Synthesis

Answer 5

a bridge between preparation and usage. once you have determined how you intend to use the captured data, you can create calculated fields to prepare that data for quicker usage and analysis

Question 6

Analytics and Usage

Answer 6

focuses on the data being useful to the internal company-not being shared with external users

Question 7

Publication

Answer 7

sending monthly statements to clients, publishing financial statements, and sending quotes to customers

Question 8

Archival

Answer 8

data sets are moved from active systems to passive systems for archiving to free up storage resources for the active systems

Question 9

Purging

Answer 9

the end of the life cycle occurs when the data is completely removed from the company’s storage system

Question 10

Extract, Transform, and Load

Answer 10

When data already exists, whether that data is internal or external, the data must be extracted from its original source, transformed into useful information, and loaded into the tool you choose to use for analysis

Question 11

Active Data Collection

Answer 11

when you directly ask your users for data. This can occur from survey or interview results as well as forms gathering personal information as users emails, phone #

Question 12

Passive Data Collection

Answer 12

gather information without direct permission from their users through tracking web sage via cookies or gathering time stamps of when users interact with website

Question 13

What are data complexities when obtaining data from an external source?

Answer 13

Integrity, safety, and copyrights, are three complexities to consider when obtaining data from an external source