Recommended Courses:
5.Optional: Engaging in the data community.
Question 1
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: C3 Scenario 1_Client Email.pdf
And click below to access the datasets:
Course 3 Final Challenge Data Sets - Customer survey data (1).csv
Course 3 Final Challenge Data Sets - Delivery times_distance (1).csv
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 by Garden employees using their own resources.
- It’s a type of data that’s categorized without a set order.
- It’s data that was collected from outside sources.
First-party data is data collected by an individual or group using their own resources.
Question 2
Next, you review the customer satisfaction survey data:
CustomerSurveyData - Customer survey data.csv
The question in column E asks, “Was your order accurate? Please respond yes or no.” What kind of data is this?
- Clean data
- Ordinal data
- Second-party data
- Boolean data
This is Boolean data, which has only two possible values, such as yes or no.
Question 3
Now, you review the data on delivery times and the distance of customers from the restaurant:
DeliveryTimes_DistanceData - Delivery times_distance.csv
The data in column E shows the duration of each delivery. What type of data is this? Select all that apply.
- Quantitative data
- Qualitative data
- Discrete data
- Continuous data
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.
Question 4
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
This is an example of unstructured data, which is not organized in an easily identifiable manner.
Question 5
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.
- Keep the data safe by implementing data-security measures, such as password protection and user permissions.
- Organize the data using effective naming conventions.
- 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.
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.
Scenario 2, questions 6-10
Question 6
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:
C3 Course Challenge Junior Data Scientist Job Description .pdf
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:
Course 3 Scenario 2_Second Interview Email.pdf
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 results do not favor a particular person, group of people, or thing?
- Instruct participants to share their name and contact information.
- Ensure the survey sample represents the population as a whole.
- Make sure the wording of the survey question does not encourage a specific response from participants.
- Give participants enough time to answer each survey question.
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.
Question 7
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.
- Internal data lives within a company’s own systems. External data lives outside the organization.
- External data is typically generated from within the company. Internal data is generated outside the organization.
- Internal data is typically generated from within the company. External data is generated outside the organization.
- External data lives within a company’s own systems. Internal data lives outside the organization.
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.
Question 8
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 filtering to help in this situation?
- Use filters to highlight the header row
- Use filters to simplify a spreadsheet by only showing you only the information you need.
- Use filters to sort the data in a meaningful order
- Use filters to show only the data that meets a specific criteria while hiding the rest
Filters enable data analysts on the same team to use the same dataset for different purposes.
Question 9
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?
- SELECT DATA FROM Clients WHERE 'Hassan'
- SELECT Clients WHERE Last_Name= 'Hassan' FROM *
- SELECT * FROM Clients WHERE Last_Name= 'Hassan'
- SELECT All WHERE Last_Name 'Hassan' FROM Clients
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'.
Question 10
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
- giving consent to use someone’s data
He asks: Which data analytics practice does this describe?
- Encryption
- Data privacy
- Sharing permissions
- Bias
This describes data privacy, which involves protecting an individuals’ private data.
- 一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一
0 Comments