SOLUTION QUESTIONS AND CORRECT ANSWERS Western
Governors University
Scored questions 70
Failed questions 0
Your answers
1 of 70
Term
A data analyst is working with a diverse team that includes
managers, administrators, and other analysts who have
competing needs and opinions.Which best practice should the
analyst apply to balance these stakeholders' needs while
collaborating on the project?
Give this one a try later!
, Begin data collection for Decide on timelines based on
primary decision-makers manager needs
Focus on the project Maintain the initial timeline
objectives to solve a despite obstacles
specific problem
Don't know?
2 of 70
Term
An analyst is reviewing a large Microsoft Excel spreadsheet
that uses various row colors.Which functionality would help
the analyst
organize the data by color?
Give this one a try later!
Reviewing the Adding comments based on cell
sheet using color
color
Sorting by cell color Formatting color choice
Don't know?
3 of 70
,Term
How does a data analyst effectively communicate with
analytics team members while balancing project
expectations?
Give this one a try later!
Organize data visualization of Discuss expected high-
major concepts level decision-making
Explain the data science role Share targeted project
with the project team timeline updates
Don't know?
4 of 70
Term
During a stakeholder meeting, the client insists on assessing
what the data will look like with different influencing
elements stored in the database. Which tool does the
analyst need in order to extract and manipulate large
data sets to meet the client's requirements?
Give this one a try later!
Microsoft Excel Microsoft Power BI
, SQL (Structured
Query Language) Tableau
Don't know?
5 of 70
Term
An analyst is approached by a marketing director with
an urgent request for data analysis due within a day.
The analyst has helpful ideas about streamlining the
analysis but may not be able to make the requested
deadline. How should the analyst communicate with the
marketing director?
Give this one a try later!
Conduct analysis to
meet the requested Delegate the work to another team
deadline
Engage executive team in
needs analysis Recommend a revised strategy
Don't know?
6 of 70
Term