1st time

Question 1

Scenario 1, questions 1-5

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.

Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.

Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor.

Then, review the email, and the Customer Survey and Historical Sales datasets.

To use the templates for the datasets, click the links below and select “Use Template.”

Links to templates: Customer Survey and Historical Sales

OR

If you don't have a Google account, you can download the CSV files directly from the attachments below.

1. CustomerSurvey
2. HistoricalSales

After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. You email your supervisor to ask. When writing your email, what do you do to ensure it sounds professional? Select all that apply.

• Write a clear subject line that gets a fast response so you can keep working: “WHM? NEED TO KNOW WHAT THAT IS RIGHT AWAY.”
• Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear.
• Respect your supervisor’s time by writing an email that’s short and to the point.
• Use a polite greeting and closing.

Question 2

Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The data in column F (Survey Q6: What types of books would you like to see more of at Athena's Story?) is quantitative. True or False?

A. True

B. False

Question 3

Scenario 1 continued

Next, you review the customer feedback in column F of the Customer Survey dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.

Your visualization looks like this:

Pie chart categories:

Feminist science fiction 4.8%

Books about women 2.4%

Women's journals 2.4%

Feminist literary criticism 2.4%

Children's literature 15.5%

Women's history books 2.4%

Biographies of inspiration 20.2%

Feminist fiction 26.2%

Feminist zines 14.3%

Feminist poetry 4.6%

Feminist novels 3.6%

Fill in the blank: The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a _____ chart.

A. area

B. doughnut

C. pie

D. bubble

It’s called a pie chart.

Question 4

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Historical Sales

If you don't have a Google account, you can download the CSV file directly from the attachment below.

You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.

Next, you calculate the total sales over 52 weeks for feminist zines. What is the correct syntax?

A. =MAX(E2:E53)

B. =SUM(E2:E53)

C. =CALCULATE(E2:E53)

D. =COUNT(E2:E53)

the correct syntax is =SUM(E2:E53)

Question 5

Scenario 1 continued

After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.

In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.

Using historical data to make informed decisions about how things may be in the future is an example of which problem domain?

A. Discovering connections

B. Identifying themes

C. Making predictions

D. Spotting something unusual

The correct answer is C. Making predictions

Question 6

Scenario 2, questions 6-10

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below:

Junior Data Analyst Job Description

So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below:

Human Resources Director Email

You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview.

First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below:

Patel Event Plus Org Chart

As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy.

Based on what you find in the organizational chart, who should be considered the primary stakeholder for projects involving data and strategy?

A. Chief executive officer

B. Director

C. Project manager

D. Vice president

The correct answer is D. Vice president

Question 7

Scenario 2 continued

Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.

Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.

• How would you rate your overall experience — poor, average, above average, or excellent?
• Was this your first time using Patel Events Plus to plan your event? Yes or no?
• Why did our event options and features create a successful event?
• Did you experience any problems with your event? Yes or no?

Question 8

Scenario 2 continued

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question.

You’re working on a rush project, and you discover your dataset is not clean. Even though it has numerous nulls, redundant data, and other issues, the primary stakeholder insists that you move ahead and use it anyway. The project timeline is so tight that there simply isn’t enough time for cleaning. How would you handle that situation?

A. The stakeholder is in charge. It's best to do as they say and use the unclean dataset.

B. Clean the data as quickly as you can. It’s not perfect, but it’s better than it was before, and this way you can meet the deadline.

C. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

D. Contact the stakeholder’s boss to let them know about the issue and ask for help managing the stakeholder’s expectations.

The correct answer is C. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

Question 9

Scenario 2 continued

Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question.

Let’s say you want to share information about an upcoming event with stakeholders. It’s important that they’re able to access and interact with the data in real time. Would you create a report or a dashboard?

A. Report

B. Dashboard

I would to create a dashboard.

Question 10

Scenario 2 continued

Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.

To use the template for this dataset, click the link below and select “Use Template.”

Link to template: Patel Events Data

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, the metrics to consider would be the cost of the investment and what else?

A. Average event revenues

B. 2019 events held at new venue

C. Net profit in 2019

D. Purchase date

It is false answer.

2nd time

Question 1

Scenario 1, questions 1-5

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.

Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.

Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor.

Then, review the email, and the Customer Survey and Historical Sales datasets.

To use the templates for the datasets, click the links below and select “Use Template.”

Links to templates: Customer Survey and Historical Sales

OR

If you don't have a Google account, you can download the CSV files directly from the attachments below.

1. CustomerSurvey
2. HistoricalSales

After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. You email your supervisor to ask. When writing your email, what do you do to ensure it sounds professional? Select all that apply.

• Write a clear subject line that gets a fast response so you can keep working: “WHM? NEED TO KNOW WHAT THAT IS RIGHT AWAY.”
• Respect your supervisor’s time by writing an email that’s short and to the point.
• Use a polite greeting and closing.
• Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear.

Question 2

Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The qualitative data includes information from which columns? Select all that apply.

• Column F (Survey Q6: What types of books would you like to see more of at Athena's Story?)
• Column B (Survey Q2: If answered "Yes" to Q1, how do you plan to celebrate?)
• Column E (Survey Q5: What do you like most about Athena's Story?)
• Column D (Survey Q4: If answered "Yes" to Q3, how many books do you typically purchase during March?)

Question 3

Scenario 1 continued

Next, you review the customer feedback in column F of the Customer Survey dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.

Your visualization looks like this:

Pie chart categories:

Feminist science fiction 4.8%

Books about women 2.4%

Women's journals 2.4%

Feminist literary criticism 2.4%

Children's literature 15.5%

Women's history books 2.4%

Biographies of inspiration 20.2%

Feminist fiction 26.2%

Feminist zines 14.3%

Feminist poetry 4.6%

Feminist novels 3.6%

What is a pie chart effective for demonstrating?

A. Percentages that make up a whole

B. Where things are located on a map

C. Trends over time

D. Relationships between variables

The correct answer is A. Percentages that make up a whole

Question 4

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Historical Sales

If you don't have a Google account, you can download the CSV file directly from the attachment below.

You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.

Next, you calculate the total sales over 52 weeks for children’s literature. What is the correct syntax?

A. =COUNT(D2:D53)

B. =CALCULATE(D2:D53)

C. =SUM(D2:D53)

D. =MAX(D2:D53)

The correct syntax is =SUM(D2:D53)

Question 5

Scenario 1 continued

After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.

In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.

Using historical data to make informed decisions about how things may be in the future is an example of spotting something unusual. True or False?

A. True

B. False

Question 6

Scenario 2, questions 6-10

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below:

Junior Data Analyst Job Description

So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below:

Human Resources Director Email

You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview.

First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below:

Patel Event Plus Org Chart

As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy.

Based on what you find in the organizational chart, which individuals are considered the secondary stakeholders? Select all that apply.

• Chief executive officer
• Vice president, data and strategy
• Data analytics coordinator
• Project manager, analytics

I don't know

Question 7

Scenario 2 continued

Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.

Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.

• How would you describe your event experience?
• Would you recommend Patel Events Plus to a colleague or friend? Yes or no?
• Why did you enjoy the event planned by Patel Events Plus?
• On a scale from 1 to 5, with 1 being not at all likely and 5 being very likely, how likely are you to recommend Patel Events Plus?

Question 8

Scenario 2 continued

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question.

You’re working on a rush project, and you discover your dataset is not clean. Even though it has numerous nulls, redundant data, and other issues, the primary stakeholder insists that you move ahead and use it anyway. The project timeline is so tight that there simply isn’t enough time for cleaning. How would you handle that situation?

A. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

B. The stakeholder is in charge. It's best to do as they say and use the unclean dataset.

C. Clean the data as quickly as you can. It’s not perfect, but it’s better than it was before, and this way you can meet the deadline.

D. Contact the stakeholder’s boss to let them know about the issue and ask for help managing the stakeholder’s expectations.

The correct answer is A. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

Question 9

Scenario 2 continued

Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question. Select all that apply.

Let’s say you’ve designed a dashboard to give stakeholders easy, automatic access to data about an upcoming event. Describe the benefits of using a dashboard. Select all that apply.

• Dashboards present pre-cleaned, historical data.
• Dashboards enable stakeholders to interact with the data.
• Dashboards offer live monitoring of incoming data.
• Dashboards are easy to design and understand.

Question 10

Scenario 2 continued

Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.

To use the template for this dataset, click the link below and select “Use Template.”

Link to template: Patel Events Data

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to compare the purchase price (cost) and net profit, what would you be calculating?

A. Metric goal

B. Return on investment

C. Occupancy rate

D. Sales numbers

The correct answer is B. Return on investment

3rd time

Question 1

Scenario 1, questions 1-5

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.

Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.

Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor.

Then, review the email, and the Customer Survey and Historical Sales datasets.

To use the templates for the datasets, click the links below and select “Use Template.”

Links to templates: Customer Survey and Historical Sales

OR

If you don't have a Google account, you can download the CSV files directly from the attachments below.

1. CustomerSurvey
2. HistoricalSales

After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. How do you proceed?

A. Call the client to ask what WHM means and inform them that using acronyms is not a professional business practice.

B. Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

C. Schedule a meeting with your supervisor, the client, and another analyst on your team to figure out the meaning.

D. Proceed with the project assuming WHM must mean web host manager.

The correct answer is B. Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

Question 2

Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The qualitative data includes information from which columns? Select all that apply.

• Column B (Survey Q2: If answered "Yes" to Q1, how do you plan to celebrate?)
• Column D (Survey Q4: If answered "Yes" to Q3, how many books do you typically purchase during March?)
• Column E (Survey Q5: What do you like most about Athena's Story?)
• Column F (Survey Q6: What types of books would you like to see more of at Athena's Story?)

Question 3

Scenario 1 continued

Next, you review the customer feedback in column F of the Customer Survey dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.

Your visualization looks like this:

Pie chart categories:

Feminist science fiction 4.8%

Books about women 2.4%

Women's journals 2.4%

Feminist literary criticism 2.4%

Children's literature 15.5%

Women's history books 2.4%

Biographies of inspiration 20.2%

Feminist fiction 26.2%

Feminist zines 14.3%

Feminist poetry 4.6%

Feminist novels 3.6%

The chart you create demonstrates the percentages of each book genre that make up the whole. It’s called an area chart.

A. True

B. False

It is false statement.

Question 4

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Historical Sales

If you don't have a Google account, you can download the CSV file directly from the attachment below.

You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.

Next, you calculate the total sales over 52 weeks for feminist zines. What is the correct syntax?

A. =CALCULATE(E2:E53)

B. =SUM(E2:E53)

C. =COUNT(E2:E53)

D. =MAX(E2:E53)

the correct syntax is =SUM(E2:E53)

Question 5

Scenario 1 continued

After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.

In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.

Using historical data to make informed decisions about how things may be in the future is an example of making predictions.

A. True

B. False

It is false statement

Question 6

Scenario 2, questions 6-10

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below:

Junior Data Analyst Job Description

So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below:

Human Resources Director Email

You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview.

First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below:

Patel Event Plus Org Chart

As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy.

Based on what you find in the organizational chart, who should be considered the primary stakeholder for projects involving data and strategy?

A. Vice president

B. Chief executive officer

C. Project manager

D. Director

The correct answer is A. Vice president

Question 7

Scenario 2 continued

Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.

Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.

• Was this your first time using Patel Events Plus to plan your event? Yes or no?
• How would you rate your overall experience — poor, average, above average, or excellent?
• Why did our event options and features create a successful event?
• Did you experience any problems with your event? Yes or no?

Question 8

Scenario 2 continued

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question.

You’re working on a rush project, and you discover your dataset is not clean. Even though it has numerous nulls, redundant data, and other issues, the primary stakeholder insists that you move ahead and use it anyway. The project timeline is so tight that there simply isn’t enough time for cleaning. How would you handle that situation?

A. Email your supervisor to let them know the associate data analyst did not complete their assigned task.

B. Contact the data analytics coordinator and insist they clean the dataset immediately so you don’t miss your project deadline.

C. Communicate with the data analytics coordinator about the issue and offer to work together to clean the data so the project doesn’t fall behind.

D. Call a formal meeting with the data analytics team to solve the problem. Do not invite the associate data analyst, as they clearly don’t have time to help.

The correct answer is C. Communicate with the data analytics coordinator about the issue and offer to work together to clean the data so the project doesn’t fall behind.

Question 9

Scenario 2 continued

Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question.

Let’s say you want to share information about an upcoming event with stakeholders. It’s important that they’re able to access and interact with the data in real time. Would you create a report or a dashboard?

A. Report

B. Dashboard

I would to create a dashboard.

Question 10

Scenario 2 continued

Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.

To use the template for this dataset, click the link below and select “Use Template.”

Link to template: Patel Events Data

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, the metrics to consider would be the cost of the investment and what else?

A. 2019 events held at new venue

B. Purchase date

C. Average event revenues

D. Net profit in 2019

The correct answer is D. Net profit in 2019

4th times

Question 1

Scenario 1, questions 1-5

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.

Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.

Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor.

Then, review the email, and the Customer Survey and Historical Sales datasets.

To use the templates for the datasets, click the links below and select “Use Template.”

Links to templates: Customer Survey and Historical Sales

OR

If you don't have a Google account, you can download the CSV files directly from the attachments below.

1. CustomerSurvey
2. HistoricalSales

After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. You email your supervisor to ask. When writing your email, what do you do to ensure it sounds professional? Select all that apply.

• Write a clear subject line that gets a fast response so you can keep working: “WHM? NEED TO KNOW WHAT THAT IS RIGHT AWAY.”
• Respect your supervisor’s time by writing an email that’s short and to the point.
• Use a polite greeting and closing.
• Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear.

Question 2

Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The data in column F (Survey Q6: What types of books would you like to see more of at Athena's Story?) is quantitative.

A. True

B. False

It is false statement.

Question 3

Scenario 1 continued

Next, you review the customer feedback in column F of the Customer Survey dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.

Your visualization looks like this:

Pie chart categories:

Feminist science fiction 4.8%

Books about women 2.4%

Women's journals 2.4%

Feminist literary criticism 2.4%

Children's literature 15.5%

Women's history books 2.4%

Biographies of inspiration 20.2%

Feminist fiction 26.2%

Feminist zines 14.3%

Feminist poetry 4.6%

Feminist novels 3.6%

Fill in the blank: The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a _____ chart.

A. area

B. doughnut

C. bubble

D. pie

It’s called a pie chart.

Question 4

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Historical Sales

If you don't have a Google account, you can download the CSV file directly from the attachment below.

You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.

Next, you calculate the total sales over 52 weeks for feminist zines. You type =CALCULATE(E2-E53) but get an error. What is the correct syntax?

A. =COUNT(D2:D53)

B. =CALC(E2:E53)

C. =MAX(E2:E53)

D. =SUM(E2:E53)

The correct syntax is =SUM(D2:D53)

Question 5

Scenario 1 continued

After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.

In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.

Using historical data to make informed decisions about how things may be in the future is an example of making predictions.

A. True

B. False

It is false statement.

Question 6

Scenario 2, questions 6-10

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below:

Junior Data Analyst Job Description

So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below:

Human Resources Director Email

You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview.

First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below:

Patel Event Plus Org Chart

As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy.

Based on what you find in the organizational chart, which of the stakeholders are responsible for managing the data? Select all that apply.

• Data analytics coordinator
• Junior data analyst
• Chief executive officer
• Vice president, data and strategy

Question 7

Scenario 2 continued

Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.

Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.

• On a scale from 1 to 5, with 1 being not at all likely and 5 being very likely, how likely are you to recommend Patel Events Plus?
• Would you recommend Patel Events Plus to a colleague or friend? Yes or no?
• How would you describe your event experience?
• Why did you enjoy the event planned by Patel Events Plus?

Question 8

Scenario 2 continued

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question.

You’re working on a rush project, and you discover your dataset is not clean. Even though it has numerous nulls, redundant data, and other issues, the primary stakeholder insists that you move ahead and use it anyway. The project timeline is so tight that there simply isn’t enough time for cleaning. How would you handle that situation?

A. Contact the stakeholder’s boss to let them know about the issue and ask for help managing the stakeholder’s expectations.

B. Clean the data as quickly as you can. It’s not perfect, but it’s better than it was before, and this way you can meet the deadline.

C. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

D. The stakeholder is in charge. It's best to do as they say and use the unclean dataset.

The correct answer is C. Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.

Question 9

Scenario 2 continued

Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question. Select all that apply.

Let’s say you’ve designed a dashboard to give stakeholders easy, automatic access to data about an upcoming event. Describe the benefits of using a dashboard. Select all that apply.

• Dashboards offer live monitoring of incoming data.
• Dashboards enable stakeholders to interact with the data.
• Dashboards present pre-cleaned, historical data.
• Dashboards are easy to design and understand.

Question 10

Scenario 2 continued

Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.

To use the template for this dataset, click the link below and select “Use Template.”

Link to template: Patel Events Data

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, the metrics to consider would be the cost of the investment and what else?

A. 2019 events held at new venue

B. Average event revenues

C. Net profit in 2019

D. Purchase date

The correct answer is C. Net profit in 2019

5th times

Question 1

Scenario 1, questions 1-5

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.

Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.

Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor.

Then, review the email, and the Customer Survey and Historical Sales datasets.

To use the templates for the datasets, click the links below and select “Use Template.”

Links to templates: Customer Survey and Historical Sales

OR

If you don't have a Google account, you can download the CSV files directly from the attachments below.

1. CustomerSurvey
2. HistoricalSales

After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. How do you proceed?

A. Schedule a meeting with your supervisor, the client, and another analyst on your team to figure out the meaning.

B. Proceed with the project assuming WHM must mean web host manager.

C. Call the client to ask what WHM means and inform them that using acronyms is not a professional business practice.

D. Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

The correct answer is D. Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

Question 2

Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The data in column F (Survey Q6: What types of books would you like to see more of at Athena's Story?) is quantitative. True or False?

A. True

B. False

It is false statement

Question 3

Scenario 1 continued

Next, you review the customer feedback in column F of the Customer Survey dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Customer Survey

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.

Your visualization looks like this:

Pie chart categories:

Feminist science fiction 4.8%

Books about women 2.4%

Women's journals 2.4%

Feminist literary criticism 2.4%

Children's literature 15.5%

Women's history books 2.4%

Biographies of inspiration 20.2%

Feminist fiction 26.2%

Feminist zines 14.3%

Feminist poetry 4.6%

Feminist novels 3.6%

Fill in the blank: The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a _____ chart.

A. doughnut

B. pie

C. area

D. bubble

The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a pie chart.

Question 4

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.

To use the template for the dataset, click the link below and select “Use Template.”

Link to template: Historical Sales.

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.

Next, you calculate the total sales over 52 weeks for children’s literature. What is the correct syntax?

A. =CALCULATE(D2:D53)

B. =MAX(D2:D53)

C. =COUNT(D2:D53)

D. =SUM(D2:D53)

The correct syntax is =SUM(D2:D53)

Question 5

Scenario 1 continued

After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.

In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.

Using historical data to make informed decisions about how things may be in the future is an example of spotting something unusual. True or False?

A. True

B. False

It is false statement

Question 6

Scenario 2, questions 6-10

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below:

Junior Data Analyst Job Description

So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below:

Human Resources Director Email

You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview.

First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below:

Patel Event Plus Org Chart

As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Secondary stakeholders are also typically responsible for managing the data.

Based on what you find in the organizational chart, which of the stakeholders are responsible for managing the data? Select all that apply.

• Junior data analyst
• Data analytics coordinator
• Vice president, data and strategy
• Chief executive officer

Question 7

Scenario 2 continued

Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.

Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.

• Did you experience any problems with your event? Yes or no?
• How would you rate your overall experience — poor, average, above average, or excellent?
• Was this your first time using Patel Events Plus to plan your event? Yes or no?
• Why did our event options and features create a successful event?

Question 8

Scenario 2 continued

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question.

You’re working with a dataset that the data analytics coordinator should have cleaned, but it turns out that it wasn’t. Your supervisor thought the dataset was ready for use, but you discover nulls, redundant data, and other issues. The project is due in less than two weeks. How would you handle that situation?

A. Contact the data analytics coordinator and insist they clean the dataset immediately so you don’t miss your project deadline.

B. Email your supervisor to let them know the associate data analyst did not complete their assigned task.

C. Call a formal meeting with the data analytics team to solve the problem. Do not invite the associate data analyst, as they clearly don’t have time to help.

D. Communicate with the data analytics coordinator about the issue and offer to work together to clean the data so the project doesn’t fall behind.

The correct answer is D. Communicate with the data analytics coordinator about the issue and offer to work together to clean the data so the project doesn’t fall behind.

Question 9

Scenario 2 continued

Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question.

Let’s say you want to share information about an upcoming event with stakeholders. It’s important that they’re able to access and interact with the data in real time. Would you create a report or a dashboard?

A. Dashboard

B. Report

I want to create a dashboard

Question 10

Scenario 2 continued

Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.

To use the template for this dataset, click the link below and select “Use Template.”

Link to template: Patel Events Data

OR

If you don't have a Google account, you can download the CSV file directly from the attachment below.

Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, the metrics to consider would be the cost of the investment and what else?

A. Purchase date

B. Net profit in 2019

C. 2019 events held at new venue

D. Average event revenues

The correct answer is B. Net profit in 2019