Course 1 Week 3 Practice Quiz

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

True or False: 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

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

Fill in the blank: 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

Consider what you reviewed about the phases of data: What is the relationship between the data life cycle and the data analysis process? How are the two processes similar? How are they different? What is the relationship between the Ask phase of the data analysis process and the Plan phase of the data life cycle? How are they similar? How are they different? Reflect on your learning and think about how you can apply the phases of data to future projects. Now, write 2-3 sentences (40-60 words) in response to each of these questions. Type your response in the text box below.

.

During which phase of data analysis would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

Analyze

The steps of the data life cycle are: Plan: What plans and decisions do you need to make? What data do you need to answer your question? Capture: Where does your data come from? How will you get it? Manage: How will you store your data? What should it be used for? How do you keep this data secure and protected? Analyze: How will the company analyze the data? What tools should they use? Archive: What should they do with their data when it gets old? How do they know when it's time? Destroy: Should they ever dispose of any data? If so, when and how? Reflection Consider your learning about the steps of the data life cycle and reflect on the hiring manager's request. Review the following questions to help guide your thinking: What kind of data should they gather? How should they gather this data? Where will the data live? How will they store the data? Once they have the data, how will they use it? How do they keep their data secure and protected? What should they do with old data? What are their options? In the text box below, write 2-3 sentences (40-60 words) that explains your recommendation for how the ice cream company should collect customer flavor preference data.

.

A data analyst shares insights from their analysis during a formal presentation to stakeholders. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What phase 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

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

Capture

In which data analysis phase would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

Share

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 Organize data in columns and rows Sort and filter data

True or False: A database is a collection of data stored in a computer system.

True

True or False: During the process phase of data analysis, a data analyst cleans data to ensure it's complete and correct.

True

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

a formula

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

structured