Week 6 – Course challenge

 


1. 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 was collected by Garden employees using their own resources. What type of data does this describe?

Answers

·        Third-party data

·        First-party data

·        Nominal data

·        Qualitative data

Explanation: Such information is referred to as "proprietary data" or "internally sourced data." This indicates that the information was gathered internally (by Garden staff) making use of internal resources. This sort of data is proprietary to the company and may give unique insights as it represents the specific context and activities of that particular institution.

 

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.

Answers

·        True

·        False

Explanation: Absolutely! The "yes" or "no" query in column E is a perfect illustration of Boolean information. Data in the Boolean format may only ever be in one of two states—true or false, yes or no, 1 or 0. It's a simple method of data collection and processing with only two potential results.

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 E shows the duration of deliveries from Garden to customers. What type of data is this? Select all that apply.

Answers

·        Continuous data

·        Quantitative data

·        Qualitative data

·        Discrete data

Explanation: If column E contains information on how long it took Garden to get a shipment to a client, we refer to it as "time data" or "duration data." Depending on the chosen unit, it might be expressed in hours, minutes, or seconds. Delivery performance and efficiency may be evaluated with the use of this quantitative data, which consists mostly of time measurements.

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.

Answers

·        True

·        False

Explanation: In fact, images are often considered "unstructured data." Structured data is well ordered and follows a defined format, as data in a spreadsheet or database. Images, videos, and text documents are examples of unstructured data since they were not created using a specific data model. Unlike structured data, which can be easily organized into rows and columns, the file containing the images of the sandwich delivery would be termed unstructured data.

 

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.

Answers

·        True

·        False

Explanation: What a brilliant idea! Interacting with your social media followers is a great way to promote your project and build a feeling of belonging in the Garden community. Sharing images of Garden's sandwich delivery and inviting followers to submit their own photos is a great approach to promote the company and get your audience involved in a lighthearted and engaging manner. Both your brand's visibility and your engagement with your followers will increase.

 

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

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

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?

Answers

·        Make sure the wording of the survey question does not encourage a specific response from participants.

·        Include clients with disabilities in the survey sample.

·        Give participants enough time to answer each survey question.

·        Instruct participants to share their name and contact information.

 

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?

Answers

·        A public database

·        An open-data website

·        Sewati Financial Services database in the cloud

·        Sewati Financial Services website

 

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?

Answers

·        Freeze the header rows

·        Sort the data to make it easier to understand, analyze, and visualize

·        Filter to show only the data that meets a specific criteria

·        Encrypt the spreadsheet so only you can access it



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 work in Boise from the Clients table in our database?

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.

Answers

·         Encryption and sharing permissions

·        Preserving a data subject’s information and activity any time a data transaction occurs

·        Putting privacy measures in place to protect people’s data

·        A person’s legal right to their data

 

Shuffle Q/A 1

 

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

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?

Answer

·        It’s data that was collected from outside sources.

·        It’s data that was collected by Garden employees using the company’s own resources.

·        It’s a type of data that’s categorized without a set order.

·        It’s subjective data that measures qualities and characteristics.

Explanation: What a business calls "first-party data" is information obtained directly from its own audience or consumers. It refers to information that a business obtains directly from its customers and other end users. Information like this may be gathered from customers via surveys, purchase histories, or other direct interactions with the company's offerings.

First-party data has the benefit of being trustworthy since it comes straight from the source, providing for a more in-depth insight of the company's target demographic. It is often seen as more reliable than data obtained from a third party.

Leveraging first-party data helps you achieve your client's objectives by allowing you to make more informed choices and strategies based on a more in-depth knowledge of your client's audience and their preferences.

 

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

Answer

·        It has each subject in multiple rows.

·        It is qualitative data with a set order or scale.

·        It has only two possible values.

·        It is organized in a certain format, such as rows and columns.

Explanation: There are just two valid states for Boolean information: either "true" or "false," "yes" or "no," "1" or " The binary character of Boolean data is consistent with your case if the answers in column E are restricted to "yes" or "no" about the precision of orders.

This binary structure is characteristic of Boolean variables, giving it a good categorization when there are only two potential outcomes. The inquiry regarding the precision of an order is rather easy to answer, and the Boolean form of the query lends itself to collecting a concise response.

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

Answer

  • continuous
  • qualitative
  • discrete
  • quantitative

 

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

Answer

·        Ordinal

·        Unstructured

·        Discrete

·        Relational

Explanation: The photographs taken of sandwich delivery over the course of a month are examples of "unstructured data." Information that does not have a pre-defined data model or is not arranged in a manner that makes it simple to analyze using typical databases or tables is referred to as unstructured data.

Images, videos, text documents, and other forms that don't cleanly fit into rows and columns are examples of unstructured data, in contrast to structured data, which is arranged in a tabular manner and is presented in a certain way. Because the content of the photographs depicting sandwich delivery does not have a consistent structure, several approaches to data analysis are required. These approaches often use technologies such as image recognition or natural language processing.

 

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

Answer

  • Keep the data safe by implementing data-security measures, such as password protection and user permissions.
  • 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.
  • Organize the data using effective naming conventions.

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

Answer

·        Only include participants who can answer survey questions in a timely manner.

·        Make sure the sample is chosen at random.

·        Include clients with disabilities in the survey sample.

·        Use a randomized sample of the population that includes all genders.


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

Answer

Explanation: You would use a SELECT statement that was accompanied by a WHERE clause to collect information from the Clients database on individuals who had joined your company in 2019. Assuming there is a column labeled "JoinDate" that shows when customers become members,

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

Answer

  • Encryption
  • Bias
  • Data privacy
  • Sharing permissions
19. 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.” What kind of data is this?

Answer

·        Second-party data

·        Ordinal data

·        Clean data

·        Boolean data


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

Answer

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

Explanation: The term "unstructured data" refers to information that is not arranged in a structured, tabular fashion and does not have a pre-defined data model. In the context of the file that contains photographs of sandwich deliveries made over the course of a month, the term "unstructured data" refers to the fact that the material does not adhere to any particular format standards.

Unstructured data may be represented in a variety of forms, including photographs, videos, text documents, and others. This is in contrast to structured data, which can be organized neatly into rows and columns, as in a spreadsheet or database. Because these data types do not adhere to a certain arrangement, it is far more difficult to do analysis on them using conventional database management systems.

When it comes to the images of the sandwich delivery, unstructured data indicates that the information cannot be readily searched for or analyzed in the same way that structured data can. It's possible that in order to get useful insights from unstructured data, you'll need to make use of specialized methods like natural language processing or picture recognition.

Shuffle Q/A 2

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

Answer

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

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

Answer

·        Filtering enables you to highlight the header row

·        Filtering enables you to sort the data in a meaningful order

·        Filtering simplifies a spreadsheet by only showing you the information you need

·        Filtering encrypts the spreadsheet so only you can access it


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

Answer

·        Add passwords to files

·        Make personal copies of client files

·        Assign user permissions for files

·        Change their file naming conventions


Explanation: Implementing stringent data security measures to ensure the integrity of the data as well as its confidentiality is an important step in the process of building confidence with the Garden team


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

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.

Answer

·        True

·        False


Explanation: In point of fact, there seems to be some degree of ambiguity. Data that is collected by a corporation directly from its own audience or consumers is referred to as "first-party data." It refers to the information that is gathered directly by the firm, most often via their contacts with their customers 

Post a Comment

Previous Post Next Post