Week 3

Should they ever dispose of any data? If so, when and how?

Destroy

A database is a collection of data stored in a computer system.

true

How will the company analyze the data? What tools should they use?

Analyze

What should they do with their data when it gets old? How do they know when it's time?

Archive

Where does your data come from? How will you get it?

Capture

What is the term for the graphical representation of data?

Data visualization

The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?

Define the problem to be solved

How will you store your data? What should it be used for, and how do you keep this data secure and protected?

Manage

What plans and decisions do you need to make? What data do you need to answer your question?

Plan

What are the 6 steps in a data life cycle?

Plan Capture Manage Analyze Archive Destroy

Based on what you have learned in this course, spreadsheets are digital worksheets that enable data analysts to do which of the following tasks? Select all that apply. Store data Choose a topic for data analysis Organize data in columns and rows Sort and filter data

Store data Organize data in columns and rows Sort and filter data

What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply. Sharing analysis results using data visualizations Validating insights provided by analysts Finalizing a strategy based on the analysis Putting a plan into action to help solve the business problem

Validating insights provided by analysts Finalizing a strategy based on the analysis Putting a plan into action to help solve the business problem

A data analyst shares insights from their analysis during a formal presentation. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What step of the data analysis process would come next?

act

After opening the ice cream shop on her farm, the same dairy farmer then surveys the local community about people's favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?

analyze

The data analysis process steps are ask, prepare, process, analyze, share, and act. During which phase would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

analyze

In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?

capture

In data analytics, SQL is an acronym meaning _____ query language.

structured

The data analysis process phases are ask, prepare, process, analyze, share, and act. During the process phase, a data analyst cleans data to ensure it's complete and correct.

true

A data analyst is working at a small tech startup. They've just completed an analysis project, which involved private company information about a new product launch. In order to keep the information safe, the analyst uses secure data-erasure software for the digital files and a shredder for the paper files. Which stage of the data life cycle does this describe?

destroy

A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving.

false

During the capture phase of the data life cycle, a data analyst may use spreadsheets to aggregate data.

false

The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it.

false

A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people's favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?

manage

During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.

planning

Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. data types key questions data analytics tools process steps

process steps

The data analysis process steps are ask, prepare, process, analyze, share, and act. In which step would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

share

Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.

a formula