Prepare data for exploration course challenge

Course 3 – Prepare Data for Exploration Quiz Answers

Week 5: Course Challenge

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATION

Complete Coursera Study Guide

TABLE OF CONTENT

In the Prepare Data for Exploration Course Challenge on Coursera, you will learn how to use Google data analytics to help you better manage your online presence and create strong connections with other data analysts. You will explore the essentials of personal branding, such as creating a professional profile on social media networks, writing an effective bio, and building a portfolio of work.

Additionally, you’ll gain knowledge in networking basics like forming meaningful relationships with peers and crafting the perfect elevator pitch. By taking this challenge, you’ll give yourself a competitive edge when it comes to finding job opportunities or advancing your career. Leverage the Prepare Data for Exploration Course Challenge to get ahead in the field of data analytics and make yourself stand out from other professionals in this high-demand industry!

Learning Objectives

  • Explain the importance of networking with other data analysts including reference to mentorship and communication
  • Apply best practices to manage a professional online presence
  • Describe approaches to build an online presence as a data analyst

Prepare Data for Exploration Course Challenge

1. Scenario 1, questions 1-5

Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.

Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets.

Click below to read the email:

Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?

  • It’s a type of data that’s categorized without a set order.
  • It’s subjective data that measures qualities and characteristics.
  • It’s data that was collected by Garden employees using the company’s own resources. (Correct)
  • It’s data that was collected from outside sources.

Correct: First-party data is data collected by an individual or group using their own resources.

2. Scenario 1 continued

The question in column E asks, “Was your order accurate? Please respond yes or no.” What kind of data is this?

  • Second-party data
  • Boolean data (Correct)
  • Clean data
  • Ordinal data

Correct: This is Boolean data, which has only two possible values, such as yes or no.

3. Scenario 1 continued

Fill in the blank: The data in column E is an example of _____ data. Select all that apply.

  • continuous
  • qualitative
  • discrete (Correct)
  • quantitative (Correct)

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

4. Scenario 1 continued

The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is an example of structured data.

  • True
  • False (Correct)

Correct: This is an example of unstructured data, which is not organized in an easily identifiable manner.

5. Scenario 1 continued

Now that you’re familiar with the data, you want to build trust with the team at Garden.

What actions should you take when working with their data? Select all that apply.

  • Share the client’s data with other delivery restaurants to compare performance.
  • Post on social media that you’re working with Garden and would like feedback from any of your contacts who have ordered there before.
  • Keep the data safe by implementing data-security measures, such as password protection and user permissions. (Correct)
  • Organize the data using effective naming conventions. (Correct)

Correct: You can build trust by showing a client that you will organize their data effectively and keep it safe by implementing appropriate data-security measures.

6. Scenario 2, questions 6-10

You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview.

Consider and respond to the following question. Select all that apply.

Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the sample is representative of the population as a whole?

  • Use a randomized sample of the population that includes all genders. (Correct)
  • Include clients with disabilities in the survey sample. (Correct)
  • Only include participants who can answer survey questions in a timely manner.
  • Make sure the sample is chosen at random. (Correct)

Correct: Choosing participants at random, including people with disabilities, and including people of all genders help ensure a survey sample represents the population as a whole.

7. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our data analytics team often uses external data. Where can you access useful external data?

  • A public database (Correct)
  • An open-data website (Correct)
  • Sewati Financial Services website
  • Sewati Financial Services database in the cloud

Correct: Data analysts access external data from open-data websites and public databases.

8. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our analysts often work within the same spreadsheet, but for different purposes. What tools would you use in such a situation?

  • Filter to show only the data that meets a specific criteria (Correct)
  • Sort the data to make it easier to understand, analyze, and visualize (Correct)
  • Freeze the header rows (Correct)
  • Encrypt the spreadsheet so only you can access it

Correct: Sorting, filtering, and freezing header rows enable data analysts on the same team to use the same dataset for different purposes.

9. Scenario 2 continued

Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people who joined our firm in 2019 from the Clients table in our database?

Course_Challenge_3 _Question_9

Correct: To write a query that retrieves only data about people who joined the firm in 2019 from the Clients table, type SELECT * FROM Clients WHERE start_date=’2019’.

10. Scenario 2 continued

For your final question, your interviewer explains that Sewati Financial Services cares about data privacy. The company needs its clients’ trust, and this is an important responsibility for the data analytics team.

He asks: What does data privacy involve? Select all that apply.

  • Encryption and sharing permissions.
  • Preserving a data subject’s information and activity any time a data transaction occurs (Correct)
  • Putting privacy measures in place to protect people’s data (Correct)
  • A person’s legal right to their data (Correct)

Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data.

11. Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data was collected by Garden employees using their own resources. What type of data does this describe?

  • First-party data (Correct)
  • Qualitative data
  • Third-party data
  • Nominal data

Correct: This describes first-party data, which is collected by an individual or group using their own resources.

12. The data in column E shows the duration of deliveries from Garden to customers. What type of data is this? Select all that apply.

  • Quantitative data (Correct)
  • Qualitative data
  • Discrete data (Correct)
  • Continuous data

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

13. The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. What type of data is this?

  • Ordinal
  • Unstructured (Correct)
  • Discrete
  • Relational

Correct: This is unstructured data, which is not organized in an easily identifiable manner.

14. Now that you’re familiar with the data, you want to build trust with the team at Garden. What data-security measures do you employ? Select all that apply.

  • Add passwords to files (Correct)
  • Change their file naming conventions
  • Assign user permissions for files (Correct)
  • Make personal copies of client files

Correct: Building trust can be achieved by showing a client that you will keep client data safe by using passwords and user permissions.

15. Consider and respond to the following question. Select all that apply. Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the results do not favor a particular person, group of people, or thing?

  • Give participants enough time to answer each survey question. (Correct)
  • Instruct participants to share their name and contact information.
  • Make sure the wording of the survey question does not encourage a specific response from participants. (Correct)
  • Ensure the survey sample represents the population as a whole. (Correct)

Correct: The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can help ensure survey results are unbiased.

16. Consider and respond to the following question. Select all that apply. Our data analytics team often uses external data. Where can you locate useful external data?

  • Sewati Financial Solutions marketing department
  • Government sources (Correct)
  • Other financial businesses (Correct)
  • A professional finance association (Correct)

Correct: External data can come from a variety of places. This may include other businesses, government sources, professional associations, and more.

17. For your final question, your interviewer explains that Sewati Financial Services needs its clients’ trust, and this is an important responsibility for the data analytics team. He asks you to identify which data analytics practice involves preserving a data subject’s information and activity any time a data transaction occurs.

  • Encryption
  • Bias
  • Sharing permissions
  • Data privacy (Correct)

Correct: Data privacy involves preserving a data subject’s information and activity any time a data transaction occurs.

18. Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people with the last name Hassan from the Clients table in our database?

C3W5

Correct: To write a query that retrieves only data about people with the last name Hassan from the Clients table, type SELECT * FROM Clients WHERE last_name=’Hassan’.

19. Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?

  • It’s subjective data that measures qualities and characteristics.
  • It’s data that was collected from outside sources.
  • It’s a type of data that’s categorized without a set order.
  • It’s data that was collected by Garden employees using the company’s own resources. (Correct)

Correct: First-party data is data collected by an individual or group using their own resources.

20. The question in column E asks, “Was your order accurate? Please respond yes or no.” The responses listed in column E are an example of Boolean data.

  • True (Correct)
  • False

Correct: A Boolean data type has only two possible values, such as yes or no.

21. Now that you’re familiar with the data, you want to build trust with the team at Garden. You decide to impress them by taking the initiative to reach out to your social media followers. You explain that Garden is a new client, and you show them the pictures of Garden’s sandwich deliveries from the client file. Then, you ask them if they have any photos of sandwich deliveries that you can evaluate.

This is an example of going above and beyond expectations and a great way to build trust.

  • True
  • False (Correct)

Correct: Building trust involves not sharing private or sensitive client information.

22. Consider and respond to the following question. Select all that apply.

Our data analytics team often uses both internal and external data. Describe the difference between the two.

  • External data came from a company’s own systems. Internal data came from the organization.
  • External data is often generated from within the company. Internal data is generated outside the organization.
  • Internal data is often generated from within the company. External data is generated outside the organization. (Correct)
  • Internal data came from a company’s own systems. External data comes from outside the organization. (Correct)

Correct: Internal data lives within a company’s own systems and is typically generated from within the company. External data lives in and is generated outside the organization.

23. For your final question, your interviewer explains that Sewati Financial Services cares about its clients’ trust, and this is an important responsibility for the data analytics team. They do this by:

  • protecting clients from unauthorized access to their private data
  • ensuring freedom from inappropriate use of client data
  • getting consent to use someone’s data

He asks: Which data analytics practice does this describe?

  • Sharing permissions
  • Encryption
  • Data privacy (Correct)
  • Bias

Correct: This describes data privacy, which involves protecting an individual’s private data.

24. Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data, which means that it was collected from outside sources.

  • True
  • False (Correct)

Correct: First-party data is data collected by an individual or group using their own resources.

25. Now, you review the data on delivery times and the distance of customers from the restaurant.

The data in column D is an example of nominal data.

  • True
  • False (Correct)

Correct: The data in column D is an example of continuous data, which can be measured.

26. You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview.

Consider and respond to the following question. Select all that apply.

Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the process does not cause potential bias?

  • Give participants enough time to answer each survey question. (Correct)
  • Make sure the wording of the survey question does not encourage a specific response from participants. (Correct)
  • Include clients with disabilities in the survey sample. (Correct)
  • Instruct participants to share their name and contact information.

Correct: The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can cause potential bias.

27. Consider and respond to the following question.

Our analysts often work within the same spreadsheet, but for different purposes. How could filtering help in this situation?

  • Filtering enables you to highlight the header row
  • Filtering simplifies a spreadsheet by only showing you the information you need (Correct)
  • Filtering encrypts the spreadsheet so only you can access it
  • Filtering enables you to sort the data in a meaningful order

Correct: Filtering enables data analysts to show only the data that they need. This makes it easier for data analysts on the same team to use the same dataset for different purposes.

28. Scenario 1, questions 1-13

You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable.
To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus.
Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.
Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets.
Click below to read the email:
And click below to access the datasets:
Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data, which means that it was collected from outside sources.

  • True
  • False (CORRECT)

Correct: First-party data is data collected by an individual or group using their own resources.

29. Scenario 1 continued

Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.”
Link to template: Customer Satisfaction Survey data
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
The question in column E asks, “Was your order accurate? Please respond yes or no.” The responses listed in column E are an example of Boolean data.

  • True (CORRECT)
  • False

Correct: A Boolean data type has only two possible values, such as yes or no.

30. Scenario 2, questions 14-

You’ve completed this program and are interviewing for a junior data scientist position at a company called Sewati Financial Services.
Click below to review the job description:
So far, you’ve successfully completed the first interview with a recruiter. They arrange your second interview with the team at Sewati Financial Services.
Click below to read the email from the human resources director:
You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview.
Consider and respond to the following question. Select all that apply.
Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the process does not cause potential bias?

  • Instruct participants to share their name and contact information.
  • Give participants enough time to answer each survey question. (CORRECT)
  • Make sure the wording of the survey question does not encourage a specific response from participants. (CORRECT)
  • Include clients with disabilities in the survey sample. (CORRECT)

Correct: The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can cause potential bias.

Correct: The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can cause potential bias.

Correct: The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can cause potential bias.

31. Scenario 2 continued

  • Consider and respond to the following question. Select all that apply.
  • Our data analytics team often uses both internal and external data. Describe the difference between the two.
  • External data came from a company’s own systems. Internal data came from the organization.
  • External data is often generated from within the company. Internal data is generated outside the organization.
  • Internal data is often generated from within the company. External data is generated outside the organization. (CORRECT)
  • Internal data came from a company’s own systems. External data comes from outside the organization. (CORRECT)

Correct: Internal data lives within a company’s own systems and is typically generated from within the company. External data lives in and is generated outside the organization.


Correct: Internal data lives within a company’s own systems and is typically generated from within the company. External data lives in and is generated outside the organization.

32. Scenario 2 continued

Consider and respond to the following question.
Our analysts often work within the same spreadsheet, but for different purposes. How could filtering help in this situation?

  • Filtering enables you to highlight the header row
  • Filtering simplifies a spreadsheet by only showing you the information you need (CORRECT)
  • Filtering encrypts the spreadsheet so only you can access it
  • Filtering enables you to sort the data in a meaningful order

Correct: Filtering enables data analysts to show only the data that they need. This makes it easier for data analysts on the same team to use the same dataset for different purposes.

33. Scenario 2 continued

Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people who joined our firm in 2019 from the Clients table in our database?

34. Scenario 2 continued

For your final question, your interviewer explains that Sewati Financial Services cares about its clients’ trust, and this is an important responsibility for the data analytics team. They do this by:

⦁ protecting clients from unauthorized access to their private data
⦁ ensuring freedom from inappropriate use of client data
⦁ getting consent to use someone’s data

He asks: Which data analytics practice does this describe?

  • Encryption
  • Data privacy (CORRECT)
  • Sharing permissions
  • Bias

Correct: This describes data privacy, which involves protecting an individual’s private data.

35. Scenario 2 continued

Consider and respond to the following question. Select all that apply.
Our analysts often work with the same spreadsheet, but for different purposes. How would you use sorting to help in this situation?
Sort data to show only the data that meets a specific criteria while hiding the rest
Sort data to highlight the header row.

  • Sort the data to arrange data in a meaningful order (CORRECT)
  • Sort data to make it easier to understand, analyze and visualize (CORRECT)
  • Sort data to show only the data that meets a specific criteria while hiding the rest
  • Sort data to highlight the header row.

Correct: Sorting data enables data analysts on the same team to use the same dataset for different purposes.

36. Scenario 2 continued

For your final question, your interviewer explains that Sewati Financial Services cares about data privacy. The company needs its clients’ trust, and this is an important responsibility for the data analytics team.
He asks: What does data privacy involve? Select all that apply.
Encryption and sharing permissions

  • A person’s legal right to their data (CORRECT)
  • Putting privacy measures in place to protect people’s data (CORRECT)
  • Preserving a data subject’s information and activity any time a data transaction occurs (CORRECT)
  • Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data.

Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data.


Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data.

COURSE CHALLENGE

2. Scenario 1 continued

Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.” 

Link to template: Customer Satisfaction Survey data

OR

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

The question in column E asks, “Was your order accurate? Please respond yes or no.” The responses listed in column E are an example of Boolean data.

  • True (CORRECT)
  • False

Correct: A Boolean data type has only two possible values, such as yes or no. 

3. Scenario 1 continued

Now, you review the data on delivery times and the distance of customers from the restaurant.

To use the template for the dataset, click the link below and select “Use Template.” 

Link to template: Delivery Times/Distance

OR

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

The data in column D is an example of nominal data.

  • True
  • False (CORRECT)

Correct: The data in column D is an example of continuous data, which can be measured.

4. Scenario 1 continued

The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. What type of data is this?

  • Unstructured (CORRECT)
  • Relational
  • Ordinal
  • Discrete

Correct: This is unstructured data, which is not organized in an easily identifiable manner.

5. Scenario 1 continued

Now that you’re familiar with the data, you want to build trust with the team at Garden. You decide to impress them by taking the initiative to reach out to your social media followers. You explain that

Garden is a new client, and you show them the pictures of Garden’s sandwich deliveries from the client file. Then, you ask them if they have any photos of sandwich deliveries that you can evaluate. 

This is an example of going above and beyond expectations and a great way to build trust.

  • True
  • False (CORRECT)

Correct: Building trust involves not sharing private or sensitive client information.

6. You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable. 

To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus. 

Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.

Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets. 

Click below to read the email:

And click below to access the datasets:

Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data was collected by Garden employees using their own resources. What type of data does this describe?

  • Qualitative data 
  • First-party data (CORRECT)
  • Nominal data
  • Third-party data

Correct: This describes first-party data, which is collected by an individual or group using their own resources.

7. Scenario 1 continued

Now, you review the data on delivery times and the distance of customers from the restaurant.

To use the template for the dataset, click the link below and select “Use Template.” 

Link to template: Delivery Times/Distance

OR

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

The data in column E shows the duration of deliveries from Garden to customers. What type of data is this? Select all that apply.

  • Qualitative data
  • Continuous data
  • Quantitative data (CORRECT)
  • Discrete data (CORRECT)

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

8. Scenario 1 continued

The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is unstructured data, which means what?

  • It’s objective and measures facts.
  • It’s organized in a certain format.
  • It’s not organized in an easily identifiable manner. (CORRECT)
  • It’s collected by a group directly from its audience and then sold. 

Correct: Unstructured data is not organized in an easily identifiable manner.

9. Scenario 1 continued

Now that you’re familiar with the data, you want to build trust with the team at Garden. 

What data-security measures do you employ? Select all that apply.

  • Make personal copies of client files
  • Change their file naming conventions
  • Add passwords to files (CORRECT)
  • Assign user permissions for files (CORRECT)

Correct: Building trust can be achieved by showing a client that you will keep client data safe by using passwords and user permissions.

Correct: Building trust can be achieved by showing a client that you will keep client data safe by using passwords and user permissions.

10. Scenario 1 continued

You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable. 

To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus. 

Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.

Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets. 

Click below to read the email:

And click below to access the datasets:

Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?

  • It’s a type of data that’s categorized without a set order.
  • It’s data that was collected from outside sources.
  • It’s data that was collected by Garden employees using the company’s own resources. (CORRECT)
  • It’s subjective data that measures qualities and characteristics.

Correct: First-party data is data collected by an individual or group using their own resources.

11. Scenario 1 continued

Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.” 

Link to template: Customer Satisfaction Survey data

OR

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

You notice that the data in column E is an example of Boolean data. Why did you come to this conclusion?

  • It has each subject in multiple rows.
  • It is qualitative data with a set order or scale.
  • It has only two possible values. (CORRECT)
  • It is organized in a certain format, such as rows and columns.

Correct: Boolean data has only two possible values, such as yes or no. 

12. Scenario 1 continued

Now, you review the data on delivery times and the distance of customers from the restaurant.

To use the template for the dataset, click the link below and select “Use Template.” 

Link to template: Delivery Times/Distance

OR

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

Fill in the blank: The data in column E is an example of _____ data. Select all that apply.

  • qualitative
  • continuous
  • quantitative (CORRECT)
  • discrete (CORRECT)

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

Correct: This is an example of discrete data, which is counted and has a limited number of values. It is also quantitative data, which is specific and measures numerical facts.

13. Scenario 1 continued

Now that you’re familiar with the data, you want to build trust with the team at Garden. 

What actions should you take when working with their data? Select all that apply.

  • Post on social media that you’re working with Garden and would like feedback from any of your contacts who have ordered there before. 
  • Share the client’s data with other delivery restaurants to compare performance.
  • Organize the data using effective naming conventions. (CORRECT)
  • Keep the data safe by implementing data-security measures, such as password protection and user permissions. (CORRECT)

Correct: You can build trust by showing a client that you will organize their data effectively and keep it safe by implementing appropriate data-security measures.

Correct: You can build trust by showing a client that you will organize their data effectively and keep it safe by implementing appropriate data-security measures.

15. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our data analytics team often uses both internal and external data. Describe the difference between the two.

  • External data came from a company’s own systems. Internal data came from the organization. 
  • External data is often generated from within the company. Internal data is generated outside the organization.
  • Internal data is often generated from within the company. External data is generated outside the organization. (CORRECT)
  • Internal data came from a company’s own systems. External data comes from outside the organization. (CORRECT)

Correct: Internal data lives within a company’s own systems and is typically generated from within the company. External data lives in and is generated outside the organization.

Correct: Internal data lives within a company’s own systems and is typically generated from within the company. External data lives in and is generated outside the organization.

16. Scenario 2 continued

Consider and respond to the following question.

Our analysts often work within the same spreadsheet, but for different purposes. How could filtering help in this situation?

  • Filtering enables you to highlight the header row
  • Filtering simplifies a spreadsheet by only showing you the information you need (CORRECT)
  • Filtering encrypts the spreadsheet so only you can access it
  • Filtering enables you to sort the data in a meaningful order

Correct: Filtering enables data analysts to show only the data that they need. This makes it easier for data analysts on the same team to use the same dataset for different purposes. 

19. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our data analytics team often uses external data. Where can you access useful external data?

  • Sewati Financial Services website
  • Sewati Financial Services database in the cloud
  • An open-data website (CORRECT)
  • A public database (CORRECT)

Correct: Data analysts access external data from open-data websites and public databases.

21. Scenario 2 continued

For your final question, your interviewer explains that Sewati Financial Services cares about data privacy. The company needs its clients’ trust, and this is an important responsibility for the data analytics team. 

He asks: What does data privacy involve? Select all that apply.

  • Encryption and sharing permissions
  • A person’s legal right to their data (CORRECT)
  • Putting privacy measures in place to protect people’s data (CORRECT)
  • Preserving a data subject’s information and activity any time a data transaction occurs (CORRECT)

Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data. 

Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data. 

Correct: Data privacy deals with preserving a data subject’s information and activity any time a data transaction occurs, a person’s legal right to their data, and establishing privacy measures to protect people’s data. 

23. Scenario 2, questions 6-10

You’ve completed this program and are interviewing for a junior data scientist position at a company called Sewati Financial Services. 

Click below to review the job description:

So far, you’ve successfully completed the first interview with a recruiter. They arrange your second interview with the team at Sewati Financial Services. 

Click below to read the email from the human resources director:

You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview. 

Consider and respond to the following question. Select all that apply.

Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the sample is representative of the population as a whole?

  • Only include participants who can answer survey questions in a timely manner.
  • Include clients with disabilities in the survey sample. (CORRECT)
  • Use a randomized sample of the population that includes all genders. (CORRECT)
  • Make sure the sample is chosen at random. (CORRECT)

Correct: Choosing participants at random, including people with disabilities, and including people of all genders help ensure a survey sample represents the population as a whole.

24. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our data analytics team often uses external data. Where can you locate useful external data?

  • Sewati Financial Solutions marketing department
  • Government sources (CORRECT)
  • A professional finance association (CORRECT)
  • Other financial businesses (CORRECT)

Correct: External data can come from a variety of places. This may include other businesses, government sources, professional associations, and more.

25. Scenario 2 continued

Consider and respond to the following question. Select all that apply.

Our analysts often work within the same spreadsheet, but for different purposes. What tools would you use in such a situation?

  • Encrypt the spreadsheet so only you can access it
  • Filter to show only the data that meets a specific criteria (CORRECT)
  • Sort the data to make it easier to understand, analyze, and visualize (CORRECT)
  • Freeze the header rows (CORRECT)

Correct: Sorting, filtering, and freezing header rows enable data analysts on the same team to use the same dataset for different purposes.

26.  Scenario 1, questions 1-5

You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable.

To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus.

Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.

Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets.

Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?

  • It’s data that was collected by Garden employees using the company’s own resources. (CORRECT)
  • It’s subjective data that measures qualities and characteristics.
  • It’s a type of data that’s categorized without a set order.
  • It’s data that was collected from outside sources.

Correct: First-party data is data collected by an individual or group using their own resources.

27. Scenario 1 continued

The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is an example of structured data.

  • True
  • False (CORRECT)

Correct: This is an example of unstructured data, which is not organized in an easily identifiable manner.

28. Scenario 2 continued

For your final question, your interviewer explains that Sewati Financial Services needs its clients’ trust, and this is an important responsibility for the data analytics team.

He asks you to identify which data analytics practice involves preserving a data subject’s information and activity any time a data transaction occurs.

  • Encryption
  • Sharing permissions
  • Data privacy (CORRECT)
  • Bias

Correct: Data privacy involves preserving a data subject’s information and activity any time a data transaction occurs.

29. Scenario 1 continued

Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.”

The question in column E asks, “Was your order accurate? Please respond yes or no.” What kind of data is this?

  • Second-party data
  • Ordinal data
  • Clean data
  • Boolean data (CORRECT)

Correct: This is Boolean data, which has only two possible values, such as yes or no.

Course Challenge CONCLUSION

Most work requires some level of organization, and data analytics is no different. In this part of the course, you learned best practices for organizing data and keeping it secure. You also learned how analysts use file naming conventions to help them keep their work organized.

These are essential skills for any analyst! If you’re interested in learning more about data analytics, Coursera offers a great learning experience. Join us today and see what you can achieve!