discovery data 3

Which of the following statements correctly describe dashboards and reports? Select all that apply.

*A sales dashboard could be used to track daily e-commerce sales. *Dashboards are useful for data visualization.

Which of the following are best practices that data professionals can use in order to help ensure an effective online meeting? Select all that apply.

*Ask questions if you need more information or clarification *Join the meeting from a quiet area *Confirm your technology is functional

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

*Consider what questions you may be asked so you are prepared to answer *Bring materials to take notes with *Read the meeting agenda ahead of time

Which of the following statements accurately describe structured thinking and the problem domain? Select all that apply.

*Determining a problem domain helps make it possible to establish requirements. *The starting place for structured thinking is the problem domain.

What are some common focus areas when creating a scope of work as a data analyst? Select all that apply.

*Establish an agreed-upon outline of the work to be performed *Include key information about data validation *Note when the client can expect reports

Which of the following questions are open-ended? Select all that apply

*How would you describe this movie? *What are you most looking forward to in the coming year?

For what reasons would it be unfair for a human resources manager to ask employees, "Why do you love working for our company?" Select all that apply.

*It makes assumptions *It is a leading question

What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

*Less efficient decision-making time frames *There may be gaps in big data business tools *Difficulty finding important data

Which of the following statements accurately describe qualitative and quantitative data? Select all that apply.

*Qualitative data describes explanatory assessments of qualities. *Quantitative data involves specific and objective measures.

Which of the following statements correctly describe the SMART methodology? Select all that apply

*Relevant questions lead to answers that help solve the problem. *SMART stands for specific, measurable, action-oriented, relevant, and time-bound. *Time-bound questions specify the time to be studied.

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 the story they want to tell? *What is their end goal?

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

*Who is my audience? *How can I communicate effectively to my audience? *What does my audience need to know?

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

*think about what project updates you should share *Plan to arrive on time

What is the formula for dividing the value in spreadsheet cell H7 by the value in cell H4?

=H7/H4

In this spreadsheet, which SUM function will add all of the values between cells E1 and F6?

=SUM(E1:F6)

A data analyst working for a health care provider is asked to determine which clinics are most efficient and which are least efficient. They review performance data, then group the clinics accordingly. Which data problem type does this scenario describe?

Categorizing things

Question 5 Company decision-makers at a gas utility want to improve business performance. How could they use metrics and a metric goal to help them do so?

Create a metric goal as the business objective. Then, evaluate it using metrics.

A data team at a community center automates a process to segment clients. First, a list of all clients is compiled. Then, they are sorted by the classes they have taken and events attended. Finally, clients are segmented by their activity histories. What does this scenario describe?

Creating an algorithm

The supplier of a key component of a variety of products has a quality control issue. This causes problems for both the supplier and the manufacturing companies that use the component in their products. All of the affected businesses discuss the issues they face and share data openly, ultimately discovering they have many similar challenges. What data problem type are they solving?

Discovering connections

In this spreadsheet, what should be done to correct the DIV error in cell D2?#DIV/0!

Ensure the formula is not trying to divide by zero or an empty cell.

When working with big data, analysts consider the veracity of the data within large, complex datasets. What does this entail?

Evaluating the quality and reliability of the data

A data professional sorts manufacturing production data by facility. Then, they group that information into broader concepts, such as the type of machine involved and materials used. Which data problem type does this scenario describe?

Identifying themes

A restaurant group is choosing the locations of new restaurant openings. They use an algorithm to monitor current trends and develop business intelligence about where people most frequently dine out. Which data problem type does this scenario describe?

Making predictions

A data professional uses a spreadsheet tool to create a visualization that totals productivity data by organization, department, and employee. What tool are they using?

Pivot table

A junior data analyst encounters a spreadsheet error. They realize that their formula is referencing a row that has been deleted, so they correct the formula. What type of error did they resolve?

REF

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

Vice president of logistics

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

Wait a few minutes to think it over, then request a meeting to discuss the new project and your general workload.

Fill in the blank: The question, "Which processes can we streamline by using technology more effectively?" is _____ because it encourages change.

action-oriented

Fill in the blank: When solving the _____ problem type, a data professional team at a bank analyzes financial market data from the past six months. They then use this information to understand what led to certain fluctuations and what is likely to cause them again.

finding patterns

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

invest time and resources

Fill in the blank: ROI is calculated by comparing the two metrics of _____, enabling a company to determine the success of the investment.

investment cost and profit

Fill in the blank: When solving the _____ problem type, a junior data analyst identifies a technological breakthrough that is likely to disrupt their industry.

making predictions

Fill in the blank: A _____ is a collection of two or more cells.

range

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

stakeholders