Module 2 - Follow the data lifecycle

Question 1

What is the second phase of data analysis?

Answer 1

Prepare: Collect and store data for analysis

Question 1

What is the first phase of data analysis?

Answer 1

Ask: Define the problem and confirm stakeholder expectations

Question 2

What is the third phase of data analysis?

Answer 2

Process: Clean and transform data to ensure integrity

Question 3

What is the fourth phase of data analysis?

Answer 3

Analyze: Use data analysis tools to draw conclusions

Question 4

What is the fifth phase of data analysis?

Answer 4

Share: Interpret and communicate results to others to make data-driven decisions

Question 5

What is the sixth phase of data analysis?

Answer 5

Act: Put your insights to work in order to solve the original problem

Question 6

What are all stages of the data lifecycle?

Answer 6

1. Plan
2. Capture
3. Manage
4. Analyze
5. Archive
6. Destroy

Question 7

Database

Answer 7

A collection of data stored in a computer system

Question 8

In the data lifecycle, which phase involves using data to solve problems, make good decisions, and support business goals?

Answer 8

Analyze: The analyze phase involves using data to solve problems, make great decisions, and support business goals

Question 9

Data lifecycle: Plan

Answer 9

Decide what kind of data is needed, how it will be managed, and who will be responsible for it.

Question 10

Data lifecycle: Capture

Answer 10

Collect or bring in data from a variety of different sources.

Question 11

Data lifecycle: Manage

Answer 11

Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so.

Question 12

Data lifecycle: Analyze

Answer 12

Use the data to solve problems, make decisions, and support business goals

Question 13

Data lifecycle: Archive

Answer 13

Keep relevant data stored for long-term and future reference.

Question 14

Data lifecycle: Destroy

Answer 14

Remove data from storage and delete any shared copies of the data.

Question 15

What is a universal data management principle?

Answer 15

Govern how data is handled so that it is accurate, secure, and available to meet your organization’s needs.

Question 16

What are the two parts of the Ask Data Analysis phase?

Answer 16

1. Define the problem to be solved
2. Make sure we fully understand stakeholder expectations

Question 17

Stakeholder

Answer 17

People who have invested time and resources into a project and are interested in the outcome

Question 18

Defining a problem

Answer 18

Look at the current state and identify how it’s different from the ideal state

Question 19

Prepare phase

Answer 19

The emphasis is on identifying and locating data you can use to answer your questions.

Question 20

Process phase

Answer 20

Refine your data! Find and eliminate any inaccuracies that can get in the way of results.
1. Clean the data
2. Transform data into a more useful format
3. Combine two or more datasets to make information more complete
4. Remove outliers (data points that could skew the information)

Question 21

Analyze phase

Answer 21

Turn the data you’ve gathered, prepared, and processed into actionable information

Question 22

Share phase

Answer 22

Share what you’ve learned with your stakeholders

Question 23

Act phase

Answer 23

Insights from data are put to work!

Question 24

Common data analyst tools

Answer 24

1. Spreadsheets
2. Query languages
3. Data visualization tools

Question 25

Spreadsheet

Answer 25

Digital worksheet - stores, organizes, and sorts data

Question 26

Formula

Answer 26

A set of instructions that performs a specific calculation using the data in a spreadsheet

Question 27

Function

Answer 27

A preset command that automatically performs a specific process or task using the data in a spreadsheet

Question 28

Query language

Answer 28

A computer programming language that allows you to retrieve and manipulate data from a database

Question 29

Query

Answer 29

A request for data or information from a database

Question 30

SQL

Answer 30

Structured query language