Glossary: Terms and definitions

We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.

To use the glossary for this course item, click the link below and select “Use Template.”

Link to glossary: Week 4 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below.

Weekly challenge 4

1st grade

Question 1

Fill in the blank: A data analyst finishes cleaning their data. The next step in the process is reporting and ____.

A. verification

B. manipulation

C. processing

D. replacing

A data analyst finishes cleaning their data. The next step in the process is reporting and verification

Question 2

A data analyst is starting a large scale project that is crucial to business success. The data analyst needs to remember the big picture when verifying their data cleaning. What is involved when focusing on the big picture-view of the project? Select all that apply.

• Consider the reporting
• Consider the stakeholders
• Consider the goal
• Consider the business problem

Question 3

Which function removes leading, trailing, and repeated spaces in data?

A. CUT

B. TIDY

C. CROP

D. TRIM

TRIM function removes leading, trailing and repeated spaces in data.

Question 4

A data analyst uses the COUNTA function to count which of the following?

A. The total number of headers in a specific range

B. The total number of values within a specified range

C. The total number of entries in a changelog

D. The specific numbers in a dataset

The correct answer is B. The total number of values within a specified range

Question 5

You’re working with a dataset that contains categorical variables. You notice that some of the strings are misspelled or are not capitalized. What function can you use to fix these errors when a condition is met?

A. CASE

B. ELSE

C. WHEN

D. THEN

The correct answer is A. CASE

Question 6

What is the process of tracking changes, additions, deletions, and errors during data cleaning?

A. Observation

B. Recording

C. Documentation

D. Cataloging

The correct answer is C. Documentation

Question 7

Fill in the blank: While cleaning data, a data analyst can use a changelog to keep a chronological list of changes they make. They can refer to it during the _____ period if there are errors or questions.

A. documentation

B. presenting

C. visualization

D. verification

While cleaning data, a data analyst can use a changelog to keep a chronological list of changes they make. They can refer to it during the verification period if there are errors or questions.

Question 8

Fill in the blank: As a data analyst, you should always create a _____ to track your additions, deletions, errors, and changes to a query.

A. notepad

B. changelog

C. database

D. spreadsheet

As a data analyst, you should always create a changelog to track your additions, deletions, errors, and changes to a query.

2nd grade

Passed 100%

Question 1

The data collected for an analysis project has just been cleaned. What are the next steps for a data analyst? Select all that apply.

• Certification
• Reporting
• Validation
• Verification

Question 2

A data analyst is starting a large scale project that is crucial to business success. The data analyst needs to remember the big picture when verifying their data cleaning. What is involved when focusing on the big picture-view of the project? Select all that apply.

• Consider the business problem
• Consider the reporting
• Consider the goal
• Consider the stakeholders

Question 3

During the data cleaning process you find a significant amount of data that contains irrelevant spaces. Which function do you use to remove leading, trailing, or repeated spaces?

A. CUT

B. TRIM

C. DELETE

D. TIDY

The correct answer is B. TRIM

Question 4

While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine the number of misspelled occurrences in the dataset?

A. CASE

B. CHECK

C. COUNT

D. COUNTA

The correct answer is D. COUNTA

Question 5

You’re working with a dataset that contains categorical variables. You notice that some of the strings are misspelled or are not capitalized. What function can you use to fix these errors when a condition is met?

A. CASE

B. ELSE

C. THEN

D. WHEN

The correct answer is A. CASE

Question 6

What should a data analyst actively track throughout the data cleaning process?

A. Errors, additions, and deletions

B. Additions, changes, and queries

C. Errors, deletions, and notes

D. Changes, resolutions, and deletions

The correct answer is A. Errors, additions, and deletions

Question 7

A data analyst notices an error in a dataset during the verification process and they are trying to fix it. They remember fixing this error when previously cleaning the data. What tool can the analyst reference to find documentation of the previous fix for this error?

• Text editor
• Notepad
• Changelog
• Data table

Question 8

You use SQL to clean your data. You make comments whenever you modify your queries to keep track of any changes. What documentation will this practice help you create when you’re done cleaning the data?

A. A query repository

B. A new dataset

C. A changelog

D. A database

The correct answer is C. A changelog