Ask Questions to Make Data-Driven Decisions - Always Remember the Stakeholder

Course 2 – Ask Questions to Make Data-Driven Decisions Quiz Answers

Week 4: Always Remember the Stakeholder

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

Ask Questions to Make Data-Driven Decisions wEEK 2 INTRODUCTION

In this week in Coursera Google Data Analytics Course, you will learn important strategies to manage stakeholder expectations while developing clear communication with your team. Always remember the stakeholder when making decisions and providing reports about data analysis. It is crucial to consider their needs and expectations to ensure success in any project. This course will equip you with the skills needed to successfully balance different stakeholders’ needs and create a positive outcome. You’ll also learn how to communicate effectively with your team members so that everyone understands the purpose and goals of each project. By mastering these techniques, you can be assured that all stakeholders are satisfied with the results of your data analysis efforts. With proper management of stakeholder expectations, you can guarantee successful projects time and time again.

Learning Objectives

  • Discuss communication best practices for the data analyst including reference to office communication, conflict resolution, facilitating meetings, and status reports
  • Discuss the importance of focus on stakeholder expectations
  • Identify common limitations with data, with specific reference to speed versus accuracy and responding to time-sensitive requests

Test your knowledge on balancing team and stakeholders needs

1. As a data analyst, it’s important to communicate often. Sharing detailed notes and creating reports are ways to communicate with the people who have invested time and resources in a project. Who are these people?

  • Stakeholders (Correct)
  • Executives
  • Subject-matter experts
  • Customer-facing team

Correct: Stakeholders invest time and resources into a project. Sharing detailed notes and creating reports are useful ways to keep them up-to-date.

2. The customer-facing team does which of the following activities? Select all that apply.

  • Tell the data story to others.
  • Share customer feedback. (Correct)
  • Provide operational leadership for the company.
  • Compile information about customer expectations. (Correct)

Correct: The customer-facing team compiles information, shares feedback, and sets expectations.

3. The human resources director approaches a data analyst to propose a new data analysis project. The analyst has a lot of experience in human resources and believes the director is taking the wrong approach, and it will lead to some problems. Select the data analyst’s best course of action.

  • Complete the project as requested, but set aside some time in the future to fix the problems that are sure to come up.
  • Respectfully explain their viewpoints and offer the director some additional information to help improve the project. (Correct)
  • Politely explain that they’re too busy to take on another project at this time.
  • Tell the director that they’re very sorry, but they can’t work on the project.

Correct: The analyst should respectfully explain their viewpoints and offer the director some additional information to help improve the project.

Test your knowledge on Clear communication

1. To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. The first is: Who is my audience? Identify the remaining three questions. Select all that apply.

  • How can I communicate effectively to my audience? (Correct)
  • Why are stakeholders and team members important?
  • What does my audience already know? (Correct)
  • What does my audience need to know? (Correct)

Correct: The four key questions data analysts ask themselves when communicating with stakeholders are: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them?

2. A colleague sent you a question via email nearly two days ago. You know it’s going to take a while for you to find the answer because you need to do some research first. You’re too busy to get it done today. What’s the best course of action?

  • Respond right away with your best guess to the answer of their question. The sender has been waiting nearly 48 hours, and any response is better than nothing.
  • Reply with a quick update thanking the sender for their patience and letting them know when they can expect you to respond with the answer to their question. (Correct)
  • Delete the email. By the time you’re able to answer the question, it won’t be helpful information anyway.
  • Forward the email to the entire data analytics team, and ask if someone else can answer the question for you.

Correct: The best course of action is to reply with a quick update thanking the sender for their patience and letting them know when they can expect you to respond with the answer to their question.

3. Focusing on stakeholder expectations enables data analysts to achieve what goals? Select all that apply.

  • Build trust (Correct)
  • Improve communication among teams (Correct)
  • Multitask more effectively
  • Understand project goals (Correct)

Correct: Focusing on stakeholder expectations enables data analysts to understand project goals, improve communication, and build trust.

4. A stakeholder has asked a data analyst to produce a report very quickly. What are some strategies the analyst can apply to ensure their work isn’t rushed, answers the right question, and delivers useful results? Select all that apply.

  • Outline the problem (Correct)
  • Work overtime to get the report done by the following day
  • Set clear expectations about timeframe (Correct)
  • Reframe the question (Correct)

Correct: To ensure their work answers the right questions and delivers useful results, the data analyst should set clear expectations, outline the problem, and reframe the question.

5. Asking questions including, “Does my analysis answer the original question?” and “Are there other angles I haven’t considered?” enable data analysts to accomplish what tasks? Select all that apply.

  • Use data to get to a solid conclusion. (Correct)
  • Help their team make informed, data-driven decisions. (Correct)
  • Consider the best ways to share data with others. (Correct)
  • Identify primary and secondary stakeholders.

Correct: Asking questions such as these enables data analysts to consider the best ways to share data with others, help their team make informed decisions, and use data to get to a solid conclusion.

Test your knowledge on teamwork

1. Your supervisor gives you a new data analysis project with unclear instructions, and you become frustrated trying to figure out how to proceed. Which actions you can take next demonstrate a responsibility to move the project forward? Select all that apply.

  • Find your supervisor in person so they can clearly observe how frustrated you are.
  • Do some additional research to better understand the context of the request. (Correct)
  • Send your supervisor an email letting them know they did not explain the project well.
  • Schedule a time to ask your supervisor more questions about the big picture goals. (Correct)

Correct: Doing additional research and asking questions are effective ways to determine how to proceed with a new project.

2. You’re working on a data analysis project with a coworker, and the two of you disagree on what the data is telling you. Things get tense. The best course of action is to go to your supervisor and politely explain that your coworker is looking at the data incorrectly. Then, ask to work with a different coworker on future projects.

  • True
  • False (Correct)

Correct: Discussion is the key to conflict resolution. If you find yourself in the middle of a conflict, start a conversation so you can each explain your concerns and figure out the best path forward.

3. A director emails you asking for a report by the end of the week. This type of report takes at least 10 days to complete correctly. What is the best course of action?

  • Call the director, and let them know there’s no way anyone could possibly meet that deadline.
  • Complete the report as best you can by the end of the week so you meet the requested deadline.
  • Forward the email to another data analyst on your team, and ask them to do the report instead. It’ll still be late, but at least it won’t reflect poorly on you.
  • Email the director and say that you would be happy to do that, but you believe it will take 10 days to get the information you need. Then, ask if you can discuss the possibility of a different timeline. (Correct)

Correct: The best course of action is to email the director to politely explain the timeline required to complete the report properly.

ask questions to make data-driven decisions weekly challenge 4

1. A data analyst starts a new project for the operations team at their company. They take a few hours at the beginning of the project to identify their stakeholders. The secondary stakeholders are most likely which of the following people? Select all that apply.

  • The data analyst (Correct)
  • The vice president of operations
  • The project manager (Correct)
  • The president of the company

Correct: The secondary stakeholders are most likely the data analyst and the project manager.

2. At an online marketplace, the _____ includes anyone in an organization who interacts with current or potential shoppers.

  • executive team
  • data science team
  • project management team
  • customer-facing team (Correct)

Correct: At an online marketplace, the customer-facing team includes anyone in an organization who interacts with current or potential shoppers.

3. There are four key questions data analysts ask themselves: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them? These questions enable data analysts to achieve what goal?

  • Identify primary and secondary stakeholders
  • Communicate clearly with stakeholders and team members (Correct)
  • Understand who is managing the data
  • Complete data analysis projects on time

Correct: These questions enable data analysts to communicate clearly with stakeholders and team members.

4. A data analyst feels overworked. They often stay late to finish work, and have started missing deadlines. Their supervisor emails them another project to complete, and this causes the analyst even more stress. How should they handle this situation?

  • Walk into the supervisor’s office and tell them to give the project to someone else.
  • Accept the new project right away and hope to not miss another deadline.
  • Wait a few minutes to think it over, then respond with a meeting request to discuss this project and the general workload. (Correct)
  • Respond immediately, letting the supervisor know the expectations at this company are unreasonable.

Correct: They should wait a few minutes to think it over, then respond with a meeting request to discuss this project and the general workload. When people are feeling angry or emotional, it’s best to wait until things calm down. Then, give everyone the opportunity to share their perspectives.

5. To make sure that a few unusual responses don’t skew results or lead to inaccurate judgments, a data analyst focuses on what element of the data collection?

  • Visualization
  • Sample size (Correct)
  • Data cleaning
  • Statistical significance

Correct: To make sure a few unusual responses don’t skew results or lead to inaccurate judgments, a data analyst focuses on sample size.

6. A data analyst has been invited to a meeting. They review the agenda and notice that their data analysis project is one of the topics that will be discussed. How can they prepare for an effective meeting? Select all that apply.

  • Plan to arrive on time. (Correct)
  • Create and share a revised agenda that includes many more details about their project.
  • Bring materials for taking notes. (Correct)
  • Think about what project updates they should share. (Correct)

Correct: They can prepare for an effective meeting by arriving on time, bringing materials to take notes with, and considering what project updates to share.

7. A data analyst joins an online meeting on time. After reviewing the agenda, they see that their project comes at the very end. They’re extremely busy and can use this time to stay on top of their current projects. How should they proceed?

  • Mute themselves and turn off the camera, then continue working on other tasks until their project is mentioned.
  • Stay focused and attentive during the entire meeting. Even though some items on the agenda don’t affect their projects, they could still learn something or have something to contribute. (Correct)
  • Politely let the presenter know they’re going to leave the meeting and rejoin toward the end.
  • Tell the participants that they’re having technical trouble, then leave the meeting to continue working on other tasks.

Correct: They should stay focused and attentive during the entire meeting. Listening and learning from others are great ways to learn about your company, its challenges, and its goals.

8. Conflict is a natural part of working on a team. What are some ways to help shift a situation from problematic to productive? Select all that apply.

  • Identify the person who caused the issue so they can take responsibility.
  • Take a moment to check your emotions before engaging in an argument. (Correct)
  • Reframe the question by asking, “How can I help?” (Correct)
  • Ask for a conversation to help you better understand the big picture. (Correct)

Correct: To help shift a situation from problematic to productive, reframe the question, keep your emotions in check, and establish open lines of communication.

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Liking our content? Then don’t forget to add us to your bookmarks so you can find us easily!

Weekly Breakdown | Google Study Guides | Back to Top

Ask Questions to Make Data-Driven Decisions Course Challenge

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.

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. Still, you should assume it’s correct and continue with the project.

  • True
  • False (Correct)

Correct: Asking questions is a very important part of data analysis. The best course of action is to send your boss a polite, concise email, asking for the meaning of WHM.

2. Scenario 1 continued

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
  • False (Correct)

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

3. Scenario 1 continued

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 titled Count of Survey Q6: What types of books wold you like to see more of at Athena's Story?
Pie Chart

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

  • True
  • False (Correct)

Correct: It’s called a pie chart. Pie charts are effective at demonstrating the percentages of a whole, such as the percentage of customers who would be interested in purchasing books of different genres.

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.

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?

  • =CALCULATE(D2:D53)
  • =SUM(D2:D53) (Correct)
  • =MAX(D2:D53)
  • =COUNT(D2:D53)

Correct: The correct syntax is =SUM(D2:D53). The SUM function adds the values of a range of cells. D2:D53 is the specified range.

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.

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

  • Spotting something unusual
  • Making predictions (Correct)
  • Discovering connections
  • Identifying themes

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

6. Scenario 2, questions 6-10

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 secondary stakeholders are responsible for managing the data? Select all that apply.

  • Project manager, strategy
  • Data analytics coordinator (Correct)
  • Project manager, analytics
  • Junior data analyst (Correct)

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.

  • 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? (Correct)
  • Would you recommend Patel Events Plus to a colleague or friend? Yes or no? (Correct)
  • Why did you enjoy the event planned by Patel Events Plus?
  • How would you describe your event experience?

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include a 1-to-5 scale or questions with yes-or-no responses.

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?

  • 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.
  • Contact the data analytics coordinator and insist they clean the dataset immediately so you don’t miss your project deadline.
  • 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. (Correct)
  • Email your supervisor to let them know the associate data analyst did not complete their assigned task.

Correct: This situation present an opportunity to communicate, collaborate, and foster positive working relationships

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 created a report to present stakeholders with information about an upcoming event. Describe the benefits of using a report.

  • Reports offer live monitoring of incoming data.
  • Reports provide a snapshot of high-level, historical data. (Correct)
  • Reports reflect data that’s already been cleaned and sorted. (Correct)
  • Reports enable stakeholders to interact with the data.

Correct: Stakeholders invest time and resources into a project. Sharing detailed notes and creating reports are useful ways to keep them up-to-date.

10. Scenario 2 continued

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

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, which metrics would you use?

  • 2019 events held at new venue (column D)
  • Purchase price (column C)
  • Net profit in 2019 (column F) (Correct)
  • Purchase date

Correct: Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

10. A data analytics team is working on a project to measure the success of a company’s new financial strategy. Select the person most likely to be the primary stakeholder for this project.

  • The vice president of finance (CORRECT)
  • The data analyst
  • The project manager
  • The director of analytics

Correct: The primary stakeholder of this project is likely to be the vice president of finance, who can use this project’s findings to create an effective strategy for the future. 

11. A data analyst is researching the buying behavior of people who shop at a company’s retail store and those who might shop there in the future. During the analysis, it will be important to stay in communication with the team that most often interacts with these shoppers. What is the name of this team?

  • Executive team
  • Customer-facing team (CORRECT)
  • Data science team
  • Project management team

Correct: The customer-facing team includes anyone in an organization who interacts with customers or potential customers, such as the shoppers at a company’s retail store.

12. There are four key questions data analysts ask themselves: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them? These questions enable data analysts to identify the person in charge of managing the data.

  • True
  • False (CORRECT)

Correct: These questions enable data analysts to communicate clearly with stakeholders and team members.

13.  Data analysts pay attention to sample size in order to achieve what goals? Select all that apply.

  • To fully understand the scope of the analytics project
  • To avoid a small sample size leading to inaccurate judgements (CORRECT)
  • To make sure the data represents a diverse set of perspectives (CORRECT)
  • To make sure a few unusual responses don’t skew results (CORRECT)

Correct: Data analysts pay attention to sample size in order to represent a diverse set of perspectives and avoid skewed results or inaccurate judgements.

Correct: Data analysts pay attention to sample size in order to represent a diverse set of perspectives and avoid skewed results or inaccurate judgements.

Correct: Data analysts pay attention to sample size in order to represent a diverse set of perspectives and avoid skewed results or inaccurate judgements.

14. A data analyst receives an email from the vice president of marketing. The vice president is upset because the report they want from the analyst is late. Select the best course of action.

  • The analyst should call the vice president and ask them how important it really is to their marketing efforts. 
  • The analyst should apologize for the delay and inform the vice president that the marketing managers caused the delay. 
  • The analyst should send the report immediately, even if it’s not completely finished. This will make the vice president happy.
  • The analyst should respond saying they understand the vice president’s concerns, provide a status update, and let the vice president know when to expect the completed report. (CORRECT)

Correct: The analyst should respond saying they understand the vice president’s concerns, provide a status update, and let the vice president know when to expect the completed report. This shows the vice president that their concerns are understood and provides a status update.

15.  Arriving at meetings prepared is an important part of creating a professional work environment. This involves which of the following actions? Select all that apply.

  • Bringing a laptop to keep an eye on emails
  • Bringing materials to take notes with (CORRECT)
  • Considering what questions you may be asked so you’re prepared to answer (CORRECT)
  • Reading the meeting agenda ahead of time (CORRECT)

Correct: Arriving at meetings prepared involves reading the agenda ahead of time, bringing materials to take notes with, and considering what questions you may be asked so you’re prepared to answer.

Correct: Arriving at meetings prepared involves reading the agenda ahead of time, bringing materials to take notes with, and considering what questions you may be asked so you’re prepared to answer.

Correct: Arriving at meetings prepared involves reading the agenda ahead of time, bringing materials to take notes with, and considering what questions you may be asked so you’re prepared to answer.

16. A team member has asked you to take on a task, and you don’t understand the point of the project. It seems like it will be a waste of your time. The best course of action would be to politely explain your concerns and decline the project.

  • True
  • False (CORRECT)

Correct: When you don’t understand the full context of a request, ask questions about the project goal, its data story, and the big picture vision.

17.  Data analysts focus on statistical significance to make sure they have enough data so that a few unusual responses don’t skew results. 

  • True
  • False (CORRECT)

Correct: Data analysts focus on sample size to make sure they have enough data so that a few unusual responses don’t skew results.

18. A data analyst has been invited to a meeting. They review the agenda and notice that their data analysis project is one of the topics that will be discussed. They plan to arrive on time and have a pen and paper to take notes. But they do not spend time considering project updates they could share or questions they may be asked. This is appropriate because they’re not the one running the meeting.

  • True
  • False (CORRECT)

Correct: Even if the data analyst isn’t running the meeting, if their project is on the agenda, it’s a good idea to prepare to share updates and answer questions. This helps keep everyone informed and ensures effective communication.

19. When participating in an online meeting, it’s okay to keep your inbox open in another browser window. Participants won’t be distracted because they can’t see it, and you might receive a very important message.

  • True
  • False (CORRECT)

Correct: When participating in an online meeting, it’s important to eliminate distractions, such as checking your email. This shows respect to the other participants.

20. Fill in the blank: A data analytics team is working on a project to measure the success of a company’s new financial strategy. The vice president of finance is most likely to be the _____. 

  • project manager
  • analyst
  • primary stakeholder (CORRECT)
  • secondary stakeholder

Correct: The vice president of finance is most likely to be the primary stakeholder.

21.  A data analyst is researching the buying behavior of people who shop at a company’s retail store and those who might shop there in the future. During the analysis, it will be important to stay in communication with the people who most often interact with these shoppers. They are members of the executive team.

  • True
  • False (CORRECT)

Correct: These people are part of the customer-facing team. The customer-facing team includes anyone in an organization who interacts with customers or potential customers, such as the shoppers at a company’s retail store.

22.  Which of the following steps are key to leading a professional online meeting? Select all that apply.

  • Keeping an eye on your inbox during the meeting in case of an important email
  • Maintaining control of the meeting by keeping everyone else on mute.
  • Making sure your technology is working properly before starting the meeting (CORRECT)
  • Sitting in a quiet area that’s free of distractions (CORRECT)

Correct: When leading an online meeting, acting professionally involves encouraging others to contribute, testing technology beforehand, and eliminating distractions.

Correct: When leading an online meeting, acting professionally involves encouraging others to contribute, testing technology beforehand, and eliminating distractions.

23. You receive an angry email from a colleague on the marketing team. The marketing colleague believes you have taken credit for their work. You do not believe this is true. Select the best course of action.

  • Forward the email to the marketing director with an equally angry note.
  • Delete the email. It’s best not to create any additional conflict.
  • Walk over to the marketing colleague’s cubicle, and tell them you strongly disagree.
  • Reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives. (CORRECT)

Correct: You should reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives. When people are feeling angry or emotional, it’s best to wait until things calm down. Then, give everyone the opportunity to share their perspectives.

24. To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of them is: What does my audience need to know? Identify the remaining three questions. Select all that apply.

  • Why are stakeholders and team members important?
  • What does my audience already know? (CORRECT)
  • How can I communicate effectively to my audience? (CORRECT)
  • Who is my audience? (CORRECT)

Correct: The four key questions data analysts ask themselves when communicating with stakeholders are: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them?

Correct: The four key questions data analysts ask themselves when communicating with stakeholders are: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them?

Correct: The four key questions data analysts ask themselves when communicating with stakeholders are: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them?

*COURSE CHALLENGE*

1. Scenario 1, questions 1-13

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.

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?

  • Call the client to ask what WHM means and inform them that using acronyms is not a professional business practice. 
  • Proceed with the project assuming WHM must mean web host manager.
  • Schedule a meeting with your supervisor, the client, and another analyst on your team to figure out the meaning. 
  • Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM. (CORRECT)

Correct: You should send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

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 
  • False (CORRECT)

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

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 titled Count of Survey Q6: What types of books would you like to see more of at Athena's Story?

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.

  • doughnut
  • bubble
  • pie (CORRECT)
  • area

Correct: The visualization is called a pie chart.

4. 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 discovering connections.

  • True
  • False (CORRECT)

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

5. Scenario 1 continued

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. 

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. Still, you should assume it’s correct and continue with the project.

  • True 
  • False (CORRECT)

Correct: Asking questions is a very important part of data analysis. The best course of action is to send your boss a polite, concise email, asking for the meaning of WHM.

6. 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 titled Count of Survey Q6: What types of books would you like to see more of at Athena's Story?

What is a pie chart effective for demonstrating?

  • Where things are located on a map 
  • Percentages that make up a whole (CORRECT)
  • Relationships between variables
  • Trends over time

Correct: Pie charts are effective at demonstrating the percentages of a whole, such as the percentage of customers who would be interested in purchasing books of different genres.

7. 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? 

  • =CALC(E2:E53) 
  • =COUNT(E2:E53) 
  • =SUM(E2:E53) (CORRECT)
  • =MAX(E2:E53)

Correct: The correct syntax is =SUM(E2:E53). The SUM function adds the values of a range of cells. E2:E53 is the specified range.

8. 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 titled Count of Survey Q6: What types of books would you like to see more of at Athena's Story?

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

  • True
  • False (CORRECT)

Correct: It’s called a pie chart. Pie charts are effective at demonstrating the percentages of a whole, such as the percentage of customers who would be interested in purchasing books of different genres.

9. 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?

  • Making predictions (CORRECT)
  • Spotting something unusual 
  • Discovering connections 
  • Identifying themes 

10. Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you continue reviewing the datasets. You notice that the Customer Survey dataset 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 quantitative data includes information from which columns? Select all that apply.

  • Column E (Survey Q5: What do you like most about Athena’s Story?)
  • Column A (Survey Q1: Do you plan to celebrate WHM?) (CORRECT)
  • Column C (Survey Q3: Do you purchase feminist books in honor of WHM, either for yourself or as a gift for someone else?) (CORRECT)
  • Column D (Survey Q4: If answered “Yes” to Q3, how many books do you typically purchase during March?) (CORRECT)

Correct: The quantitative data includes information from columns A, C, and D.

Correct: The quantitative data includes information from columns A, C, and D.

Correct: The quantitative data includes information from columns A, C, and D.

11. 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. 

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.”
  • Use a polite greeting and closing. (CORRECT)
    • Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear. (CORRECT)
  • Respect your supervisor’s time by writing an email that’s short and to the point. (CORRECT)

Correct: Professional emails use a polite greeting and closing, are free of typos, and are concise.

Correct: Professional emails use a polite greeting and closing, are free of typos, and are concise.

Correct: Professional emails use a polite greeting and closing, are free of typos, and are concise.

12. 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 identifying themes.

  • True
  • False (CORRECT)

13. Scenario 1 continued

Now that you know WHM stands for Women’s History Month, you continue reviewing the datasets. You notice that the Customer Survey dataset 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 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?) (CORRECT)
  • Column F (Survey Q6: What types of books would you like to see more of at Athena’s Story?) (CORRECT)
  • Column B (Survey Q2: If answered “Yes” to Q1, how do you plan to celebrate?) (CORRECT)

Correct: The qualitative data includes information from columns B, E, and F.

Correct: The qualitative data includes information from columns B, E, and F.

Correct: The qualitative data includes information from columns B, E, and F.

14. Scenario 2, questions 14-

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:

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: 

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:

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, if you need information from the secondary stakeholders, who can you ask? Select all that apply.

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

Correct: If you need information from the secondary stakeholders, you can ask the project manager and the data analytics coordinator.

Correct: If you need information from the secondary stakeholders, you can ask the project manager and the data analytics coordinator.

16. 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?

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.

  • 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. (CORRECT)
  • Contact the data analytics coordinator and insist they clean the dataset immediately so you don’t miss your project deadline.
  • Email your supervisor to let them know the associate data analyst did not complete their assigned task.
  • Correct: This situation presents an opportunity to communicate, collaborate, and foster positive working relationships.

17. 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.

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

Correct: Dashboards offer live monitoring of incoming data and enable stakeholders to interact with the data.

Correct: Dashboards offer live monitoring of incoming data and enable stakeholders to interact with the data.

18. Scenario 2 continued

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

To use the template for the 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?

  • Sales numbers
  • Metric goal
  • Occupancy rate
  • Return on investment (CORRECT)

Correct: Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

19. 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:

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: 

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:

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 secondary stakeholders are responsible for managing the data? Select all that apply.

  • Project manager, strategy
  • Project manager, analytics
  • Junior data analyst (CORRECT)
  • Data analytics coordinator (CORRECT)

Correct: The secondary stakeholders responsible for managing the data are the data analytics coordinator and junior data analyst.

Correct: The secondary stakeholders responsible for managing the data are the data analytics coordinator and junior data analyst.

20. 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. 

  • Why did you enjoy the event planned by Patel Events Plus?
  • How would you describe your event experience?
  • 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? (CORRECT)
  • Would you recommend Patel Events Plus to a colleague or friend? Yes or no? (CORRECT)

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include a 1-to-5 scale or questions with yes-or-no responses.

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include a 1-to-5 scale or questions with yes-or-no responses.

21. 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?

  • Contact the stakeholder’s boss to let them know about the issue and ask for help managing the stakeholder’s expectations
  • Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder. (CORRECT)
  • The stakeholder is in charge. It’s best to do as they say and use the unclean dataset.
  • 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.

Correct: This situation presents an opportunity to communicate, collaborate, and foster positive working relationships.

22. Scenario 2 continued

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

To use the template for the 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, which metrics would you use?

  • 2019 events held at new venue (column D)
  • Purchase date
  • Net profit in 2019 (column F) (CORRECT)
  • Purchase price (column C) (CORRECT)

Correct: Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

Correct: Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

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

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. Which of the following options would be an appropriate approach?

  • Proceed with the project using the available data. You don’t want to get the associate data analyst in trouble, and you don’t want to miss your deadline.
  • Provide your supervisor with a proposed revised timeline. Politely explain that you need some additional time to clean the data. (CORRECT)
  • Email your supervisor and the data analytics coordinator to communicate about the issue. Ask if you can meet to come up with a solution. (CORRECT)
  • Email the data analytics coordinator to ask if the two of you can work together to clean the data, as the project is on a tight timeline. (CORRECT)

Correct: This situation presents an opportunity to communicate, collaborate, and foster positive working relationships. 

Correct: This situation presents an opportunity to communicate, collaborate, and foster positive working relationships. 

Correct: This situation presents an opportunity to communicate, collaborate, and foster positive working relationships. 

24. 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?

  • Report
  • Dashboard (CORRECT)

Correct: Dashboards offer live monitoring of incoming data and enable stakeholders to interact with the data.

25. 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:

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: 

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:

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, if you need information from the primary stakeholder, who can you ask?

  • Vice president, data and strategy (CORRECT)
  • Chief executive officer 
  • Project manager, analytics
  • Director, strategy

Correct: If you need information from the primary stakeholder, you can ask the vice president of data and strategy.

26. 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.

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

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include questions with yes-or-no responses, a 1-to-5 scale, or those with ranked responses.

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include questions with yes-or-no responses, a 1-to-5 scale, or those with ranked responses.

Correct: In the SMART methodology, measurable questions can be quantified and assessed. This might include questions with yes-or-no responses, a 1-to-5 scale, or those with ranked responses.

27. 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 created a report to present stakeholders with information about an upcoming event. Describe the benefits of using a report.

  • Reports enable stakeholders to interact with the data.
  • Reports offer live monitoring of incoming data.
  • Reports reflect data that’s already been cleaned and sorted. (CORRECT)
  • Reports provide a snapshot of high-level, historical data. (CORRECT)

Correct: Reports provide a snapshot of high-level, historical data and reflect data that’s already been cleaned and sorted. 

Correct: Reports provide a snapshot of high-level, historical data and reflect data that’s already been cleaned and sorted.

28. A data analyst is working on a project for the marketing department. The vice-president of marketing wants to use the results of this project to inform future marketing strategies. What role is the vice-president serving in this project?

  • Secondary stakeholder
  • Client
  • Consultant
  • Primary stakeholder (CORRECT)

29. To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of the questions is: Who is my audience? Identify the remaining three questions? Select all that apply.

  • What does my audience already know? (CORRECT)
  • Why are stakeholders and team members important?
  • What does my audience need to know? (CORRECT)
  • How can I communicate effectively to my audience? (CORRECT)

30. A colleague of yours has difficulty with his workload. He comes to you often for assistance and is very appreciative of your help. However, helping him has made it difficult for you to manage your own work. How should you handle this?

  • Tell your colleague that you cannot spend this much time helping them.
  • Have your manager talk to your colleague so they stop requesting your help.
  • Go to your colleague’s manager and tell them that your colleague needs training. (INCORRECT)
  • Avoid your colleague until you get fully caught up on your work.

31. A data analyst is collecting a sample for their research. Unfortunately, they have a small sample size and no time to collect more data. What challenge might this present?

  • The data will represent the population.
  • Results can be skewed. (CORRECT)
  • Data manipulation will be more difficult.
  • The data will be difficult to analyze.

32. When leading a meeting, it is important to respect your team members’ time. What are some ways of doing this? Select all that apply.

  • Discuss work that does not impact the attendees.
  • Arrive to the meeting on time (CORRECT)
  • Be prepared to talk about your work (CORRECT)
  • Pay attention to what others are saying (CORRECT)

33. Your manager assigns you a project task, and you don’t understand the point of the project. What questions can you ask them to determine the objective? Select all that apply.

  • What do you have to do for this task?
  • What is their end goal? (CORRECT)
  • What is the story they want to tell? (CORRECT)
  • What is the big picture? (CORRECT)

34. A data analyst starts a new project for the operations team at their company. They take a few hours at the beginning of the project to identify their stakeholders. Which of the following people are most likely the secondary stakeholders? Select all that apply.

  • The vice president of marketing
  • The data analyst (CORRECT)
  • The president of the company
  • The project manager (CORRECT)

35. To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of the questions is: What does my audience already know? Identify the remaining three questions. Select all that apply.

  • What does my audience need to know? (CORRECT)
  • Who is my audience? (CORRECT)
  • Why are stakeholders and team members important?
  • How can I communicate effectively to my audience? (CORRECT)

36. Your manager assigns you a new project. You tell them that it should only take you a week to finish it. After beginning the project, you realize that it will actually take closer to two weeks to finish. What should you do?

  • Work as hard as possible on the project and hope that you can get it done on time.
  • Change the project so that some of the original objectives are met by week’s end.
  • Explain to your manager that the original time frame is not possible and discuss how to proceed. (CORRECT)
  • Finish what can be finished by the deadline and explain that there wasn’t enough time to do the rest.

37. A data analyst collects a large amount of data for their project to ensure that the data represents a diverse set of perspectives. What element of data collection does this describe?

  • Data cleaning
  • Visualization
  • Statistical significance
  • Sample size (CORRECT)

38. When attending an online meeting, what actions can you take to respect your colleagues’ time? Select all that apply.

  • Stay focused and attentive (CORRECT)
  • Be prepared to discuss your work (CORRECT)
  • Have participants arrive when they choose Ask questions when you need clarification (CORRECT)

39. Your data analytics team has been working on a project for a few weeks. You’re almost done, when your supervisor suddenly changes the business task. Everyone has to start all over again. You announce to the team that you’re going to say something to the supervisor about how unreasonable this is. What’s the best next step?

  • Go see your supervisor face-to-face and tell them why you’re so upset.
  • Insist that the entire data analytics team complain to your supervisor.
  • Take a few minutes to calm down, then ask your colleagues to share their perspectives so you can work together to determine the best next step. (CORRECT)
  • Write a polite, but strongly worded email to your supervisor.

40. You accept a new project from a high level stakeholder. After beginning the project, you find that you aren’t sure what you are supposed to do. How do you handle this?

  • Set up a meeting with the stakeholder to discuss the specific objectives they wanted. (CORRECT)
  • Determine the objectives that make the most sense and work towards those.
  • Ask a member of your team what was done on the last project and do the same.
  • Perform the standard analysis and present its insights.

41. A data analyst is collecting data. They decide to gather lots of data to make sure that a few unusual responses do not skew the results later in the process. What element of data collection does this describe?

  • Statistical significance
  • Data cleaning
  • Sample size (CORRECT)
  • Visualization

42. You are leading an online meeting to discuss the new project. What should you do before starting the meeting to make it effective? Select all that apply.

  • Ensure that essential team members attend (CORRECT)
  • Have them arrive when they choose
  • Send out an agenda for the meeting (CORRECT)
  • Ensure that all necessary technology works (CORRECT)

43. Your manager assigns you a project task, and you don’t understand the point of the project. The best course of action is to politely explain your concerns and decline the project.

  • True
  • False (CORRECT)

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

  • Chieft executive officer
  • Data analytics coordinator (CORRECT)
  • Director, datta analytics (CORRECT)
  • Project manager, analytics (CORRECT)

45. 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? (CORRECT)
  • How satisfied were you with our event planning service — dissatisfied, neutral, or satisfied? (CORRECT)
  • What did you most love about your event experience?
  • What problems did you experience with our events team?

46. A data analyst is working on a project for the marketing department. who are most likely considered the secondary stakeholders? select all that apply.

  • Chieft executive officer
  • Data analytics coordinator (CORRECT)
  • Director, datta analytics (CORRECT)
  • Project manager, analytics (CORRECT)

47. Fill in the blank: In order to build trust, data professionals focus on the expectations of _____, who are the people investing time, interest, and resources into the project.

  • administrators
  • data analysts
  • stakeholders (CORRECT)
  • subject-matter experts

Correct!

48. You are invited to a meeting. You review the agenda and notice that your data analysis project is one of the topics that will be discussed. What strategies should you use to prepare? Select all that apply.

  • Distribute a revised agenda that includes more details about your project.
  • Plan to arrive on time (CORRECT)
  • Think about what project updates you should share (CORRECT)
  • Bring materials for taking notes (CORRECT)

Correct!

49. A data team prepares to share insights with stakeholders. To ensure they communicate clearly, they follow best practices. Together, they consider four questions, including: Who is our audience? Identify the remaining three questions they should ask. Select all that apply.

  • Why are stakeholders important?
  • What does my audience already know? (CORRECT)
  • What does my audience need to know? (CORRECT)
  • How can I communicate effectively to my audience? (CORRECT)

Correct!

50. Recently, you have been feeling overworked. You often stay late to finish tasks and have started missing deadlines. Your supervisor gives you another project to complete, and this causes even more stress. How should you handle this situation?

  • Respond letting the supervisor know their expectations are unreasonable.
  • Accept the new project right away and work harder to hopefully not miss another deadline.
  • Walk into the supervisor’s office and politely tell them to give the project to someone else.
  • Wait a few minutes to think it over, then request a meeting to discuss the new project and your general workload. (CORRECT)

Correct!

51. You join an online meeting on time. After reviewing the agenda, you note that your project will be discussed at the very end. You are extremely busy and can use this time to stay on top of other projects. How should you proceed?

  • Stay focused and attentive during the entire meeting. Even though some items on the agenda don’t affect your projects, you could still learn something or have something to contribute. (CORRECT)
  • Mute yourself and turn off the camera, then continue working on other tasks until your project is mentioned.
  • Tell the participants that you are having technical trouble, then leave the meeting to continue working on other tasks.
  • Politely let the presenter know you’re going to leave the meeting and rejoin toward the end.

Correct!

52. A data analyst researches the buying behavior of people who shop at a company’s retail store. During the analysis, which team is most likely to offer helpful insight about what these shoppers like and do not like?

  • Customer-facing (CORRECT)
  • Data science
  • Executive
  • Project management

Correct!

53. A data analyst reframes a question. Then, they outline the problem, challenges, potential solutions, and timeframe. What goals are they trying to achieve? Select all that apply.

  • Provide reports more quickly
  • Balance speed with accuracy (CORRECT)
  • Put the data in context (CORRECT)
  • Communicate expectations (CORRECT)

Correct!

54. A data analyst works on an analysis project that was requested by the marketing department. Who are most likely to be the secondary stakeholders? Select all that apply.

  • Vice president of finance
  • Vice president of marketing
  • Data analyst (CORRECT)
  • Project manager (CORRECT)

Correct!

55. Fill in the blank: Stakeholders _____ when contributing to a project.

  • invest time and resources (CORRECT)
  • present data insights
  • connect with customers
  • implement solutions

Correct!

56. What are some strategies to ensure you arrive at meetings prepared? Select all that apply.

  • Bring a laptop to keep an eye on emails so you don’t miss anything important
  • Read the meeting agenda ahead of time (CORRECT)
  • Bring materials to take notes with (CORRECT)
  • Consider what questions you may be asked so you are prepared to answer (CORRECT)

Correct!

57. A data analyst at an electrical utility company investigates why electricity consumption has increased in a particular area. During the analysis, which team is most likely to offer helpful insight about electricity users and their particular household needs?

  • Customer-facing (CORRECT)
  • Project management
  • Data science
  • Executive

Correct!

58. A data analyst works on a logistics project that aims to create more efficient truck delivery routes. Who is most likely to be the primary stakeholder?

  • Lead truck driver
  • Vice president of logistics (CORRECT)
  • Customers receiving packages
  • Data analyst

Correct!

59. In order to build trust, data professionals focus on the expectations of _____, who are the people investing time, interest, and resources into the project.

  • subject-matter experts
  • stakeholders (CORRECT)
  • data analysts
  • administrators

Correct!

60. What are some strategies to ensure an online meeting is effective? Select all that apply.

  • Maintain control of the meeting by keeping everyone else on mute
  • Take the meeting from an area that is free of distractions (CORRECT)
  • Distribute an agenda beforehand (CORRECT)
  • Make sure technology is working properly (CORRECT)

Correct!

61. What are some strategies to ensure you respect people’s time when leading a meeting? Select all that apply.

  • Discuss work that does not affect the attendees
  • Arrive to the meeting on time (CORRECT)
  • Pay attention to what others are saying (CORRECT)
  • Be prepared to talk about your work (CORRECT)

Correct!

62. A data analyst prepares for a stakeholder presentation. To ensure they communicate clearly, they follow best practices and ask four questions, including: What does my audience need to know? Identify the remaining three questions the data analyst should ask. Select all that apply.

  • Who is my audience?
  • How can I communicate effectively to my audience? (CORRECT)
  • What does my audience want to avoid? (CORRECT)
  • What does my audience already know? (CORRECT)

Correct!

GOOGLE DATA ANALYTICS Coursera WEEK 1 CONCLUSION

In order to be successful in data analysis, it is essential that you are able to manage different stakeholders’ needs and create a positive outcome. This course will equip you with the skills needed to successfully balance different stakeholders’ interests and create a win-win situation for all parties involved. You’ll also learn how to communicate effectively with your team members so that everyone understands the purpose and goals of each project. By mastering these techniques, you can be assured that all stakeholders are satisfied with the results of your data analysis efforts. Join the learning experience in Coursera today and master the art of stakeholder management!