Google Data Analytics Professional

Data-driven decision making

A company is receiving negative comments on social media about their products. To solve this problem, a data analyst uses each of their five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. This makes it possible for the analyst to use facts to guide business strategy and figure out how to improve customer satisfaction. What is this an example of?

Act

A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process

A project manager needs to monitor data as it becomes available

A dashboard would be most beneficial for which of the following scenarios?

False

A data analyst at a social media company is creating questions for a focus group. They use common abbreviations such as PLS for "please" and LMK for "let me know." This is fair because the participants use social media a lot and are likely to be technically savvy.

Share

A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe?

What story is the data telling me? How will my data help me solve the problem?

A data analyst has entered the analyze step of the data analysis process. Identify the questions they might ask during this phase. Select all that apply.

True

A data analyst is analyzing fruit and vegetable sales at a grocery store. They're able to find data on everything except red onions. If they exclude red onions from the analysis, this would be an example of creating or reinforcing bias.

Making predictions

A data analyst is working for a local power company. Recently, many new apartments have been built in the community, so the company wants to determine how much electricity it needs to produce for the new residents in the future. A data analyst uses data to help the company make a more informed forecast. This is an example of which problem type?

Act

A data analyst shares insights from their analysis during a formal presentation to stakeholders. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What phase of the data analysis process would come next?

Action-oriented

A data analyst uses the SMART methodology to create a question that encourages change. This type of question can be described how?

The first question is vague, whereas the second question includes important context.

A data analyst working for a mid-sized retailer is writing questions for a customer experience survey. One of the questions is: "Do you prefer online or in-store?" Then, they rewrite it to say: "Do you prefer shopping at our online marketplace or shopping at your local store?" Describe why this is a more effective question.

A technical mindset

A data analyst works for an appliance manufacturer. Last year, the company's profits were down. Lower profits can be a result of fewer people buying appliances, higher costs to make appliances, or a combination of both. The analyst recognizes that those are big issues to solve, so they break down the problems into smaller pieces to analyze them in an orderly way. Which analytical skill are they using?

Structured thinking

A data analytics team works to recognize the current problem. Then, they organize available information to reveal gaps and opportunities. Finally, they identify the available options. These steps are part of what process?

True

A database is a collection of data stored in a computer system.

True

A doctor's office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. A data analyst could help solve this problem by analyzing how many doctors and nurses are on staff at a given time compared to the number of patients with appointments.

The era, phase, or period of analysis

A time-bound SMART question specifies which of the following parameters?

Data driven decision-making

An airline collects, observes, and analyzes its customers' online behaviors. Then, it uses the insights gained to choose what new products and services to offer. What business process does this describe?

Discrete Ordinal

An entertainment website displays a star rating for a movie based on user reviews. Users can select from one to five whole stars to rate the movie. The star rating is an example of what type of data? Select all that apply.

Analyze customer buying behaviors

An online gardening magazine wants to understand why its subscriber numbers have been increasing. A data analyst discovers that significantly more people subscribe when the magazine has its annual 50%-off sale. This is an example of what?

Stakeholders

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?

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making

Data analysis

True

Data analysts ask, "Why?" five times in order to get to the root cause of a problem.

The science of data

Data analytics

creating new ways of modeling and understanding the unknown by using raw data

Data science

A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.

Describe the difference between a question and a problem in data analytics.

Data is a collection of facts. Metrics are quantifiable data types used for measurement.

Describe the difference between data and metrics.

Categorizing things involves assigning items to categories. Identifying themes takes those categories a step further, grouping them into broader themes.

Describe the key difference between the problem types of categorizing things and identifying themes.

False

During the capture stage of the data life cycle, a data analyst may use spreadsheets to aggregate data.

True

During the process phase of data analysis, a data analyst cleans data to ensure it's complete and correct.

Analyze

During which phase of data analysis would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

question

Fill in the blank: A business task is described as the problem or _____ a data analyst answers for a business.

filter

Fill in the blank: A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions.

a predefined operation

Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.

measurable

Fill in the blank: A metric goal is a _____ goal set by a company that is evaluated using metrics.

Formula

Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.

Analytical skills

Fill in the blank: Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.

Manages

Fill in the blank: Data strategy involves _____ the people, processes, and tools used in data analysis.

what the data has in common

Fill in the blank: Data-inspired decision-making can discover _____ when exploring different data sources.

attributes

Fill in the blank: In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row.

population

Fill in the blank: In data analytics, a _____ refers to all possible data values in a certain dataset.

Organize

Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.

summarize

Fill in the blank: Pivot tables in data processing tools are used to _____ data.

net profit

Fill in the blank: Return on investment compares the cost of an investment to the _____ of that investment.

process steps

Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.

True

Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future?

True

Gap analysis is used to examine and evaluate how a process currently works with the goal of getting to where you want to be in the future.

Categorizing things

Grouping data based on common features.

Spotting something unusual

Identifying data that is different from the norm

Discovering connections

Identifying similar challenges across different entities—and using data and insights to find common solutions.

True

If someone is subjectively describing their feelings or emotions, it is qualitative data.

True

In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.

equal sign (=)

In a spreadsheet, a formula should always start with which of the following operators?

To allow all of the text to fit inside a cell

In a spreadsheet, what is text wrapping used for?

Data strategy

In data analysis, which analytical skill involves the management of people, processes, and tools?

structured

In data analytics, SQL is an acronym meaning _____ query language.

Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data.

In data analytics, how are dashboards different from reports?

Static

In data analytics, reports use data that doesn't change once it's been recorded. Which of the following terms describes this type of data?

Data ecosystem

In data analytics, what is the term for elements that interact with one another in order to produce, manage, store, organize, analyze, and share data?

the range

In the function =MAX(G3:G13), what does G3:G13 represent?

Share

In which data analysis phase would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

Process

In which step of the data analysis process would an analyst ask questions such as, "What data errors might get in the way of my analysis?" or "How can I clean my data so the information I have is consistent?"

True

It's possible for conclusions drawn from data analysis to be both true and unfair.

It's close-ended

On a customer service questionnaire, a data analyst asks, "If you could contact our customer service department via chat, how much valuable time would that save you?" Why is this question unfair?

second-party data

Organizations such as the U.S. Centers for Disease Control (CDC) often use data collected from hospitals. What kind of data is the CDC using if it is collected by hospitals, then sold to the CDC for its own analysis?

Identifying themes

Recognizing broader concepts and trends from categorized data.

Profit and investment

Return on Investment (ROI) uses which of the following metrics in its definition?

True

Structured query language (SQL) enables analysts to communicate with a database?

True

Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making.

True

The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.

Share customer feedback Compile information about customer expectations

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

Define the problem to be solved

The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?

Respectfully explain their viewpoints and offer the director some additional information to help improve the project.

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.

when analysis depends on as many data sources as possible

The use of external data is particularly valuable in which circumstances?

Context

To avoid bias when collecting data, a data analyst should keep what in mind?

=Average(C2:C11)

To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax?

Making predictions

Using data to make informed decisions about how things may be in the future.

Finding patterns

Using historical data about what happened in the past to understand how likely it is to happen again.

Think through the "who, what, where, when, how, and why" Make sure you start with an accurate representation of the population in the sample Collect the data in an objective way

What are some strategies to ensure your data is accurate and fair? Select all that apply.

attributes

What do data analysts use to label the type of data contained in each column in a spreadsheet?

=D5*D7

What is the correct spreadsheet formula for multiplying cell D5 times cell D7?

Qualitative data can be used to measure qualities and characteristics. Quantitative data can be used to measure numerical facts.

What is the difference between qualitative and quantitative data?

Data-driven decision making

What is the process of using facts to guide business strategy?

data range

What is the term for the set of cells that a data analyst selects to include in a formula?

Analytical thinking

What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?

Correlation

Which aspect of analytical thinking involves being able to identify a relationship between two or more pieces of data?

A pivot table

Which data-summarization tool do data analysts use to sort, reorganize, group, count, total, or average data?

Observations

Which method of data-collection is most commonly used by scientists?

Graphs Maps Charts

Which of the following are examples of data visualizations? Select all that apply.

Asterisk Forward Slash Hyphen

Which of the following are examples of operators used in formulas? Select all that apply.

Data is a collection of facts.

Which of the following statements best defines data?

a process or set of rules to be followed for a specific task

Which of the following statements describes an algorithm?

Data analysis

Which of the following terms refers to the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making?

Data visualization

what is the term for the graphical representation of data?