PRACTICE QUIZ
If you have a short time frame for data collection and need an answer immediately, you likely will have to use historical data.
If you have a short time frame for data collection and need an answer immediately, you likely will have to use historical data.
Continuous data is measured and has a limited number of values.
Which of the following questions collect nominal qualitative data? Select all that apply.
“Did anyone recommend our restaurant to you today?”, “Have you heard of our frequent diner program?”, and “Is this your first time dining at this restaurant?” are questions that collect nominal qualitative data.
Internal data is more reliable because it’s clean.
Internal data is more reliable because it lives within a company’s own systems.
A social media post is an example of structured data.
A social media post is an example of unstructured data.
A Boolean data type must have a numeric value.
A Boolean data type can have many different types of values, but there can only be two of them.
The following is a selection from a spreadsheet: Name Attribute Value Agnes Shipton Age 44 Agnes Shipton Occupation Entrepreneur Henry Sing Age 36 Henry Sing Occupation Editor What kind of data format does it contain?
The selection from the spreadsheet contains long data.
A data analyst is working in a spreadsheet application. They use Save As to change the file type from .XLS to .CSV. This is an example of a data transformation.
A data analyst using Save As to change a file type from .XLS to .CSV is an example of a data transformation.
A data analyst at a book publisher is working on an urgent report for executives. They are using only historical data. What is the most likely reason for choosing to analyze only historical data?
The most likely reason for choosing to analyze only historical data is that a project has a very short time frame.
Which of the following is an example of continuous data?
Movie run time is an example of continuous data.
Why is internal data considered more reliable and easier to collect than external data?
Internal data is considered more reliable and easier to collect than external data because it lives within a company’s own systems.
Which of the following is an example of structured data?
A relational database is an example of structured data.
In long data, separate columns contain the values and the context for the values, respectively. What does each column contain in wide data?
In wide data, each column contains a unique data variable. In long data, separate columns contain the values and the context for the values, respectively.
Which of the following is a benefit of internal data?
A benefit of internal data is that it’s more reliable and easier to collect than external data.
Which of the following values are examples of a Boolean data type? Select all that apply.
True or false and yes or no are examples of a Boolean data type.
A data analyst is working on an urgent traffic study. As a result of the short time frame, which type of data are they most likely to use?
As a result of the short time frame, they are most likely to use historical data.
Which of the following questions collects nominal qualitative data?
“Is this your first time dining at this restaurant?” is a question that collects nominal qualitative data.
Nominal qualitative data has a set order or scale.
Nominal qualitative data does not have a set order or scale.
Structured data is likely to be found in which of the following formats? Select all that apply.
Structured data is likely to be found in a table or spreadsheet.
Which of the following are examples of discrete data? Select all that apply.
The number of actors in a movie, box office returns, and the movie budget are examples of discrete data.
Fill in the blank: Data transformation enables data analysts to change the _____ of the data.
Data transformation enables data analysts to change the structure of the data.
Fill in the blank: A Boolean data type can have _____ possible values.
A Boolean data type can have two possible values.
The following is a selection from a spreadsheet: Name Age Occupation Agnes Shipton 44 Entrepreneur Ronaldo Vincent 23 Accountant Henry Sing 36 Editor Krishna Bowling 62 Graphic designer What kind of data format does it contain?
Data transformation can change the structure of the data. An example of this is taking data stored in one format and converting it to another.
Data transformation can change the structure of the data. An example of this is taking data stored in one format and converting it to another.
A clinic surveys a group of male and female patients about their experience with physical therapy. The survey does not include people with disabilities. Is the survey data biased?
The survey data is biased because the sample group lacks inclusivity.
Which type of bias is the tendency to always construe ambiguous situations in a positive or negative way?
Interpretation bias is the tendency to always construe ambiguous situations in a positive or negative way.
Which of the following “C’s” describe qualities of good data? Select all that apply.
Good data is comprehensive, current, and cited.
If a company uses your personal data as part of a financial transaction, you should be made aware of the nature and scale of the transaction. What concept of data ethics does this refer to?
This refers to currency, which says that individuals should be aware of financial transactions resulting from the use of their personal data and the scale of these transactions.
Ownership is a key issue in data ethics. Who owns data?
The individual who originally generates the data has primary control over its usage, how it’s processed, and how it’s shared.
What is data privacy?
Data anonymization applies to both text and images.
Data anonymization applies to all personally identifiable information, including text and images.
A key aspect of open data is free access to people’s personal information.
Open data does not involve granting free access to people’s personal information.
Fill in the blank: A preference in favor of or against a person, group of people, or thing is called _____. It is an error in data analytics that can systematically skew results in a certain direction.
Data bias is a type of error that systematically skews results in a certain direction.
Fill in the blank: Data _____ refers to well-founded standards of right and wrong that dictate how data is collected, shared, and used.
Data ethics refers to well-founded standards of right and wrong that dictate how data is collected, shared, and used.
An individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data. This concept refers to which aspect of data ethics?
This refers to transaction transparency, which is the idea that an individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data.
Interoperability is key to open data’s success. Which of the following is an example of interoperability?
Different databases using common formats and terminology is an example of interoperability.
In general, the usefulness of data decreases as time passes.
In general, the usefulness of data decreases as time passes. The best data sources are current and relevant.
The right to inspect, update, or correct your own data is part of which aspect of data ethics?
The right to inspect, update, or correct your own data is part of data privacy.
Which of the following are commonly used methods for anonymizing data? Select all that apply.
Blanking, hashing, and masking are common methods of anonymizing data.
In data ethics, consent gives an individual the right to know the answers to which of the following questions? Select all that apply.
In data ethics, consent gives individuals the right to know why their data is being collected, how it will be used, and how long it will be stored.
An individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data. This is called ownership.
An individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data. This is called transaction transparency.
An employer accesses an employee’s credit report without their consent. This is not a violation of the employee’s privacy because they work at the company.
An employer cannot access an employee’s credit report without their consent. This is a violation of the employee’s data privacy.
Which of the following are qualities of unreliable data? Select all that apply.
Unreliable data is inaccurate, incomplete, and biased.
Which of the following are types of data bias often encountered in data analytics? Select all that apply.
Observer bias, interpretation bias, and confirmation bias are types of bias often encountered in data analytics.
A university surveys its student-athletes about their experience in college sports. The survey only includes student-athletes with scholarships. What type of bias is this an example of?
This is an example of sampling bias, which is when a sample isn’t representative of the population as a whole.
What is the process of protecting people’s private or sensitive data by eliminating identifying information?
Data anonymization removes personally identifiable information, such as home addresses, telephone numbers, credit card numbers, and medical records.
Which of the following situations are examples of bias? Select all that apply.
A scholar who only reads sources that support their argument, a daycare that won’t hire men for childcare positions, and a dancing competition judge who is a close friend of the dancer who wins the competition are examples of bias.
The government of a large city collects data on the quality of the city’s infrastructure. Any business, nonprofit organization, or person can access the government’s databases and re-use or redistribute the data. Is this an example of open data?
This is an example of open data. Everyone must be able to use, re-use, and redistribute open data.
Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables?
Primary and foreign keys exist in two connected tables in a relational database.
Data analysts use metadata for what tasks? Select all that apply.
Data analysts use metadata to combine data, evaluate data, and interpret a database.
Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection.
Structural metadata indicates how a piece of data is organized and whether it’s part of one, or more than one, data collection.
What is the process that data analysts use to ensure the formal management of their company’s data assets?
Data governance is the process of ensuring the formal management of a company’s data assets.
A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data.
External data representing diverse perspectives is not an appropriate reason to choose not to use a dataset. A data analyst might choose not to use external data if the it cannot be confirmed to be reliable.
A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.
The analyst can filter out sales outside of Milwaukee in 2019 and sort by date in descending order.
When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
You are working with a database table that contains customer data. The first_name column lists the first name of each customer. You are only interested in customers with the first name Mark. You write the SQL query below. Add a WHERE clause that will return only customers named Mark. SELECT * FROM customer How many customers are named Mark?
The clause WHERE first_name = 'Mark' will return only customers named Mark. The complete query is SELECT * FROM customer WHERE first_name = 'Mark'. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. Place quotes around text values. There are two customers named Mark.
When working with data from an external source, what can metadata help data analysts do? Select all that apply.
Metadata helps data analysts understand the contents of a database, ensure data is clean and reliable, and understand how to combine data from more than one source.
Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply.
The license plate number, make and model of the cab, and the company that owns the taxi represent structural metadata.
What are some key benefits of using external data? Select all that apply.
Some key benefits of using external data are that it has a broad reach and it provides industry-level perspectives.
A data analyst reviews a national database of movie theater showings. They want to find the first movies shown in San Francisco in 2001. How can they organize the data to return the first 10 movies shown at the top of their list? Select all that apply.
The analyst can filter out showings outside of San Francisco in 2001 and sort by date in ascending order.
You are working with a database table that contains customer data. The city column lists the city where each customer is located. You want to find out which customers are located in Berlin. You write the SQL query below. Add a WHERE clause that will return only customers located in Berlin. SELECT * FROM customer How many customers are located in Berlin?
Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database?
Primary and foreign keys are two connected identifiers within separate tables in a relational database.
Fill in the blank: Data governance is the process of ensuring that a company’s _____ are managed in a formal manner.
Data governance is the process of ensuring that a company’s data assets are managed in a formal manner.
A nonprofit maintains a list of how many laptops they provide to each school in the county. In the table, there is a column called number_of_laptops. A data analyst wants to determine which schools were given the fewest laptops. How should they sort the data to return these schools first?
The data analyst should sort the number_of_laptops column numerically in ascending order.
When writing a query, you must remove the two backticks around the name of the dataset in order for the query to run properly.
When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply.
The student ID number, enrollment date, and classes the student is enrolled in represent structural metadata.
Fill in the blank: Data _____ is the process of ensuring the formal management of a company’s data assets.
Data governance is the process of ensuring the formal management of a company’s data assets.
In what circumstance might a data analyst choose not to use external data in their analysis?
A data analyst might choose not to use external data in their analysis if the data cannot be confirmed to be reliable.
Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply.
Primary and foreign keys represent the connection between tables in a relational database.
Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply.
Metadata helps data analysts identify the type of data, if it is clean and reliable, and how it can be combined with another dataset.
A data analytics team labels its files to indicate their content, creation date, and version number. The team is using what data organization tool?
The team is using file-naming conventions, which are consistent guidelines that describe the content, creation date, or version of a file.
A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario?
Metadata is data about data. Metadata practices can help analytics teams create consistent naming conventions and storage practices for their files.
Data analysts use naming conventions to help them identify or locate a file. Which of the following is an example of an effective file name?
Elementary_Students_20090221_V03 is an effective file name because it is an appropriate length and references the project name, creation date, and version.
What process do data analysts use to keep project-related files together and organize them into subfolders?
Data analysts use foldering to keep project-related files together and organize them into subfolders.
Data analysts use archiving to separate current from past work. What does this process involve?
Archiving involves moving files from completed projects to a separate location.
Fill in the blank: Data analysts create _____ to structure their folders.
Data analysts create hierarchies to structure their folders.
A data analyst wants to ensure only people on their analytics team can access, edit, and download a spreadsheet. They can use which of the following tools? Select all that apply.
To control who can access or edit a spreadsheet, data analysts use encryption and sharing permissions.
A data analyst creates a spreadsheet with five tabs. They want to share the data in tabs 1-4 with a client. Tab 5 contains private information about other clients. Which of the following tactics will enable them to keep tab 5 private? Select all that apply.
Copying tabs 1-4 into a separate spreadsheet, then sharing the new file with the client will keep tab 5 private. In addition, making a copy of the spreadsheet, deleting tab 5, then sharing the new file with the client will keep tab 5 private.
A data analyst is working with a file from a customer satisfaction survey. The survey was sent to anyone who became a customer between April and June, 2020. Which of the following is an effective name for the file?
NewCustomerSurvey_2020-6-20_V03 is an effective file name because it is an appropriate length and references the project name, creation date, and version.
Data analysts use archiving to separate current from past work. It also cuts down on clutter.
Data analysts create hierarchies to organize their folders. They do this by structuring folders by specific topics at the top, then more broadly below.
Data analysts create hierarchies to organize their folders. They do this by structuring folders with broad topics at the top, then more specific topics below.
A data analyst wants to share spreadsheet tab A with their team. They’re still working with tabs B and C, and they don’t want their team members to access them yet. Hiding tabs B and C will protect them from being accessed.
Hiding tabs B and C will not protect them from being accessed.
What aspects of a file do file-naming conventions typically describe? Select all that apply.
File-naming conventions describe a file’s content, creation date, and version number.
To align file naming and storage practices, it’s useful to develop metadata practices with your data analytics team.
To align file naming and storage practices, it’s useful to develop metadata practices with your data analytics team.
A data analyst creates a file that lists people who donated to their organization’s fund drive. An effective name for the file is FundDriveDonors_20210216_V01.
FundDriveDonors_20210216_V03 is an effective file name because it is an appropriate length and references the project name, creation date, version.
Data analysts create hierarchies to organize their folders. How are folder hierarchies structured?
Folder hierarchies are structured with broad topics at the top, then more specific topics below.
A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of what?
A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of data security.
To reduce clutter, a data analyst hides cells that contain long, complex formulas. To view the formulas again, the analyst will need to adjust the spreadsheet sharing or encryption settings.
Hidden cells can be easily unhidden using the unhide feature. Hiding does not protect data.
Foldering may be used by data analysts to organize folders into what?
Foldering may be used by data analysts to organize folders into subfolders.
A data analyst completes a project. They move project files to another location to keep them separate from their current work. This is an example of what process?
Moving project files to another location to keep them separate from their current work is an example of archiving files.
Using encryption to protect data is an example of what?
Using encryption to protect data is an example of data security.
Fill in the blank: File-naming conventions are _____ that describe a file's content, creation date, or version.
File-naming conventions are consistent guidelines that describe a file's content, creation date, or version.
Fill in the blank: A data analytics team uses _____ to indicate consistent naming conventions for a project. This is an example of using data about data.
A data analytics team uses metadata to indicate consistent naming conventions for a project. This is an example of using data about data.
Data analysts use a process called encryption to organize folders into subfolders. Explanation
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.
First-party data is data collected by an individual or group using their own resources.
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.
A Boolean data type has only two possible values, such as yes or no.
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.
The data in column D is an example of continuous data, which can be measured.
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?
This is unstructured data, which is not organized in an easily identifiable manner.
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.
Building trust involves not sharing private or sensitive client information.
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?
This describes first-party data, which is collected by an individual or group using their own resources.
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.
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.
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?
Unstructured data is not organized in an easily identifiable manner.
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.
Building trust can be achieved by showing a client that you will keep client data safe by using passwords and user permissions.
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?
First-party data is data collected by an individual or group using their own resources.
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?
Boolean data has only two possible values, such as yes or no.
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.
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.
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.
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 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?
The way questions are written, the amount of time given to answer each question, and the inclusivity of the participants can cause potential bias.
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.
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.
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 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.
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?
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’.
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?
This describes data privacy, which involves protecting an individual's private data.
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?
Data analysts access external data from open-data websites and public databases.
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?
Sorting data enables data analysts on the same team to use the same dataset for different purposes.
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.
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.
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 with the last name Hassan from the Clients table in our database?
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’.
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?
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.
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?
External data can come from a variety of places. This may include other businesses, government sources, professional associations, and more.
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?
Sorting, filtering, and freezing header rows enable data analysts on the same team to use the same dataset for different purposes.
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?
First-party data is data collected by an individual or group using their own resources.
Scenario 1 continued The next thing you review is t he file containing pictures of sandwich deliveries over a period of 30 days. This is an example of structured data.
This is an example of unstructured data, which is not organized in an easily identifiable manner.
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.
Data privacy involves preserving a data subject’s information and activity any time a data transaction occurs.
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?
This is Boolean data, which has only two possible values, such as yes or no.
Ready to test your recall?
If you have a short time frame for data collection and need an answer immediately, you likely will have to use historical data.
How confident are you in this answer?