Prepare Data For Exploration Course Challenge (Part 1)
docx
keyboard_arrow_up
School
Kaplan University *
*We aren’t endorsed by this school
Course
IN224
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by LieutenantTroutPerson859
Prepare Data For Exploration Course Challenge (Part 1)
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.
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
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)
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)
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)
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)
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
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
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 onlv data about people who joined our
firm in 2019 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.
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)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help