THE WONDERFUL WORLD OF DATA INTRODUCTION

Test your knowledge on the data life cycle

1. 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.

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

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

4. 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?

5. 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?

Test your knowledge on the data analysis process

1. The data analysis process phases are Ask, Prepare, Process, Analyze, Share, and Act. What do data analysts do during the Ask phase?

2. During the process phase of data analysis, a data analyst cleans data to ensure it’s complete and correct.

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

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

5. 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?

Test your knowledge on data analysis toolbox

1. 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.

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

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

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

5. What is the term for the graphical representation of data?

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Weekly Breakdown | Google Study Guides | Back to Top

Foundations: Data, Data, Everywhere Weekly Challenge 3

1. Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle.

2. The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.

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

4. Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.

5. What actions might a data analytics team take in the Act phase of the data analysis process? Select all that apply.

6. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.

7. Fill in the blank: To request, retrieve, and update information in a database, data analysts use a ____.

8. Fill in the blank: Structured query language (SQL) enables data analysts to _____ the information in a database. Select all that apply.

9. 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.

10. A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which stage of the data life cycle?

11. The data life cycle deals with the stages that data goes through; data analysis involves following a process to analyze data.

12. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process?

13. What is the main difference between a formula and a function?

14. Structured query language (SQL) enables data analysts to communicate with a database.

15. In the analyze stage of the data life cycle, what might a data analyst do? Select all that apply.

16. Describe how the data life cycle differs from data analysis

17. Fill in the blank: A function is a predefined operation, whereas a formula is _____.

18. Fill in the blank: A query is used to _____ information from a database. Select all that apply.

19. In which stage of the data life cycle does a business decide what kind of data it needs, how the data will be managed, and who will be responsible for it?

20. 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?

21. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes the share step of the data analysis process.

22. A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit.

23. Data analysts use queries to request, retrieve, and update information within a database.

24. You are in the plan stage of the data lifecycle for your current project. What action might you take during this stage?

25. What is the primary purpose of the destroy stage of the data life cycle?

26. A data analyst is working at a small tech startup. On their current project they are in the analyze stage of the data life cycle. What might they do in this stage?

27. A business analyst recently completed a project that their company has decided to use to solve a larger business problem. What step is this in the data analysis process?

28. Data analysts use queries to analyze information within a database.

29. In the plan stage of the data life cycle, what decisions would a data analyst make? Select all that apply.

30. A set of instructions used to perform a specified calculation is known as what?

31. In the course of their current project, a data analyst uses a query to retrieve and request information. Which of the following are options the analyst can use a query for? Select all that apply.

32. Why is SQL the most popular structured query language? Select all that apply.

33. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle?

34. The data life cycle deals with the stages that data goes through during its useful life; data analysis involves following a process to analyze data.

35. In data analysis, a function is a preset command whereas a formula is a set of instructions used to carry out a specific calculation.

36. Fill in the blank: To request, retrieve, and update information in a database, data analysts use a _____.

37. The planning 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.

38. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

39. Fill in the blank: In the act phase of the data analysis process, a company may need to _____ the insights of the data analysis team.

40. Fill in the blank: Using a formula to perform calculations, creating a report from their data, and using spreadsheets to aggregate data would all be actions carried out in the ________ stage of the data lifecycle.

41. Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.

42. Fill in the blank: A function is a preset command, whereas a formula is _____.

43. In the destroy phase of the data lifecycle, a data analyst might shred paper files.

44. A data analyst is working at a small tech startup. On their current project they are using spreadsheets to aggregate data. In which stage of the data life cycle is this analyst?

45. In data analysis, a preset command is known as what?

tHE WONDERFUL WORLD OF DATA CONCLUSION