Coursera – STUDY GUIDEClick To Enroll in Coursera Show
Always remember the stakeholderTest your knowledge on balancing team and stakeholders needs1. 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?
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.
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.
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 communication1. 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.
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?
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.
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.
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.
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 teamwork1. 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.
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.
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?
Correct: The best course of action is to email the director to politely explain the timeline required to complete the report properly. *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.
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.
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?
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?
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?
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.
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?
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.
Correct: To help shift a situation from problematic to productive, reframe the question, keep your emotions in check, and establish open lines of communication. *Course Challenge*1. Scenario 1, questions 1-5You’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.
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 continuedThe data in column F (Survey Q6: What types of books would you like to see more of at Athena’s Story?) is quantitative.
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 continuedThe 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 ChartThe chart you create demonstrates the percentages of each book genre that make up the whole. It’s called an area chart.
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?
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 continuedAfter 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?
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-10As 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.
7. Scenario 2 continuedNext, 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.
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 continuedNow, 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?
Correct: This situation present an opportunity to communicate, collaborate, and foster positive working relationships 9. Scenario 2 continuedYour 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.
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 continuedYour 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?
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. When communicating with stakeholders which are important considerations?When it comes to stakeholder communication requirements – transparency, accuracy and communication are key. An expectation from stakeholders is that you have already completed and identified the key stakeholders for your project. Identifying your stakeholder at an early stage can help to keep your project on track.
What information should be communicated to stakeholders?Stakeholders need to see the bigger picture. To do that, project managers should clearly communicate the project drivers, purpose, and end goals. Sharing details about what prompted the project, how it helps the organization, and the intended outcome helps stakeholders better understand the project's significance.
How do stakeholders communicate with each other?Using forums or other social media to communicate enables you to respond to critical comments or correct any misunderstandings. Communicating through social media can also spread your message further as stakeholders share attitudes with others.
What are the types of stakeholders in communication?Stakeholder communication is the correspondence among all of the people invested in a project or business. Stakeholders include project managers, team members, clients, department heads and company executives. Some common stakeholder communication mediums include: Regular meetings via video or in person.
|