Prepare Data For Exploration Course Challenge (Part 4)

docx

School

Kaplan University *

*We aren’t endorsed by this school

Course

IN224

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by LieutenantTroutPerson859

Prepare Data For Exploration Course Challenge (Part 4) 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) 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 33. 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 34. 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? 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. 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) 37. 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 38. 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 39. Scenario 1 continued

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

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) 40. 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 CS file directly from the attachment below. The data in column D is an example of nominal data.  True  False (Correct)

Prepare Data For Exploration Course Challenge (Part 4)

Related Documents