Successful data analysts learn to balance needs and expectations. In this part of the course, you’ll learn strategies for managing stakeholder expectations while establishing clear communication with your team.
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
- Balance team and stakeholder needs
- Communication is key
- Video: Clear communication is key
- Video: Tips for effective communication
- Reading: Data scenarios and responses
- Video: Balancing expectations and realistic project goals
- Video: Sarah: How to communicate with stakeholders
- Video: The data tradeoff: Speed versus accuracy
- Reading: Limitations of data
- Video: Think about your process and outcome
- Practice Quiz: Test your knowledge on clear communication
- Amazing teamwork
- Weekly challenge 4
- Course challenge
Balance team and stakeholder needs
Video: Communicating with your team
Non-technical skills are just as important as technical skills for data analysts. These skills help you to interact with your colleagues and stakeholders in a positive and productive way.
Communication is key for data analysts. You need to be able to communicate your findings to your team members and stakeholders in a clear and concise way. You also need to be able to balance the needs of both groups.
These non-technical skills are like new tools that will help you to work with your team to find the best possible solutions.
Hey, welcome back. So far you’ve learned about
things like spreadsheets, analytical thinking skills,
metrics, and mathematics. These are all super
important technical skills that you’ll build on throughout your Data Analytics career. You should also keep in mind that there are some
non-technical skills that you can use to create a positive and productive
working environment. These skills will help
you consider the way you interact with your colleagues as well as your stakeholders. We already know that
it’s important to keep your team members’ and
stakeholders’ needs in mind. Coming up, we’ll talk
about why that is. We’ll start learning
some communication best practices you can use
in your day to day work. Remember, communication is key. We’ll start by learning all about effective
communication, and how to balance team
member and stakeholder needs. Think of these
skills as new tools that’ll help you work
with your team to find the best possible solutions. Alright, let’s head on to the next
video and get started.
Video: Balancing needs and expectations across your team
Stakeholder expectations are important to data analysts because they help to ensure that the data analyst’s work is aligned with the needs of the stakeholders. Stakeholders are people who have invested time, interest, and resources into the projects that the data analyst will be working on.
Data analysts need to communicate effectively with all of the stakeholders across their team. This includes discussing the project objective, what is needed to reach that goal, and any challenges or concerns that the data analyst may have.
Here is an example of how data analysts can balance the needs and expectations of stakeholders across their team:
Example:
A data analyst is working with a company’s human resources department to identify why there has been an increase in employee turnover. The Vice President of HR (VP) is interested in identifying any shared patterns across employees who quit and seeing if there is a connection to employee productivity and engagement.
The data analyst needs to focus on the HR department’s question and help find them an answer. However, the VP may be too busy to manage day-to-day tasks or may not be the data analyst’s direct contact. For this task, the data analyst will be updating the project manager more regularly.
Project managers are in charge of planning and executing a project. Part of the project manager’s job is keeping the project on track and overseeing the progress of the entire team. In most cases, the data analyst will need to give them regular updates, let them know what they need to succeed, and tell them if they have any problems along the way.
The data analyst may also be working with other team members, such as HR administrators and other data analysts. It is important for the data analyst to know who the stakeholders and other team members are in a project so that they can communicate with them effectively and give them what they need to move forward in their own roles on the project.
By working together, the data analyst and their team can give the company vital insights into the problem of employee turnover.
Conclusion:
Focusing on stakeholder expectations will help data analysts to understand the goal of a project, communicate more effectively across their team, and build trust in their work.
Introduction
As a data analyst, you will often be working with a team of people with different needs and expectations. It is important to be able to balance these needs and expectations in order to be successful.
The importance of communication
The first step to balancing needs and expectations is to communicate effectively with your team. This means being clear about your own needs and expectations, as well as the needs and expectations of others. It also means being respectful of everyone’s input and being willing to compromise.
The importance of understanding the big picture
It is also important to understand the big picture when balancing needs and expectations. This means understanding the goals of the project or team, as well as the constraints that everyone is working under. When you understand the big picture, you can make better decisions about how to balance everyone’s needs.
The importance of compromise
In some cases, it may not be possible to perfectly balance everyone’s needs and expectations. In these cases, it is important to be willing to compromise. This means being willing to give a little on your own needs in order to meet the needs of others.
Tips for balancing needs and expectations
Here are some tips for balancing needs and expectations in data analytics:
- Be clear about your own needs and expectations.
- Be respectful of everyone’s input.
- Be willing to compromise.
- Understand the big picture.
- Be proactive in communicating with your team.
- Be flexible and adaptable.
Conclusion
Balancing needs and expectations is an important skill for data analysts. By following the tips in this tutorial, you can improve your ability to balance the needs and expectations of your team and be more successful in your career.
Here are some additional things to keep in mind when balancing needs and expectations:
- Be aware of your own biases. Everyone has biases, and it is important to be aware of them so that they do not cloud your judgment when balancing needs and expectations.
- Be patient. It takes time to build trust and rapport with your team, and it takes time to find the right balance.
- Be willing to learn and grow. As you gain experience, you will learn new ways to balance needs and expectations.
People who hold a stake in the outcome of a data analysis project are called stakeholders. In what ways do they hold a stake in the outcome?
They invest time and resources into the project.
Stakeholders are people who invest time and resources into a project.
As a data analyst, you’ll be required to focus
on a lot of different things, And your stakeholders’
expectations are one of the most important. We’re going to talk about why stakeholder expectations
are so important to your work and look at some examples of stakeholder
needs on a project. By now you’ve heard me use
the term stakeholder a lot. So let’s refresh ourselves
on what a stakeholder is. Stakeholders are people that have invested time, interest, and resources into
the projects that you’ll be working on
as a data analyst. In other words, they hold
stakes in what you’re doing. There’s a good
chance they’ll need the work you do to
perform their own needs. That’s why it’s so
important to make sure your work lines
up with their needs and why you need to communicate effectively with all of the stakeholders
across your team. Your stakeholders will want to discuss things like
the project objective, what you need to reach that goal, and any challenges or
concerns you have. This is a good thing. These conversations help build trust and confidence
in your work. Here’s an example of a project with
multiple team members. Let’s explore what
they might need from you at different levels to
reach the project’s goal. Imagine you’re a data
analyst working with a company’s human
resources department. The company has experienced an increase in its turnover rate, which is the rate at which
employees leave a company. The company’s HR department
wants to know why that is and they want you to help them figure out potential solutions. The Vice President of
HR at this company is interested in identifying
any shared patterns across employees who quit
and seeing if there’s a connection to employee
productivity and engagement. As a data analyst, it’s your job to focus on the HR department’s question and help find them an answer. But the VP might be
too busy to manage day-to-day tasks or might
not be your direct contact. For this task, you’ll be updating the project manager
more regularly. Project managers are in charge of planning and executing a project. Part of the project manager’s
job is keeping the project on track and overseeing the
progress of the entire team. In most cases, you’ll need to
give them regular updates, let them know what you
need to succeed and tell them if you have any
problems along the way. You might also be working
with other team members. For example, HR administrators will need to know
the metrics you’re using so that they
can design ways to effectively gather
employee data. You might even be working with other data analysts who are covering different
aspects of the data. It’s so important
that you know who the stakeholders and
other team members are in a project so that you can communicate with
them effectively and give them what they need to move forward in their own
roles on the project. You’re all working
together to give the company vital insights
into this problem. Back to our example. By analyzing company data, you see a decrease in
employee engagement and performance after their first
13 months at the company, which could mean that employees started feeling demotivated or disconnected from their work and then often quit
a few months later. Another analyst who focuses on hiring data also shares that the company had a large increase in hiring around 18 months ago. You communicate this information with all your team members and stakeholders and they provide feedback on how to share this
information with your VP. In the end, your VP decides
to implement an in-depth manager check-in with
employees who are about to hit their 12
month mark at the firm to identify career growth
opportunities, which reduces the employee turnover starting at the
13 month mark. This is just one example
of how you might balance needs and expectations
across your team. You’ll find that in
pretty much every project you work on as a data analyst, different people on your team, from the VP of HR to your
fellow data analysts, will need all your focus and communication to carry
the project to success. Focusing on stakeholder
expectations will help you understand
the goal of a project, communicate more effectively
across your team, and build trust in your work. Coming up, we’ll discuss how to figure out where you
fit on your team and how you can
help move a project forward with focus
and determination.
Reading: Working with stakeholders
Reading
Your data analysis project should answer the business task and create opportunities for data-driven decision-making. That’s why it is so important to focus on project stakeholders. As a data analyst, it is your responsibility to understand and manage your stakeholders’ expectations while keeping the project goals front and center.
ou might remember that stakeholders are people who have invested time, interest, and resources into the projects that you are working on. This can be a pretty broad group, and your project stakeholders may change from project to project. But there are three common stakeholder groups that you might find yourself working with: the executive team, the customer-facing team, and the data science team.
Let’s get to know more about the different stakeholders and their goals. Then we’ll learn some tips for communicating with them effectively.
Executive team
The executive team provides strategic and operational leadership to the company. They set goals, develop strategy, and make sure that strategy is executed effectively. The executive team might include vice presidents, the chief marketing officer, and senior-level professionals who help plan and direct the company’s work. These stakeholders think about decisions at a very high level and they are looking for the headline news about your project first. They are less interested in the details. Time is very limited with them, so make the most of it by leading your presentations with the answers to their questions. You can keep the more detailed information handy in your presentation appendix or your project documentation for them to dig into when they have more time.
For example, you might find yourself working with the vice president of human resources on an analysis project to understand the rate of employee absences. A marketing director might look to you for competitive analyses. Part of your job will be balancing what information they will need to make informed decisions with their busy schedule.
But you don’t have to tackle that by yourself. Your project manager will be overseeing the progress of the entire team, and you will be giving them more regular updates than someone like the vice president of HR. They are able to give you what you need to move forward on a project, including getting approvals from the busy executive team. Working closely with your project manager can help you pinpoint the needs of the executive stakeholders for your project, so don’t be afraid to ask them for guidance.
Customer-facing team
The customer-facing team includes anyone in an organization who has some level of interaction with customers and potential customers. Typically they compile information, set expectations, and communicate customer feedback to other parts of the internal organization. These stakeholders have their own objectives and may come to you with specific asks. It is important to let the data tell the story and not be swayed by asks from your stakeholders to find certain patterns that might not exist.
Let’s say a customer-facing team is working with you to build a new version of a company’s most popular product. Part of your work might involve collecting and sharing data about consumers’ buying behavior to help inform product features. Here, you want to be sure that your analysis and presentation focuses on what is actually in the data– not on what your stakeholders hope to find.
Data science team
Organizing data within a company takes teamwork. There’s a good chance you’ll find yourself working with other data analysts, data scientists, and data engineers. For example, maybe you team up with a company’s data science team to work on boosting company engagement to lower rates of employee turnover. In that case, you might look into the data on employee productivity, while another analyst looks at hiring data. Then you share those findings with the data scientist on your team, who uses them to predict how new processes could boost employee productivity and engagement. When you share what you found in your individual analyses, you uncover the bigger story. A big part of your job will be collaborating with other data team members to find new angles of the data to explore. Here’s a view of how different roles on a typical data science team support different functions:
Working effectively with stakeholders
When you’re working with each group of stakeholders- from the executive team, to the customer-facing team, to the data science team, you’ll often have to go beyond the data. Use the following tips to communicate clearly, establish trust, and deliver your findings across groups.
Discuss goals. Stakeholder requests are often tied to a bigger project or goal. When they ask you for something, take the opportunity to learn more. Start a discussion. Ask about the kind of results the stakeholder wants. Sometimes, a quick chat about goals can help set expectations and plan the next steps.
Feel empowered to say “no.” Let’s say you are approached by a marketing director who has a “high-priority” project and needs data to back up their hypothesis. They ask you to produce the analysis and charts for a presentation by tomorrow morning. Maybe you realize their hypothesis isn’t fully formed and you have helpful ideas about a better way to approach the analysis. Or maybe you realize it will take more time and effort to perform the analysis than estimated. Whatever the case may be, don’t be afraid to push back when you need to.
Stakeholders don’t always realize the time and effort that goes into collecting and analyzing data. They also might not know what they actually need. You can help stakeholders by asking about their goals and determining whether you can deliver what they need. If you can’t, have the confidence to say “no,” and provide a respectful explanation. If there’s an option that would be more helpful, point the stakeholder toward those resources. If you find that you need to prioritize other projects first, discuss what you can prioritize and when. When your stakeholders understand what needs to be done and what can be accomplished in a given timeline, they will usually be comfortable resetting their expectations. You should feel empowered to say no– just remember to give context so others understand why.
Plan for the unexpected. Before you start a project, make a list of potential roadblocks. Then, when you discuss project expectations and timelines with your stakeholders, give yourself some extra time for problem-solving at each stage of the process.
Know your project. Keep track of your discussions about the project over email or reports, and be ready to answer questions about how certain aspects are important for your organization. Get to know how your project connects to the rest of the company and get involved in providing the most insight possible. If you have a good understanding about why you are doing an analysis, it can help you connect your work with other goals and be more effective at solving larger problems.
Start with words and visuals. It is common for data analysts and stakeholders to interpret things in different ways while assuming the other is on the same page. This illusion of agreement* has been historically identified as a cause of projects going back-and-forth a number of times before a direction is finally nailed down. To help avoid this, start with a description and a quick visual of what you are trying to convey. Stakeholders have many points of view and may prefer to absorb information in words or pictures. Work with them to make changes and improvements from there. The faster everyone agrees, the faster you can perform the first analysis to test the usefulness of the project, measure the feedback, learn from the data, and implement changes.
Communicate often. Your stakeholders will want regular updates on your projects. Share notes about project milestones, setbacks, and changes. Then use your notes to create a shareable report. Another great resource to use is a change-log, which is a tool that will be explored further throughout the program. For now, just know that a change-log is a file containing a chronologically ordered list of modifications made to a project. Depending on the way you set it up, stakeholders can even pop in and view updates whenever they want.
Video: Focus on what matters
Data analysts need to stay focused on the objective of a project, even when working with a lot of people with competing needs and opinions.
To stay focused, data analysts can ask themselves three questions at the beginning of each task:
- Who are the primary and secondary stakeholders?
- Who is managing the data?
- Where can you go for help?
By answering these questions, data analysts can identify their stakeholders and their goals, understand who is managing the data, and know where to go for help when needed.
Example:
The employee turnover example:
- Primary stakeholder: Vice President of HR
- Secondary stakeholders: project manager, team members, other data analysts
- Data management: another data analyst is managing the hiring data
- Where to go for help: project manager
By understanding the stakeholders and their goals, understanding who is managing the data, and knowing where to go for help, the data analyst can stay focused on the objective of the project, which is to identify why employee turnover has increased.
Conclusion:
By asking themselves three easy questions at the beginning of new projects, data analysts can address stakeholder needs, feel confident about who is managing the data, and get help when they need it so that they can keep their eyes on the prize: the project objective.
A data analyst at a delivery company is working on a logistics project. The goal is to use data to create more efficient routes so trucks travel fewer miles on the road when delivering parcels to customers. Who is the primary stakeholder most likely to be?
The vice president of logistics
The primary stakeholder is the vice president of logistics.
So now that we know the
importance of finding the balance across
your stakeholders and your team members. I want to talk about
the importance of staying focused on the objective. This can be tricky when you find yourself working
with a lot of people with competing needs
and opinions. But by asking yourself a
few simple questions at the beginning of each task, you can ensure that you’re able to stay focused on your objective while still
balancing stakeholder needs. Let’s think about our
employee turnover example from the last video. There, we were
dealing with a lot of different team members and
stakeholders like managers, administrators, even
other analysts. As a data analyst, you’ll find that
balancing everyone’s needs can be a little chaotic sometimes but part of your
job is to look past the clutter and stay
focused on the objective. It’s important to concentrate on what matters and
not get distracted. As a data analyst, you could be working on
multiple projects with lots of different people but no matter what project you’re working on, there are three things you can focus on that will
help you stay on task. One, who are the primary
and secondary stakeholders? Two who is managing the data? And three where can you go for help? Let’s see if we can apply those questions to
our example project. The first question you can ask is about who those stakeholders are. The primary stakeholder of this project is probably
the Vice President of HR who’s hoping to use his project’s findings to make new decisions about
company policy. You’d also be giving updates to your project manager,
team members, or other data analysts who are depending on your work
for their own task. These are your
secondary stakeholders. Take time at the beginning
of every project to identify your stakeholders
and their goals. Then see who else is on your team
and what their roles are. Next, you’ll want to ask
who’s managing the data? For example, think about working with other
analysts on this project. You’re all data analysts, but you may manage different
data within your project. In our example, there
was another data analyst who was focused on managing
the company’s hiring data. Their insights around
a surge of new hires 18 months ago turned out to be a key part of your analysis. If you hadn’t communicated
with this person, you might have spent
a lot of time trying to collect or analyze hiring data yourself or you may not have even been able to include
it in your analysis at all. Instead, you were able to communicate your
objectives with another data analyst and use existing work to make
your analysis richer. By understanding who’s
managing the data, you can spend your time
more productively. Next step, you need to know where you can go
when you need help. This is something
you should know at the beginning of any
project you work on. If you run into bumps in the road on your way
to completing a task, you need someone who is best positioned to take down
those barriers for you. When you know who’s able to help, you’ll spend less time worrying
about other aspects of the project and more time
focused on the objective. So who could you go to if you ran into a problem
on this project? Project managers support you and your work by managing
the project timeline, providing guidance and resources, and setting up
efficient workflows. They have a big picture
view of the project because they know what you and the rest of the
team are doing. This makes them a great resource if you run into a problem in the employee turnover example, you would need to
be able to access employee departure survey data to include in your analysis. If you’re having trouble getting approvals for that access, you can speak with your
project manager to remove those barriers for
you so that you can move forward
with your project. Your team depends on you to stay focused on your task
so that as a team, you can find solutions. By asking yourself
three easy questions at the beginning of new projects, you’ll be able to address
stakeholder needs, feel confident about who is
managing the data, and get help when you need it so that you can keep your
eyes on the prize: the project objective. So far we’ve covered the importance
of working effectively on a team while maintaining your
focus on stakeholder needs. Coming up, we’ll go over some
practical ways to become better communicators
so that we can help make sure the team
reaches its goals.
Practice Quiz: Test your knowledge on balancing team and stakeholder needs
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
Stakeholders invest time and resources into a project. Sharing detailed notes and creating reports are useful ways to keep them up-to-date.
The customer-facing team does which of the following activities? Select all that apply.
- Compile information about customer expectations
- Share customer feedback
The customer-facing team compiles information, shares feedback, and sets expectations.
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.
Respectfully explain their viewpoints and offer the director some additional information to help improve the project.
The analyst should respectfully explain their viewpoints and offer the director some additional information to help improve the project.
Communication is key
Video: Clear communication is key
Clear communication is essential for building good relationships with your team members and stakeholders. Before you communicate, think about your audience, what they already know, what they need to know, and how you can communicate that effectively.
Here is an example of how to use clear communication to communicate a problem to your team:
- Identify your audience. Who needs to know about the problem? In this case, the other data analysts working on the project, the project manager, and the VP of sales.
- Consider what your audience already knows. The other data analysts know the details about the data-set you are using and the project manager knows the timeline. The VP of sales knows the high-level goals of the project.
- Determine what your audience needs to know. The other data analysts need to know the details of where you have tried to find the missing data and any potential solutions you have come up with. The project manager needs to know the different teams that could be affected and the implications for the project. The VP of sales needs to know that there is a potential issue that could delay or affect the project.
- Choose the best way to communicate with your audience. In this case, a meeting with the project manager and fellow analysts would be the best way to communicate the problem and develop a plan.
By communicating thoughtfully and thinking about your audience first, you will build better relationships and trust with your team members and stakeholders. This is important because these relationships are key to the success of the project and your own success.
Introduction
Clear communication is essential in all aspects of life, but it is especially important in the workplace. When you are able to communicate clearly, you are able to:
- Get your message across effectively.
- Build relationships with colleagues and clients.
- Solve problems more easily.
- Make better decisions.
- Be more productive.
Why is clear communication important?
There are many reasons why clear communication is important. Here are a few of the most important ones:
- It helps to avoid misunderstandings. When you communicate clearly, you are less likely to be misunderstood by others. This can help to prevent misunderstandings and conflict.
- It builds trust. When you communicate clearly, you show that you are confident and reliable. This can help to build trust with others.
- It is more efficient. When you communicate clearly, you can get your message across more quickly and easily. This can save you time and energy.
- It is more persuasive. When you communicate clearly, you are more likely to persuade others to see things your way.
- It is more engaging. When you communicate clearly, you are more likely to keep your audience’s attention.
How to communicate clearly
There are many things you can do to communicate clearly. Here are a few tips:
- Be concise. Get to the point quickly and avoid rambling.
- Be specific. Use clear and specific language that is easy to understand.
- Be organized. Present your information in a logical and easy-to-follow way.
- Be aware of your audience. Tailor your communication to your audience’s needs and understanding.
- Use visuals. Visuals can help to make your communication more engaging and easier to understand.
- Be active. Ask questions, encourage feedback, and be open to discussion.
Conclusion
Clear communication is a skill that can be learned and improved with practice. By following the tips above, you can become a more effective communicator and achieve your goals in the workplace and beyond.
Here are some additional tips for clear communication:
- Listen carefully. When someone is speaking to you, take the time to listen carefully and understand what they are saying.
- Be respectful. Even if you disagree with someone, be respectful of their point of view.
- Be patient. Sometimes it takes time for people to understand your message. Be patient and don’t give up.
- Be open to feedback. Be willing to listen to feedback and make changes to your communication if necessary.
By following these tips, you can improve your communication skills and become a more effective communicator.
Welcome back. We’ve talked a lot about understanding
your stakeholders and your team so that you can
balance their needs and maintain a clear focus on
your project objectives. A big part of that is building good relationships with the
people you’re working with. How do you do that? Two
words: clear communication. Now we’re going to learn
about the importance of clear communication with your stakeholders
and team members. Start thinking about
who you want to communicate with and when. First, it might
help to think about communication
challenges you might already experience
in your daily life. Have you ever been in
the middle of telling a really funny joke only to find out your friend already
knows the punchline? Or maybe they just didn’t
get what was funny about it? This happens all the time, especially if you don’t
know your audience. This kind of thing can
happen at the workplace too. Here’s the secret to
effective communication. Before you put together
a presentation, send an e-mail, or even tell that hilarious
joke to your co-worker, think about who your audience is, what they already know, what they need to
know and how you can communicate that
effectively to them. When you start by thinking
about your audience, they’ll know it and
appreciate the time you took to consider them
and their needs. Let’s say you’re working
on a big project, analyzing annual
sales data, and you discover that all of the
online sales data is missing. This could affect
your whole team and significantly delay the project. By thinking through
these four questions, you can map out the best way to communicate across your
team about this problem. First, you’ll need to think
about who your audience is. In this case, you’ll
want to connect with other data analysts
working on the project, as well as your project manager and eventually the VP of sales, who is your stakeholder. Next up, you’ll think through what this group already knows. The other data analysts
working on this project know all the details about which data-set you
are using already, and your project manager knows the timeline you’re
working towards. Finally, the VP of sales knows the high-level
goals of the project. Then you’ll ask yourself what they need to know
to move forward. Your fellow data analysts need to know the details of
where you have tried so far and any potential
solutions you’ve come up with. Your project manager would need to know the different teams that could be affected and the implications for the project, especially if this problem
changes the timeline. Finally, the VP of sales will
need to know that there is a potential issue that would
delay or affect the project. Now that you’ve decided
who needs to know what, you can choose the best way
to communicate with them. Instead of a long,
worried e-mail which could lead to lots
back and forth, you decide to quickly
book in a meeting with your project manager
and fellow analysts. In the meeting, you let
the team know about the missing online sales data and give them more
background info. Together, you discuss how this impacts other
parts of the project. As a team, you come
up with a plan and update the project
timeline if needed. In this case, the VP of sales didn’t need to be
invited to your meeting, but would appreciate
an e-mail update if there were changes to the timeline which
your project manager might send along herself. When you communicate thoughtfully and think about your
audience first, you’ll build better
relationships and trust with your team
members and stakeholders. That’s important because
those relationships are key to the project’s success
and your own too. When you’re getting
ready to send an e-mail, organize some meeting, or
put together a presentation, think about who your audience is, what they already know, what they need to
know and how you can communicate that
effectively to them. Next up, we’ll talk more about communicating
at work and you’ll learn some useful
tips to make sure you get your message
across clearly.
Video: Tips for effective communication
Communicating effectively in the workplace is important for building relationships and getting work done. Here are some tips:
- Get to know your audience and adapt to their communication style. Pay attention to how they communicate with each other, and ask questions if you’re not sure about something.
- Be clear and concise in your writing and speaking. Avoid using jargon or acronyms that your audience may not understand.
- Be respectful and professional. This includes using proper grammar and punctuation, and avoiding informal language.
- Be responsive to emails and other messages. Aim to respond within 24-48 hours, even if it’s just to let the sender know that you’re working on it.
- Be clear about your needs. When you need something from a team member, be clear about what you need and when you need it.
Here are some additional tips for communicating effectively in the workplace:
- Be an active listener. Pay attention to what the other person is saying, and ask clarifying questions.
- Be honest and upfront. Don’t try to sugarcoat things or avoid difficult conversations.
- Be open to feedback. Be willing to listen to feedback from others, and use it to improve your communication skills.
By following these tips, you can improve your communication skills and build stronger relationships with your team members.
Introduction
Effective communication is the ability to share information and ideas in a way that is clear, concise, and understandable. It is a critical skill for success in both personal and professional life.
There are many different aspects of effective communication, but some of the most important include:
- Active listening: This means paying attention to what the other person is saying and understanding their point of view.
- Clear and concise language: This means using language that is easy to understand and avoids jargon or technical terms.
- Nonverbal communication: This includes things like body language, facial expressions, and tone of voice.
- Feedback: This means being open to feedback and being willing to change your communication style if necessary.
Tips for effective communication
Here are some tips for effective communication:
- Be clear and concise. Get to the point quickly and avoid rambling.
- Use specific language. Avoid using vague language that can be interpreted in different ways.
- Be organized. Present your information in a logical and easy-to-follow way.
- Be aware of your audience. Tailor your communication to your audience’s needs and understanding.
- Use visuals. Visuals can help to make your communication more engaging and easier to understand.
- Be active. Ask questions, encourage feedback, and be open to discussion.
- Listen carefully. When someone is speaking to you, take the time to listen carefully and understand what they are saying.
- Be respectful. Even if you disagree with someone, be respectful of their point of view.
- Be patient. Sometimes it takes time for people to understand your message. Be patient and don’t give up.
- Be open to feedback. Be willing to listen to feedback and make changes to your communication if necessary.
Conclusion
Effective communication is a skill that can be learned and improved with practice. By following the tips above, you can become a more effective communicator and achieve your goals in the workplace and beyond.
Here are some additional tips for effective communication:
- Be aware of your body language. Your body language can communicate a lot about you, so be aware of how you are positioned and what your facial expressions are saying.
- Use active listening skills. This means paying attention to what the other person is saying, not just waiting for your turn to talk.
- Pay attention to the other person’s needs. Are they understanding what you are saying? Are they comfortable with the pace of the conversation?
- Be willing to compromise. Sometimes you may not get everything you want, but it is important to be willing to compromise in order to reach an agreement.
By following these tips, you can improve your communication skills and become a more effective communicator.
No matter where you work, you’ll probably need to communicate with
other people as part of your day to day. Every organization and every team in
that organization will have different expectations for communication. Coming up, We’ll learn some practical ways to help
you adapt to those different expectations and some things that you can
carry over from team to team. Let’s get started. When you started a new job or a new
project, you might find yourself feeling a little out of sync with the rest of
your team and how they communicate. That’s totally normal. You’ll figure things out in no time. if you’re willing to learn as you go and ask questions when you
aren’t sure of something. For example, if you find your team uses
acronyms you aren’t familiar with, don’t be afraid to ask what they mean. When I first started at google,
I had no idea what L G T M meant and
I was always seeing it in comment threads. Well, I learned it stands for looks
good to me and I use it all the time now if I need to give
someone my quick feedback, that was one of the many
acronyms I’ve learned and I come across new ones all the time and
I’m never afraid to ask. Every work setting has
some form of etiquette. Maybe your team members appreciate
eye contact and a firm handshake. Or it might be more polite to bow, especially if you find yourself
working with international clients. You might also discover some specific
etiquette rules just by watching your coworkers communicate. And
it won’t just be in person communication you’ll deal with. Almost 300 billion emails are sent and
received every day and that number is only growing. Fortunately
there are useful skills you can learn from those digital
communications too. You’ll want your emails to be just as professional
as your in-person communications. Here are some things that can help you do
that. Good writing practices will go a long way to make your emails professional and
easy to understand. Emails are naturally more
formal than texts, but that doesn’t mean that you have
to write the next great novel. Just taking the time to write complete
sentences that have proper spelling and punctuation will make it clear you took time and consideration in your writing. Emails often
get forwarded to other people to read. So write clearly enough that
anyone could understand you. I like to read important emails out
loud before I hit send; that way, I can hear if they make sense and
catch any typos. And keep in mind the tone of your
emails can change over time. If you find that your team is
fairly casual, that’s great. Once you get to know them better,
you can start being more casual too, but being professional is always a good
place to start. A good rule of thumb: Would you be proud of what you had written
if it were published on the front page of a newspaper? If not revise it until you are. You also
don’t want your emails to be too long. Think about what your team member needs
to know and get to the point instead of overwhelming them with a wall of text.
You’ll want to make sure that your emails are clear and concise so
they don’t get lost in the shuffle. Let’s take a quick look at two emails so
that you can see what I mean. Here’s the first email. There’s so much written here that it’s kind of hard
to see where the important information is. And this first paragraph doesn’t give me a
quick summary of the important takeaways. It’s pretty casual to the greeting is just, “Hey,” and there’s no sign off. Plus I can already spot some typos. Now let’s take a look at
the second email. Already, it’s less overwhelming, right? Just a few sentences,
telling me what I need to know. It’s clearly organized and
there’s a polite greeting and sign off. This is a good example of an email; short
and to the point, polite and well-written. All of the things we’ve
been talking about so far. But what do you do if, what you need
to say is too long for an email? Well, you might want to
set up a meeting instead. It’s important to answer
in a timely manner as well. You don’t want to take so long replying to emails that your coworkers
start wondering if you’re okay. I always try to answer
emails in 24-48 hours. Even if it’s just to
give them a timeline for when I’ll have the actual
answers they’re looking for. That way, I can set expectations and
they know I’m working on it. That works the other way around too. If you need a response on something
specific from one of your team members, be clear about what you need and when you
need it so that they can get back to you. I’ll even include a date
in my subject line and bold dates in the body of my email, so it’s really clear. Remember, being
clear about your needs is a big part of being a good communicator. We covered some great ways to improve our
professional communication skills, like asking questions, practicing good writing
habits and some email tips and tricks. These will help you
communicate clearly and effectively with your team
members on any project. It might take some time, but you’ll find a
communication style that works for you and your team, both in person and online. As long as you’re willing to learn,
you won’t have any problems adapting to the different communication
expectations you’ll see in future jobs.
Reading: Data scenarios and responses
Reading
Being able to communicate in multiple formats is a key skill for data analysts. Listening, speaking, presenting, and writing skills will help you succeed in your projects and in your career. This reading covers effective communication strategies, including examples of clearly worded emails for common situations.
Here’s an important first tip: Know your audience! When you communicate your analysis and recommendations as a data analyst, it’s vital to keep your audience in mind.
Be sure to answer these four important questions related to your audience:
- Who is your audience?
- What do they already know?
- What do they need to know?
- How can you best communicate what they need to know?
Project example
As a data analyst, you’ll get plenty of requests and questions through email. Let’s walk through an example of how you might approach answering one of these emails. Assume you’re a data analyst working at a company that develops mobile apps. Let’s start by reviewing answers to the four audience questions we just covered:
Who is your audience?
Kiri, Product Development Project Manager
What do they already know?
Kiri received updates about our project from its planning stages, including the most recent project report, sent two weeks ago.
What do they need to know?
Kiri needs an update on the analysis project’s progress and needs to know that the executive team approved changes to the data and timeline. You know that adding a new variable to the analysis will impact the current project timeline. Kiri will need to change the project’s milestones and completion date.
How can you best communicate what they need to know?
You can start by sending an email update to Kiri with the latest timeline for the project, but a meeting might be necessary if she wants to talk through her concerns about missing a deadline.
Updated timeline email sample
After answering the audience questions, you have the key building blocks you need to write an email to Kiri. Here’s an example of how these questions can help organize the flow of the email message:
After receiving your email, Kiri will have a clearer view of the changes to the analysis project and will be able to make adjustments to work with the new timeline.
Project follow-up email sample
After the next report is completed, you can also send out a project update offering more information. The email could look like this:
Good communication keeps stakeholders updated on progress and ultimately helps prevent problems. Carefully worded responses are key. Whether you gather and address feedback using email, meetings, or reports, everyone you work with will know what to expect. As a result, they will be able to better manage their own schedules, resources, and teams.
Video: Balancing expectations and realistic project goals
- Set realistic expectations. When working with stakeholders, it is important to set realistic expectations from the start. This means being honest about the time and resources that will be needed to complete the project.
- Communicate clearly and regularly. Stakeholders need to be kept informed of the project’s progress, both good and bad. This will help to build trust and avoid surprises.
- Be responsive to stakeholder feedback. Stakeholders may have questions or concerns about the project. It is important to be responsive to their feedback and address their concerns in a timely manner.
- Be flexible. Things don’t always go according to plan. Be prepared to adjust the project’s timeline or scope as needed.
- Be positive. Stakeholders are more likely to be supportive of a project if they believe in its success. Stay positive and focused on the project’s goals.
By following these tips, you can improve your communication with stakeholders and increase the chances of project success.
Here are some additional tips for communicating with stakeholders:
- Use clear and concise language. Avoid using jargon or technical terms that your stakeholders may not understand.
- Be specific. When providing updates, be as specific as possible about the project’s progress.
- Be proactive. Don’t wait for stakeholders to come to you with questions or concerns. Reach out to them regularly to keep them informed.
- Be open to feedback. Stakeholders may have valuable insights that can help improve the project. Be open to their feedback and be willing to make changes as needed.
By following these tips, you can improve your communication with stakeholders and build stronger relationships.
We discussed before how
data has limitations. Sometimes you don’t have
access to the data you need, or your data sources aren’t aligned or
your data is unclean. This can definitely be a problem
when you’re analyzing data, but it can also affect your communication
with your stakeholders. That’s why it’s important to balance your
stakeholders’ expectations with what is actually possible for a project. We’re going to learn about the importance
of setting realistic, objective goals and how to best communicate with
your stakeholders about problems you might run into. Keep in mind that a lot of
things depend on your analysis. Maybe your team can’t make
a decision without your report. Or maybe your initial data
work will determine how and where additional data will be gathered. You might remember that
we’ve talked about some situations where it’s important to
loop stakeholders in. For example, telling your project manager if you’re on
schedule or if you’re having a problem. Now, let’s look at a real-life example
where you need to communicate with stakeholders and what you might
do if you run into a problem. Let’s say you’re working on a project for
an insurance company. The company wants to identify common
causes of minor car accidents so that they can develop educational
materials that encourage safer driving. There’s a few early questions you and
your team need to answer. What driving habits will you
include in your dataset? How will you gather this data? How long will it take you to collect and clean that data before you can use
it in your analysis? Right away you want to communicate clearly with your
stakeholders to answer these questions, so you and your team can set a reasonable
and realistic timeline for the project. It can be tempting to tell your
stakeholders that you’ll have this done in no time, no problem. But setting expectations for a realistic
timeline will help you in the long run. Your stakeholders will know what to
expect when, and you won’t be overworking yourself and missing deadlines
because you overpromised. I find that setting expectations early
helps me spend my time more productively. So as you’re getting started, you’ll
want to send a high-level schedule with different phases of the project and
their approximate start dates. In this case, you and your teams
establish that you’ll need three weeks to complete analysis and
provide recommendations, and you let your stakeholders know so
they can plan accordingly. Now let’s imagine you’re further along in
the project and you run into a problem. Maybe drivers have opted into sharing data
about their phone usage in the car, but you discover that some sources count GPS
usage, and some don’t in their data. This might add time to your
data processing and cleaning and delay some project milestones. You’ll want to let your
project manager know and maybe work out a new timeline
to present to stakeholders. The earlier you can flag
these problems, the better. That way your stakeholders can make
necessary changes as soon as possible. Or what if your stakeholders want to add
car model or age as possible variables. You’ll have to communicate with them
about how that might change the model you’ve built, if it can be added and
before the deadlines, and any other obstacles that
they need to know so they can decide if it’s worth changing at
this stage of the project. To help them you might prepare a report on how their
request changes the project timeline or alters the model. You could also outline the pros and
cons of that change. You want to help your stakeholders achieve
their goals, but it’s important to set realistic expectations at
every stage of the project. This takes some balance. You’ve learned about balancing the needs
of your team members and stakeholders, but you also need to balance
stakeholder expectations and what’s possible with the projects, resources, and limitations. That’s why it’s important to be realistic
and objective and communicate clearly. This will help stakeholders
understand the timeline and have confidence in your ability
to achieve those goals. So we know communication is key and we have some good rules to follow
for our professional communication. Coming up we’ll talk even more about
answering stakeholder questions, delivering data and
communicating with your team.
Introduction
In any project, it is important to balance the expectations of the stakeholders with the realistic goals that can be achieved. This can be a challenging task, as there are often competing interests and priorities. However, by following some simple steps, it is possible to achieve a successful outcome.
Steps to balancing expectations and realistic project goals
- Understand the stakeholders’ expectations. The first step is to understand what the stakeholders are hoping to achieve from the project. This can be done by conducting interviews, holding workshops, or simply asking questions.
- Assess the realistic goals. Once you understand the stakeholders’ expectations, you need to assess whether they are realistic. This involves considering the available resources, the time constraints, and the technical complexity of the project.
- Negotiate a compromise. In many cases, it will not be possible to meet all of the stakeholders’ expectations. In these cases, you need to negotiate a compromise that everyone can agree on.
- Communicate the goals to the stakeholders. Once you have agreed on the goals, it is important to communicate them clearly to the stakeholders. This will help to avoid any misunderstandings or disappointments down the road.
- Track progress and make adjustments as needed. As the project progresses, it is important to track progress and make adjustments as needed. This will help to ensure that the project stays on track and meets the agreed-upon goals.
Tips for balancing expectations and realistic project goals
- Be clear and transparent about the project’s goals and limitations.
- Build trust and rapport with the stakeholders.
- Be flexible and willing to compromise.
- Communicate regularly and keep the stakeholders updated on progress.
- Be prepared to adjust the goals as needed.
Conclusion
Balancing expectations and realistic project goals is an essential skill for any project manager. By following the steps outlined above, you can increase your chances of success.
Here are some additional tips for balancing expectations and realistic project goals:
- Be realistic about the time and resources available.
- Break the project down into smaller, more manageable tasks.
- Set realistic deadlines and milestones.
- Be prepared for unexpected challenges.
- Communicate regularly with the stakeholders.
- Be flexible and willing to make changes.
By following these tips, you can increase your chances of success in any project.
When starting a new data analysis project, setting expectations for a realistic timeline might involve which of the following? Select all that apply.
- Communicating clearly with the project manager and other team members
- Creating a schedule with project phases and their approximate start dates
- Sharing a high-level schedule with stakeholders so they can plan accordingly
Setting expectations for a realistic timeline might involve sharing a high-level schedule with stakeholders, creating a schedule, and communicating clearly with team members.
Video: Sarah: How to communicate with stakeholders
- Set expectations with stakeholders. When working with stakeholders, it is important to set expectations from the start. This means being honest about the time and resources that will be needed to complete the project.
- Let the data tell the story. Data can be a powerful tool for storytelling, but it is important to let the data speak for itself. Avoid making assumptions or drawing conclusions that are not supported by the data.
- Be honest about the limitations of data. Data is not perfect. There will always be limitations to what data can tell us. Be honest with stakeholders about the limitations of data and how they may impact your analysis.
- Be confident in your findings. Even if you cannot 100% prove your theory, you can still be confident in your findings if they are supported by the data. Communicate your findings clearly and concisely, and be prepared to answer any questions that stakeholders may have.
- Take action. Even if you are not 100% sure of your findings, you can still take action. If you believe that your findings are correct, take action to address the issue. You can always revisit your findings later if new data becomes available.
- Be passionate about your work. If you are passionate about your work, it will show. Stakeholders will be more likely to trust and support your work if they can see that you are passionate about it.
By following these tips, you can improve your data analysis skills and communicate your findings effectively to stakeholders.
I’m Sarah and
I’m a senior analytical leader at Google. As a data analyst, there’s going
to be times where you have different stakeholders who have no idea about
the amount of time that it takes you to do each project, and in the very beginning
when I’m asked to do a project or to look into something, I always try
to give a little bit of expectation settings on the turn around
because most of your stakeholders don’t really understand what you do
with data and how you get it and how you clean it and
put together the story behind it. The other thing that I want to
make clear to everyone is that you have to make sure that
the data tells you the stories. Sometimes people think that
data can answer everything and sometimes we have to acknowledge
that that is simply untrue. I recently worked with a state to figure
out why people weren’t signing up for the benefits that they needed and
deserved. We saw people coming to the site and where they would sign up for those
benefits and see if they’re qualified. But for some reason there was something
stopping them from taking the step of actually signing up. So I was able to look into it using
Google Analytics to try to uncover what is stopping people from taking the action of
signing up for these benefits that they need and deserve. And so I go into Google Analytics, I see people are going back
between this service page and the unemployment page back to the service
page, back to the unemployment page. And so I came up with a theory that hey,
people aren’t finding the information that they need in order to take the next step
to see if they qualify for these services. The only way that I can actually know why someone left the site without
taking action is if I ask them. I would have to survey them. Google Analytics did not give
me the data that I would need to 100% back my theory or deny it. So when you’re explaining
to your stakeholders, “Hey I have a theory. This data is telling me a story. However I can’t 100% know due
to the limitations of data,” You just have to say it. So the way that I communicate that
is I say “I have a theory that people are not finding the information that
they need in order to take action. Here’s the proved points that I
have that support that theory.” So what we did was we then made it
a little bit easier to find that information. Even though
we weren’t 100% sure that my theory was correct, we were
confident enough to take action and then we looked back, and we saw all the metrics
that pointed me to this theory improve. And so that always feels really good when
you’re able to help a cause that you believe in do better,
and help more people through data. It makes all the nerdy learning about
SQL and everything completely worth it.
Video: The data tradeoff: Speed versus accuracy
- Speed and accuracy are not always the same thing. When communicating answers with your teams and stakeholders, it is important to balance speed and accuracy by making sure that you understand their needs and setting expectations clearly.
- Be clear and upfront about your limitations. If you cannot provide an accurate answer immediately, be honest with your stakeholders about the time it will take you to gather the necessary data.
- Be proactive in communicating with your stakeholders. Don’t wait for them to come to you with questions. Reach out to them regularly to keep them informed of your progress.
- Be open to feedback. Stakeholders may have valuable insights that can help you improve your work. Be open to their feedback and be willing to make changes as needed.
By following these tips, you can improve your communication with stakeholders and build stronger relationships.
We live in a world that
loves instant gratification, whether it’s overnight
delivery or on-demand movies. We want what we want
and we want it now. But in the data world, speed can sometimes be
the enemy of accuracy, especially when
collaboration is required. We’re going to talk
about how to balance speedy answers with
right ones and how to best address these issues by re-framing questions
and outlining problems. That way your team members and stakeholders understand
what answers they can expect when. As data analysts,
we need to know the why behind things
like a sales slump, a player’s batting average,
or rainfall totals. It’s not just about the figures, it’s about the context
too and getting to the bottom of these
things takes time. So if a stakeholder comes
knocking on your door, a lot of times that person may not really
know what they need. They just know they
want it at light speed. But sometimes the
pressure gets to us and even the most experienced
data analysts can be tempted to cut
corners and provide flawed or unfinished data
in the interest of time. When that happens, so much of the story in
the data gets lost. That’s why
communication is one of the most valuable tools
for working with teams. It’s important to start with structured thinking and a
well-planned scope of work, which we talked about earlier. If you start with a
clear understanding of your stakeholders’
expectations, you can then develop
a realistic scope of work that outlines agreed
upon expectations, timelines, milestones,
and reports. This way, your team always has a road map to
guide their actions. If you’re pressured for something that’s outside of the scope, you can feel confidence setting more realistic
expectations. At the end of the day, it’s your job to balance fast answers with
the right answers. Not to mention figuring out what the person is really asking. Now seems like a good
time for an example. Imagine your VP of HR shows
up at your desk demanding to see how many new hires are completing a training
course they’ve introduced. She says, “There’s no way people are going through
each section of the course. The human resources team
is getting slammed with questions. We should probably
just cancel the program.” How would you respond? Well, you could log
into the system, crunch some numbers, and hand
them to your supervisor. That would take no time at all. But the quick answer might
not be the most accurate one. So instead, you could
re-frame her question, outline the problem, challenges, potential solutions,
and time-frame. You might say, “I can certainly check out the rates
of completion, but I sense there may be
more to the story here. Could you give me two days to run some reports and learn
what’s really going on?” With more time, you
can gain context. You and the VP of HR decide to expand the
project timeline, so you can spend time gathering anonymous survey data from new employees about
the training course. Their answers provide data
that can help you pinpoint exactly why completion
rates are so low. Employees are reporting that the course feels
confusing and outdated. Because you were able to take time to address the
bigger problem, the VP of HR has a better idea about why
new employees aren’t completing the course and can make new decisions
about how to update it. Now the training course is
easy to follow and the HR department isn’t
getting as many questions. Everybody benefits. Redirecting the conversation
will help you find the real problem which leads to more insightful and
accurate solutions. But it’s important
to keep in mind, sometimes you need
to be the bearer of bad news and that’s okay. Communicating about problems,
potential solutions and different expectations
can help you move forward on a project
instead of getting stuck. When it comes to communicating answers with your teams
and stakeholders, the fastest answer and the most accurate answer aren’t
usually the same answer. But by making sure
that you understand their needs and setting
expectations clearly, you can balance
speed and accuracy. Just make sure to be clear and upfront and you’ll find success.
In data analysis, there is often a tradeoff between speed and accuracy. This means that the faster you want to analyze the data, the less accurate the results may be. And the more accurate you want the results to be, the longer it may take to analyze the data.
There are a few factors that can affect the speed and accuracy of data analysis. These include:
- The size of the dataset: The larger the dataset, the longer it will take to analyze it.
- The complexity of the analysis: The more complex the analysis, the longer it will take to complete.
- The computing resources available: The more computing resources you have, the faster you can analyze the data.
- The data analysis tools you use: Some data analysis tools are faster than others.
There are a few things you can do to improve the speed and accuracy of data analysis. These include:
- Use a smaller dataset: If you can, use a smaller dataset to analyze. This will reduce the amount of time it takes to analyze the data.
- Simplify the analysis: If you can, simplify the analysis. This will also reduce the amount of time it takes to analyze the data.
- Use more computing resources: If you have access to more computing resources, you can use them to speed up the analysis.
- Choose the right data analysis tools: Some data analysis tools are faster than others. Choose the tools that are best suited for your needs.
The best way to improve the speed and accuracy of data analysis is to find the right balance between the two. This will depend on the specific needs of your project.
Here are some additional considerations when making the speed-accuracy tradeoff in data analysis:
- The cost of errors: If inaccurate results could have serious consequences, then it is important to prioritize accuracy over speed.
- The urgency of the analysis: If the analysis needs to be completed quickly, then speed may be more important than accuracy.
- The availability of resources: If you have limited resources, then you may need to sacrifice accuracy in order to complete the analysis in a timely manner.
Ultimately, the decision of whether to prioritize speed or accuracy in data analysis is a judgment call that should be made on a case-by-case basis.
A data analyst reframes a question. Then, they outline the problem, challenges, potential solutions, and timeframe. This is done to achieve what goals? Select all that apply.
- Balance speed with accuracy
- Communicate expectations so stakeholders understand how long it will take to provide accurate information
- Put the data in context, and find the story it’s telling
A data analyst would use these techniques in order to put data into context, balance speed with accuracy, and keep stakeholders informed.
Reading: Limitations of data
Overview
Data is powerful, but it has its limitations. Has someone’s personal opinion found its way into the numbers? Is your data telling the whole story? Part of being a great data analyst is knowing the limits of data and planning for them. This reading explores how you can do that.
The case of incomplete (or nonexistent!) data
If you have incomplete or nonexistent data, you might realize during an analysis that you don’t have enough data to reach a conclusion. Or, you might even be solving a different problem altogether! For example, suppose you are looking for employees who earned a particular certificate but discover that certification records go back only two years at your company. You can still use the data, but you will need to make the limits of your analysis clear. You might be able to find an alternate source of the data by contacting the company that led the training. But to be safe, you should be up front about the incomplete dataset until that data becomes available.
Don’t miss misaligned data
If you’re collecting data from other teams and using existing spreadsheets, it is good to keep in mind that people use different business rules. So one team might define and measure things in a completely different way than another. For example, if a metric is the total number of trainees in a certificate program, you could have one team that counts every person who registered for the training, and another team that counts only the people who completed the program. In cases like these, establishing how to measure things early on standardizes the data across the board for greater reliability and accuracy. This will make sure comparisons between teams are meaningful and insightful.
Deal with dirty data
Dirty data refers to data that contains errors. Dirty data can lead to productivity loss, unnecessary spending, and unwise decision-making. A good data cleaning effort can help you avoid this. As a quick reminder, data cleaning is the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset. When you find and fix the errors – while tracking the changes you made – you can avoid a data disaster. You will learn how to clean data later in the training.
Tell a clear story
Avinash Kaushik, a Digital Marketing Evangelist for Google, has lots of great tips for data analysts in his blog: Occam’s Razor. Below are some of the best practices he recommends for good data storytelling:
- Compare the same types of data: Data can get mixed up when you chart it for visualization. Be sure to compare the same types of data and double check that any segments in your chart definitely display different metrics.
- Visualize with care: A 0.01% drop in a score can look huge if you zoom in close enough. To make sure your audience sees the full story clearly, it is a good idea to set your Y-axis to 0.
- Leave out needless graphs: If a table can show your story at a glance, stick with the table instead of a pie chart or a graph. Your busy audience will appreciate the clarity.
- Test for statistical significance: Sometimes two datasets will look different, but you will need a way to test whether the difference is real and important. So remember to run statistical tests to see how much confidence you can place in that difference.
- Pay attention to sample size: Gather lots of data. If a sample size is small, a few unusual responses can skew the results. If you find that you have too little data, be careful about using it to form judgments. Look for opportunities to collect more data, then chart those trends over longer periods.
Be the judge
In any organization, a big part of a data analyst’s role is making sound judgments. When you know the limitations of your data, you can make judgment calls that help people make better decisions supported by the data. Data is an extremely powerful tool for decision-making, but if it is incomplete, misaligned, or hasn’t been cleaned, then it can be misleading. Take the necessary steps to make sure that your data is complete and consistent. Clean the data before you begin your analysis to save yourself and possibly others a great amount of time and effort.
Video: Think about your process and outcome
- Data has the power to change the world. Data analytics can be used to identify new opportunities, improve efficiency, and make better decisions.
- When sharing data with your team, it is important to consider the following variables:
- The purpose of the data analysis. What do you hope to achieve by sharing the data?
- The audience for the data analysis. Who will be reading the report? What do they need to know?
- The format of the data analysis. How will you present the data?
- The level of detail in the data analysis. How much detail is necessary?
- By considering these variables, you can ensure that your data analysis is effective and that your team has the information they need to make informed decisions.
When you are working on a data analytics project, it is important to think about both your process and your outcome. Your process is the steps that you take to analyze the data, and your outcome is the results of your analysis.
Your process should be well-defined and reproducible. This means that you should be able to explain the steps that you took and why you took them. It also means that you should be able to repeat the analysis and get the same results.
Your outcome should be relevant and actionable. This means that your results should be meaningful and useful. They should also be something that you can act on.
Here are some tips for thinking about your process and outcome in data analytics:
- Start with a clear goal. What do you want to achieve with your data analysis? Once you know your goal, you can start to develop a process to achieve it.
- Choose the right tools. There are many different data analysis tools available. Choose the tools that are best suited for your needs and your budget.
- Clean your data. Before you start analyzing your data, you need to make sure that it is clean and accurate. This means removing any errors or inconsistencies in your data.
- Explore your data. Once your data is clean, you need to explore it to get a better understanding of it. This means looking at different visualizations of your data and asking questions about it.
- Build a model. Once you have explored your data, you can start to build a model. A model is a mathematical representation of your data. It can be used to make predictions or to understand the relationships between different variables.
- Test your model. Once you have built a model, you need to test it to make sure that it is accurate. This means using your model to make predictions on new data and comparing those predictions to the actual results.
- Communicate your results. Once you are satisfied with your results, you need to communicate them to others. This could involve writing a report, giving a presentation, or creating a visualization.
By following these tips, you can ensure that your data analytics projects are well-defined, reproducible, relevant, and actionable.
Here are some additional considerations when thinking about your process and outcome in data analytics:
- The quality of your data: The quality of your data will have a big impact on the outcome of your analysis. Make sure that your data is clean and accurate before you start analyzing it.
- The complexity of your analysis: The more complex your analysis, the longer it will take to complete and the more likely it is that you will make errors. Make sure that your analysis is appropriate for the amount of data that you have and the resources that you have available.
- The audience for your results: Who will be reading your report or presentation? What do they need to know? Tailor your communication to your audience.
Ultimately, the best way to think about your process and outcome in data analytics is to consider the specific needs of your project. By taking the time to plan your work and communicate your results, you can ensure that your data analytics projects are successful.
Data has the power to change the world. Think about this.
A bank identifies 15 new opportunities to promote a product,
resulting in $120 million in revenue. A distribution company figures out
a better way to manage shipping, reducing their cost by $500,000. Google creates a new tool that can
identify breast cancer tumors in nearby lymph nodes. These are all amazing achievements, but
do you know what they have in common? They’re all the results of data analytics. You absolutely have the power to
change the world as a data analyst. And it starts with how you
share data with your team. In this video, we will think through all of the variables
you should consider when sharing data. When you successfully
deliver data to your team, you can ensure that they’re able to
make the best possible decisions. Earlier we learned that speed can
sometimes affect accuracy when sharing database information with a team. That’s why you need a solid process
that weighs the outcomes and actions of your analysis. So where do you start? Well, the best solutions
start with questions. You might remember from our last video,
that stakeholders will have a lot of questions but it’s up to you to
figure out what they really need. So ask yourself, does your analysis
answer the original question? Are there other angles
you haven’t considered? Can you answer any questions that may
get asked about your data and analysis? That last question brings up
something else to think about. How detailed should you be
when sharing your results? Would a high level analysis be okay? Above all else, your data analysis
should help your team make better, more informed decisions. Here is another example: Imagine
a landscaping company is facing rising costs and they can’t stay
competitive in the bidding process. One question you could ask
to solve this problem is, can the company find new suppliers
without compromising quality? If you gave them a high-level analysis, you’d probably just include the number
of clients and cost of supplies. Here your stakeholder might object. She’s worried that reducing quality
will limit the company’s ability to stay competitive and keep customers happy. Well, she’s got a point. In that case, you need to provide a more
detailed data analysis to change her mind. This might mean exploring how
customers feel about different brands. You might learn that customers
don’t have a preference for specific landscape brands. So the company can change to the more
affordable suppliers without compromising quality. If you feel comfortable using the data
to answer all these questions and considerations, you’ve probably
landed on a solid conclusion. Nice! Now that you understand some of the
variables involved with sharing data with a team, like process and outcome, you’re
one step closer to making sure that your team has all the information they need
to make informed, data-driven decisions.
Practice Quiz: Test your knowledge on clear communication
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.
- What does my audience need to know?
- What does my audience already know?
- How can I communicate effectively to my audience?
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?
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?
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.
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?
Focusing on stakeholder expectations enables data analysts to achieve what goals? Select all that apply.
- Build trust
- Improve communication among teams
- Understand project goals
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?
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.
- Reframe the question
- Set clear expectations about timeframe
- Outline the problem
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?
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
- Consider the best ways to share data with others
- Help their team make informed, data-driven decisions
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.
Amazing teamwork
Video: Meeting best practices
Meetings are a big part of how we communicate with team members and stakeholders. They can be used to discuss project progress, build trust and team spirit, coordinate team goals, and get help when you run into problems.
Here are some best practices for productive meetings:
- Come prepared. Read the meeting agenda ahead of time and be ready to provide updates on your work. If you’re leading the meeting, prepare your notes and presentations and know what you’re going to talk about.
- Be on time. Show up early and set up beforehand so you’re ready to start when people arrive.
- Pay attention. Ask questions when you need clarification or think there may be a problem.
- Ask questions. Don’t be afraid to reach out after a meeting if you didn’t get to ask your question.
- Build and send out an agenda beforehand. This will help your team members come prepared and leave with clear takeaways.
- Keep everyone involved. Try to engage with all your attendees so you don’t miss out on any insights.
- Take notes. This will help you remember all questions that were asked and follow up with individual team members afterwards.
Here are some things to avoid in meetings:
- Showing up unprepared, late, or distracted.
- Dominating the conversation, talking over others, or distracting people with unfocused discussion.
- Not giving other team members a chance to talk or letting them finish their thought before you start speaking.
- Not giving everyone an opportunity to speak up, ask questions, call for expertise, and solicit their feedback.
- Not muting your phone or computer when you’re not speaking.
By following these best practices, you can help ensure that your meetings are productive and positive.
Meeting best practices in data analytics
Data analytics meetings are essential for sharing insights, collaborating on projects, and making decisions. However, poorly run meetings can be a waste of time and resources. By following some simple best practices, you can ensure that your data analytics meetings are productive and effective.
Before the meeting:
- Set a clear agenda. What do you want to achieve in the meeting? What topics need to be discussed? What decisions need to be made? Once you have a clear agenda, share it with the meeting participants in advance so that they can come prepared.
- Invite the right people. Only invite people who are essential to the meeting and who have something to contribute. This will help to keep the meeting focused and avoid wasting time.
- Prepare your materials. If you will be presenting or leading a discussion, make sure to prepare your materials in advance. This will help you to stay on track and deliver your presentation effectively.
During the meeting:
- Start and end on time. Respect the time of your meeting participants by starting and ending the meeting on time.
- Encourage participation. Make sure that everyone has a chance to participate in the meeting. This may involve asking open-ended questions, facilitating discussion, and encouraging dissenting opinions.
- Stay on track. It is easy to get sidetracked in data analytics meetings. However, it is important to stay on track and focus on the agenda. If a discussion gets off track, gently redirect it back to the main topic.
- Document the meeting. Take notes or record the meeting so that you have a record of what was discussed and what decisions were made. This will help you to follow up on action items and ensure that everyone is on the same page.
After the meeting:
- Send out meeting notes. Send out meeting notes to all participants as soon as possible after the meeting. This will help to ensure that everyone is on the same page and that any action items are clear.
- Follow up on action items. Make sure to follow up on any action items that were assigned during the meeting. This will help to ensure that progress is made and that the team is on track to meet its goals.
By following these best practices, you can ensure that your data analytics meetings are productive and effective.
Here are some additional tips for running successful data analytics meetings:
- Use data visualization tools. Data visualization tools can help to make your presentation more engaging and easier to understand.
- Be clear and concise. Avoid using jargon and technical terms that your audience may not understand.
- Tell stories. Stories can be a powerful way to communicate your insights and engage your audience.
- Be open to feedback. Encourage your audience to ask questions and share their thoughts.
By following these tips, you can run data analytics meetings that are informative, engaging, and productive.
Now it’s time to
discuss meetings. Meetings are a huge
part of how you communicate with team
members and stakeholders. Let’s cover some easy-to-follow
do’s and don’ts, you can use for meetings
both in person or online so that you can use these communication best
practices in the future. At their core, meetings make
it possible for you and your team members
or stakeholders to discuss how a project is going. But they can be so
much more than that. Whether they’re
virtual or in person, team meetings can build
trust and team spirit. They give you a chance
to connect with the people you’re working
with beyond emails. Another benefit is that knowing who you’re
working with can give you a better perspective of where your work fits into
the larger project. Regular meetings also make it easier to
coordinate team goals, which makes it easier to
reach your objectives. With everyone on the same page, your team will be in the
best position to help each other when you
run into problems too. Whether you’re leading a
meeting or just attending it, there are best practices you can follow to make sure your
meetings are a success. There are some
really simple things you can do to make
a great meeting. Come prepared, be on time, pay attention, and ask questions. This applies to both meetings you lead and ones you attend. Let’s break down
how you can follow these to-dos for every meeting. What do I mean when
I say come prepared? Well, a few things. First, bring what you need. If you like to take notes, have your notebook and pens in your bag or your
work device on hand. Being prepared also means you should read the
meeting agenda ahead of time and be ready to provide
any updates on your work. If you’re leading the meeting, make sure to prepare your
notes and presentations and know what you’re going
to talk about and of course, be ready to answer questions. These are some other tips that I like to follow when
I’m leading a meeting. First, every meeting
should focus on making a clear decision and include the person needed to
make that decision. And if there needs to be a
meeting in order to make a decision, schedule
it immediately. Don’t let progress stall by waiting until next
week’s meeting. Lastly, try to keep the number of people at your meeting
under 10 if possible. More people makes it hard to have a collaborative discussion. It’s also important to respect
your team members’ time. The best way to do this is
to come to meetings on time. If you’re leading the meeting, show up early and set up beforehand so you’re ready
to start when people arrive. You can do the same thing
for online meetings. Try to make sure your technology
is working beforehand and that you’re watching
the clock so you don’t miss a meeting
accidentally. Staying focused and attentive
during a meeting is another great way to respect
your team members’ time. You don’t want to miss something important
because you were distracted by something
else during a presentation. Paying attention also means asking questions when
you need clarification, or if you think there may be a problem with a project plan. Don’t be afraid to reach
out after a meeting. If you didn’t get to
ask your question, follow up with the group
afterwards and get your answer. When you’re the person
leading the meeting, make sure you build and send
out an agenda beforehand, so your team members
can come prepared and leave with clear takeaways. You’ll also want to
keep everyone involved. Try to engage with all
your attendees so you don’t miss out on any insights
from your team members. Let everyone know
that you’re open to questions after the meeting too. It’s a great idea to take notes even when you’re
leading the meeting. This makes it easier to remember all questions
that were asked. Then afterwards you can follow up with individual team
members to answer those questions or
send an update to your whole team depending on
who needs that information. Now let’s go over what
not to do in meetings. There are some
obvious “don’ts” here. You don’t want to
show up unprepared, late, or distracted for meetings. You also don’t want to
dominate the conversation, talk over others, or distract people with unfocused discussion. Try to make sure you give
other team members a chance to talk and always let them finish their thought before
you start speaking. Everyone who is attending your meeting should be
giving their input. Provide opportunities
for people to speak up, ask questions, call
for expertise, and solicit their feedback. You don’t want to miss out on their valuable insights.
And try to have everyone put their phones or
computers on silent when they’re not speaking,
you included. Now we’ve learned some
best practices you can follow in meetings
like come prepared, be on time, pay attention,
and ask questions. We also talked about
using meetings productively to make
clear decisions and promoting collaborative
discussions and to reach out after a meeting to address questions you or
others might have had. You also know what not to do in meetings: showing up unprepared, late, or distracted, or talking over others and
missing out on their input. With these tips in mind, you’ll be well on your way to productive, positive
team meetings. But of course, sometimes there will be conflict
in your team. We’ll discuss conflict
resolution soon.
When you’re leading a meeting, what are some ways to make sure all participants have a positive experience? Select all that apply.
- Take notes on what’s discussed during the meeting.
- Prepare notes, a presentation, and an agenda to share with attendees.
- Test out any technology you plan to use ahead of time to make sure it’s working properly.
When leading a meeting, testing out technology, taking notes and preparing supporting materials will help you ensure all participants have a positive experience.
Video: Ximena: Joining a new team
Ximena shares her experience of joining a new team at Google and how she overcame the obstacle of ambiguity in her projects. She emphasizes the importance of communication and setting clear goals. She advises new team members to ask questions and clarify expectations before starting a project.
[MUSIC] Joining a new team was definitely
scary at the beginning. Especially at a company like
Google where it’s really big and everyone is extremely smart. But I really leaned on my manager
to understand what I could bring to the table. And that made me feel a lot more
comfortable in meetings while sharing my abilities. I found that my best projects start off
when the communication is really clear about what’s expected. If I leave the meeting
where the project has been asked of me knowing exactly where
to start and what I need to do, that allows for me to get it done faster,
more efficiently, and getting to the real goal of it and maybe going an extra step further
because I didn’t have to spend any time confused on what I needed to be doing. Communication is so important because
it gets you to the finish line the most efficiently and
also makes you look really good. When I first started I had a good
amount of projects thrown at me and I was really excited. So, I went into them without
asking too many questions. At first that was an obstacle,
because while you can thrive in ambiguity, ambiguity as to what the project
objective is, can be really harmful when you’re actually trying
to get the goal done. And I overcame that by simply taking
a step back when someone asks me to do the project and
just clarifying what that goal was. Once that goal was crisp, I was happy to go into
the ambiguity of how to get there, but the goal has to be really objective and clear. I’m Ximena and I’m a Financial Analyst.
Reading: Leading great meetings
Reading
One day soon, you might find yourself planning a meeting in your role as a data analyst. Great things can happen when participants anticipate a well-executed meeting. Attendees show up on time. They aren’t distracted by their laptops and phones. They feel like their time will be well spent. It all comes down to good planning and communication of expectations. The following are our best practical tips for leading meetings.
Before the meeting
If you are organizing the meeting, you will probably talk about the data. Before the meeting:
- Identify your objective. Establish the purpose, goals, and desired outcomes of the meeting, including any questions or requests that need to be addressed.
- Acknowledge participants and keep them involved with different points of view and experiences with the data, the project, or the business.
- Organize the data to be presented. You might need to turn raw data into accessible formats or create data visualizations.
- Prepare and distribute an agenda. We will go over this next.
Crafting a compelling agenda
A solid meeting agenda sets your meeting up for success. Here are the basic parts your agenda should include:
- Meeting start and end time
- Meeting location (including information to participate remotely, if that option is available)
- Objectives
- Background material or data the participants should review beforehand
Here’s an example of an agenda for an analysis project that is just getting started:
Sharing your agenda ahead of time
After writing your agenda, it’s time to share it with the invitees. Sharing the agenda with everyone ahead of time helps them understand the meeting goals and prepare questions, comments, or feedback. You can email the agenda or share it using another collaboration tool.
During the meeting
As the leader of the meeting, it’s your job to guide the data discussion. With everyone well informed of the meeting plan and goals, you can follow these steps to avoid any distractions:
- Make introductions (if necessary) and review key messages
- Present the data
- Discuss observations, interpretations, and implications of the data
- Take notes during the meeting
- Determine and summarize next steps for the group
After the meeting
To keep the project and everyone aligned, prepare and distribute a brief recap of the meeting with next steps that were agreed upon in the meeting. You can even take it a step further by asking for feedback from the team.
- Distribute any notes or data
- Confirm next steps and timeline for additional actions
- Ask for feedback (this is an effective way to figure out if you missed anything in your recap)
A final word about meetings
Even with the most careful planning and detailed agendas, meetings can sometimes go off track. An emergency situation might steal people’s attention. A recent decision might unexpectedly change requirements that were previously discussed and agreed on. Action items might not apply to the current situation. If this happens, you might be forced to shorten or cancel your meeting. That’s all right; just be sure to discuss anything that impacts your project with your manager or stakeholders and reschedule your meeting after you have more information.
Video: From conflict to collaboration
- Conflict is a normal part of work life.
- There are many reasons why conflict can happen, such as mismatched expectations, miscommunication, and different work styles.
- It’s important to stay objective and focused on the team’s goals when conflict arises.
- One way to resolve conflict is to re-frame the problem and focus on finding a solution.
- Discussion is key to conflict resolution.
- If you find yourself feeling emotional, take some time to cool off before communicating with the other person involved.
- Try to understand the context of the other person’s request.
- By turning moments of potential conflict into opportunities to collaborate, you can resolve tension and get your project back on track.
Here are some additional tips for resolving conflict:
- Be respectful and listen to the other person’s point of view.
- Be willing to compromise.
- Focus on the future and how to move forward together.
- If you can’t resolve the conflict on your own, seek help from a manager or mediator.
It’s normal for conflict to
come up in your work life. A lot of what you’ve
learned so far, like managing expectations
and communicating effectively can help
you avoid conflict, but sometimes you’ll run
into conflict anyways. If that happens,
there are ways to resolve it and move forward. In this video, we will talk
about how conflict could happen and the best ways you can practice
conflict resolution. A conflict can pop up
for a variety of reasons. Maybe a stakeholder misunderstood the possible outcomes
for your project; maybe you and your
team member have very different work styles; or maybe an important deadline is approaching and
people are on edge. Mismatched expectations
and miscommunications are some of the most common
reasons conflicts happen. Maybe you weren’t clear
on who was supposed to clean a dataset and
nobody cleaned it, delaying a project. Or maybe a teammate sent out an email with all of your
insights included, but didn’t mention
it was your work. While it can be easy to
take conflict personally, it’s important to
try and be objective and stay focused on
the team’s goals. Believe it or not,
tense moments can actually be opportunities to re-evaluate a project and
maybe even improve things. So when a problem comes up, there are a few ways you
can flip the situation to be more productive
and collaborative. One of the best
ways you can shift a situation from
problematic to productive is to just re-frame
the problem. Instead of focusing on what went
wrong or who to blame, change the question
you’re starting with. Try asking, how can I
help you reach your goal? This creates an opportunity for you and your
team members to work together to find a
solution instead of feeling frustrated
by the problem. Discussion is key to
conflict resolution. If you find yourself
in the middle of a conflict, try to communicate, start a conversation
or ask things like, are there other important
things I should be considering? This gives your team members or stakeholders a chance to
fully lay out your concerns. But if you find yourself
feeling emotional, give yourself some time
to cool off so you can go into the conversation
with a clearer head. If I need to write an email
during a tense moment, I’ll actually save it to drafts and come back to
it the next day to reread it before sending to make sure that I’m
being level-headed. If you find you don’t
understand what your team member or stakeholder
is asking you to do, try to understand the
context of their request. Ask them what their end goal is, what story they’re
trying to tell with the data or what
the big picture is. By turning moments of
potential conflict into opportunities to collaborate
and move forward, you can resolve tension and get your project
back on track. Instead of saying, “There’s
no way I can do that in this time frame,” try to
re-frame it by saying, “I would be happy to do that, but I’ll just take
this amount of time, let’s take a step back so I can better understand
what you’d like to do with the data and we
can work together to find the best path forward.” With that, we’ve reached
the end of this section. Great job. Learning how to work with new team members can be a
big challenge in starting a new role or a new project but with the skills you’ve
picked up in these videos, you’ll be able to start on the right foot with
any new team you join. So far, you’ve learned
about balancing the needs and expectations of your team
members and stakeholders. You’ve also covered
how to make sense of your team’s roles and focus
on the project objective, the importance of clear communication
and communication expectations in a workplace, and how to balance the limitations of data
with stakeholder asks. Finally, we covered how to have effective team meetings and how to resolve
conflicts by thinking collaboratively with
your team members. Hopefully now you
understand how important communication is to the
success of a data analyst. These communication skills
might feel a little different from some of the other skills you’ve been
learning in this program, but they’re also an
important part of your data analyst toolkit and your success as a
professional data analyst. Just like all of the other skills you’re
learning right now, your communication
skills will grow with practice and experience.
From conflict to collaboration in data analytics
Data analytics teams often work on complex and challenging projects. This can lead to disagreements and conflict, which is normal. However, it is important to manage conflict effectively in order to maintain a productive and collaborative work environment.
Here are some tips on how to move from conflict to collaboration in data analytics:
- Acknowledge the conflict. The first step is to acknowledge that there is a conflict. Don’t try to ignore it or pretend that it doesn’t exist.
- Identify the root cause. Once you have acknowledged the conflict, try to identify the root cause. What are the underlying issues that are causing the disagreement?
- Be respectful. Even if you disagree with someone, it is important to be respectful. Avoid personal attacks and focus on the issues at hand.
- Listen actively. When the other person is speaking, listen actively. Try to understand their perspective and why they feel the way they do.
- Be open to compromise. It is unlikely that you will get everything you want in a conflict. Be open to compromise and finding a solution that works for everyone.
- Focus on the common goal. Remember that you are all working towards a common goal: to produce high-quality data analytics. Focus on this common goal when trying to resolve the conflict.
Here are some additional tips that can be helpful in data analytics teams specifically:
- Use data to support your arguments. Data can be a powerful tool for resolving conflict. When you are making an argument, try to support it with data. This will help to ensure that your argument is well-reasoned and persuasive.
- Be willing to admit when you are wrong. Everyone makes mistakes. If you are wrong about something, be willing to admit it. This will help to build trust and respect within your team.
- Celebrate successes. When you successfully resolve a conflict, take the time to celebrate your success. This will help to reinforce positive behavior and build a more collaborative team culture.
By following these tips, you can help to manage conflict effectively and create a more collaborative data analytics team.
To shift a situation from problematic to productive, data analysts can reframe a problem and start a constructive conversation. Which of the following statements are effective for doing that? Select all that apply.
- I would be happy to do this project. I will consider the necessary steps and get back to you soon with a time estimate.
- There may be some other important things I should consider. I’m going to look into that.
- I’d like to help you reach your goal. Let’s discuss how I can do that.
Asking questions such as these will give everyone the chance to share their viewpoints in a productive manner. This leads to a more successful project.
Video: Nathan: From the U.S. Marine Corps to data analytics
- Nathan is a principal data analyst in the Trust and Safety Organization at Google.
- He joined the Marine Corps Reserves while attending college.
- He was deployed to Iraq as a truck driver.
- After he got back from Iraq, he finished his bachelor’s degree and worked as an applications engineer.
- He eventually pivoted to focus more on business and fell in love with data analysis.
- He took a Coursera course on R and did some data science hackathons to prepare himself for a career in data analysis.
- His first job as a data analyst was at a large bank.
- He is now a principal data analyst at Google.
- The things that were instilled in him in the Marines that he uses to this very day would be attention to detail, communication, and collaboration.
Here are some additional tips from Nathan for aspiring data analysts:
- Take online courses and do hackathons to gain experience.
- Be persistent and don’t give up.
- Be willing to learn new things.
- Be a team player.
[MUSIC]
Hey, I’m Nathan. I’m a principal data analyst in the Trust
and Safety Organization at Google. I joined the Marine Corps Reserves
when I was attending college, and the reserve unit I joined
was a field artillery unit. So after a challenging
Marine Corps boot camp, I went to field artillery fire direction
control school. And for those of you that might
not know, fire direction control is considered the brains
of field artillery, and we use all sorts of computers to
do our artillery calculations. But just in case the computers went down, we also were trained how to
use slide rules as a backup. And then, a year later,
I had the opportunity to be activated as a truck driver instead of my primary
job as a field artillery man and was deployed to Iraq to drive trucks for
an infantry company. After I got back from Iraq,
I finished up my bachelor’s degree and then worked as an applications
engineer in Austin, Texas, and eventually saw the need to pivot
more to focus more on business. And that’s when I really fell in
love with data analysis was when I was learning a lot more about business. It actually took me a couple of years,
when I really sparked an interest in data analysis to land a role where
I got to do it full time and really get my hands dirty with the data. Some of the things I did to lay
the groundwork to be ready and be qualified for that was I took a
Coursera course on R and I also did some data science hackathons where you spend
an entire weekend at some university. And they release the dataset Friday
night and by Sunday afternoon, you have to come up with
some recommendations. So those were two really good
ways to really prepare myself, get good experience and really show
a strong interest in data analysis. My first job,
where I got to do data analysis full-time was at a large bank and
I was just in heaven. I got to really do SQL for real, and also I got to use Tableau a ton.
Got to go to a Tableau conference. It was really cool. Then I was fortunate enough to
get an opportunity to move to Google into my current role. That’s in trust and safety. And what’s super exciting and fulfilling about that is that
similar to the military, it has an overall mission of protecting
people, so that’s super exciting for me. The things that were instilled in me in the Marines that I use to this very
day would be attention to detail. That’s super important in
the military overall, but especially in field artillery. Secondly,
is the importance of communication. You have your own details locked in. You need to make sure that those
are communicated really clearly to other people that you’re working with and
the third would be collaboration. In the military teamwork
makes the dream work. You really rely on the team. That’s definitely been the case in my
post Marine Corps career and jobs.
Practice Quiz: Test your knowledge on teamwork
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 can you take next that demonstrate a responsibility to move the project forward? Select all that apply.
Do some additional research to better understand the context of the request.
Schedule a time to ask your supervisor more questions about the big picture goals.
Doing additional research and asking questions are effective ways to determine how to proceed with a new project.
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.
False
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.
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?
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.
The best course of action is to email the director to politely explain the timeline required to complete the report properly.
Weekly challenge 4
Reading: Glossary: Terms and definitions
Data Analytics
A
Action-oriented question: A question whose answers lead to change
Algorithm: A process or set of rules followed for a specific task
Analytical skills: Qualities and characteristics associated with using facts to solve problems
Analytical thinking: The process of identifying and defining a problem, then solving it by using
data in an organized, step-by-step manner
Attribute: A characteristic or quality of data used to label a column in a table
AVERAGE: A spreadsheet function that returns an average of the values from a selected range
B
Big data: Large, complex datasets typically involving long periods of time, which enable data
analysts to address far-reaching business problems
Borders: Lines that can be added around two or more cells on a spreadsheet
Business task: The question or problem that data analysis resolves for a business
C
Cell reference: A cell or a range of cells in a worksheet typically used in formulas and functions
Cloud: A place to keep data online, rather than a computer hard drive
Context: The condition in which something exists or happens
COUNT: A spreadsheet function that counts the number of cells in a range that meet a specific
criteria
D
Dashboard: A tool that monitors live, incoming data
Data: A collection of facts
Data analysis: The collection, transformation, and organization of data in order to draw
conclusions, make predictions, and drive informed decision-making
Data analysis process: The six phases of ask, prepare, process, analyze, share, and act
whose purpose is to gain insights that drive informed decision-making
Data analyst: Someone who collects, transforms, and organizes data in order to draw
conclusions, make predictions, and drive informed decision-making
Data analytics: The science of data
Data design: How information is organized
Data-driven decision-making: Using facts to guide business strategy
Data ecosystem: The various elements that interact with one another in order to produce,
manage, store, organize, analyze, and share data
Data-inspired decision-making: Exploring different data sources to find out what they have in
common
Data life cycle: The sequence of stages that data experiences, which include plan, capture,
manage, analyze, archive, and destroy
Data science: A field of study that uses raw data to create new ways of modeling and
understanding the unknown
Data strategy: The management of the people, processes, and tools used in data analysis
Data visualization: The graphical representation of data
Database: A collection of data stored in a computer system
Dataset: A collection of data that can be manipulated or analyzed as one unit
E
Equation: A calculation that involves addition, subtraction, multiplication, or division (also called
a math expression)
F
Fairness: A quality of data analysis that does not create or reinforce bias
Fill handle: A box in the lower-right-hand corner of a selected spreadsheet cell that can be
dragged through neighboring cells in order to continue an instruction
Filtering: The process of showing only the data that meets a specified criteria while hiding the
rest
Formula: A set of instructions used to perform a calculation using the data in a spreadsheet
Function: A preset command that automatically performs a specified process or task using the
data in a spreadsheet
G
Gap analysis: A method for examining and evaluating the current state of a process in order to
identify opportunities for improvement in the future
H
Header: The first row in a spreadsheet that labels the type of data in each column
I
J
K
L
Leading question: A question that steers people toward a certain response
M
Math expression: A calculation that involves addition, subtraction, multiplication, or division
(also called an equation)
Math function: A function that is used as part of a mathematical formula
MAX: A spreadsheet function that returns the largest numeric value from a range of cells
Measurable question: A question whose answers can be quantified and assessed
Metric: A single, quantifiable type of data that is used for measurement
Metric goal: A measurable goal set by a company and evaluated using metrics
MIN: A spreadsheet function that returns the smallest numeric value from a range of cells
N
O
Observation: The attributes that describe a piece of data contained in a row of a table
Open data: Data that is available to the public
Operator: A symbol that names the operation or calculation to be performed
Order of operations: Using parentheses to group together spreadsheet values in order to
clarify the order in which operations should be performed
P
Pivot chart: A chart created from the fields in a pivot table
Pivot table: A data summarization tool used to sort, reorganize, group, count, total, or average
data
Problem domain: The area of analysis that encompasses every activity affecting or affected by
a problem
Problem types: The various problems that data analysts encounter, including categorizing
things, discovering connections, finding patterns, identifying themes, making predictions, and
spotting something unusual
Q
Qualitative data: A subjective and explanatory measure of a quality or characteristic
Quantitative data: A specific and objective measure, such as a number, quantity, or range
Query: A request for data or information from a database
Query language: A computer programming language used to communicate with a database
R
Range: A collection of two or more cells in a spreadsheet
Reframing: Restating a problem or challenge, then redirecting it toward a potential resolution
Relevant question: A question that has significance to the problem to be solved
Report: A static collection of data periodically given to stakeholders
Return on investment (ROI): A formula that uses the metrics of investment and profit to
evaluate the success of an investment
Revenue: The total amount of income generated by the sale of goods or services
Root cause: The reason why a problem occurs
S
Scope of work (SOW): An agreed-upon outline of the tasks to be performed during a project
Small data: Small, specific data points typically involving a short period of time, which are
useful for making day-to-day decisions
SMART methodology: A tool for determining a question’s effectiveness based on whether it is
specific, measurable, action-oriented, relevant, and time-bound
Sorting: The process of arranging data into a meaningful order to make it easier to understand,
analyze, and visualize
Specific question: A question that is simple, significant, and focused on a single topic or a few
closely related ideas
Spreadsheet: A digital worksheet
SQL: Refer to Structured Query Language
Stakeholders: People who invest time and resources into a project and are interested in its
outcome
Structured Query Language: A computer programming language used to communicate with a
database
Structured thinking: The process of recognizing the current problem or situation, organizing
available information, revealing gaps and opportunities, and identifying options
SUM: A spreadsheet function that adds the values of a selected range of cells
T
Technical mindset: The ability to break things down into smaller steps or pieces and work with
them in an orderly and logical way
Time-bound question: A question that specifies a timeframe to be studied
Turnover rate: The rate at which employees voluntarily leave a company
U
Unfair question: A question that makes assumptions or is difficult to answer honestly
V
Visualization: (Refer to data visualization)
W
X
Y
Z
Quiz: *Weekly challenge 4*
Fill in the blank: Your data analytics team is working on a project for the marketing department. The person most likely to be the _____ stakeholder is the vice president of marketing.
primary
At an online marketplace, the _____ includes anyone in an organization who interacts with current or potential shoppers.
customer-facing team
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 communicate clearly with stakeholders and team members.
True
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.
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?
Sample size
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.
Think about what project updates they should share.
Bring materials for taking notes.
Plan to arrive on time.
When participating in an online meeting, it’s okay to keep your email 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.
False
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 is their end goal?
What is the big picture?
What is the story they want to tell?
Course challenge
Quiz: *Course challenge*
Scenario 1, questions 1-5
You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community.
Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible.
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.
Respect your supervisor’s time by writing an email that’s short and to the point.
Use a polite greeting and closing.
Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear.
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.
The data in column F (Survey Q6: What types of books would you like to see more of at Athena’s Story?) is quantitative.
False
Scenario 1 continued
Next, you review the customer feedback in column F of the Customer Survey dataset.
The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena’s Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign.
Your visualization looks like this:
Pie chart categories: Feminist science fiction 4.8% Books about women 2.4% Women’s journals 2.4% Feminist literary criticism 2.4% Children’s literature 15.5% Women’s history books 2.4% Biographies of inspiration 20.2% Feminist fiction 26.2% Feminist zines 14.3% Feminist poetry 4.6% Feminist novels 3.6%
Fill in the blank: The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a _____ chart.
pie
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 feminist zines. You type =CALCULATE(E2-E53) but get an error. What is the correct syntax?
=SUM(E2:E53)
Scenario 1 continued
After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created.
In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines.
Using historical data to make informed decisions about how things may be in the future is an example of making predictions.
False
Question 6
Scenario 2, questions 6-10
You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus.
As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Secondary stakeholders are also typically responsible for managing the data.
Based on what you find in the organizational chart, which of the stakeholders are responsible for managing the data? Select all that apply.
Data analytics coordinator
Vice president, data and strategy
Scenario 2 continued
Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply.
Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey. Select all that apply.
Was this your first time using Patel Events Plus to plan your event? Yes or no?
How would you rate your overall experience — poor, average, above average, or excellent?
Did you experience any problems with your event? Yes or no?
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?
Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.
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?
Dashboard
Scenario 2 continued
Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of a Patel Events dataset.
Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, the metrics to consider would be the cost of the investment and what else?
Net profit in 2019
Video: Congratulations!
In the first step of the data analysis process, you learned how to:
- Ask effective questions
- Use quantitative and qualitative data, metrics, and math to connect the dots
- Apply spreadsheet basics
- Apply structured thinking
- Use key communication skills for working with stakeholders and team members
In the next course, you will learn about the next step of the data analysis process, preparing your data. You will learn about:
- Data types and data structures
- Bias and credibility in analytics
- Databases
- Organizing and protecting your data
- The data community
Congratulations on completing the first step of the data analysis process!
Now that you’re done,
you’re officially ready to take on the next course. Awesome job. But before I tell you
about what’s ahead, let’s take a moment to think
about what we’ve covered so far in the first step of
the data analysis process. In this course, we explored
effective questions and we learned how to use quantitative and
qualitative data, metrics and math to
connect the dots. We also covered
spreadsheet basics, how to apply structured thinking and key communication skills for working with stakeholders and
team members. That’s a lot! Now it’s time to take what you learned into the next course, where you’ll tackle
the next step of the data analysis process,
prepare your data. Hallie is going to
take over from here. You might remember her from the beginning of
the first course! She’ll guide you as you
learn new important tools for your work, like data
types and data structures; bias and credibility
in analytics; databases; organizing and
protecting your data; and the data community. Thanks for sticking with
me through this course. When you’re ready, you can go ahead to the first video
in the next course. Good luck. You’re
going to do great.
Reading: Coming up next…
Reading
Congratulations on completing the second course in the Google Data Analytics Certificate!
To make continuing with the program easy, go to the next course by clicking this link: Prepare Data for Exploration.
Keep up the great work!