Google Data Analytics

Questions encourage change.

Action-oriented

Questions can be quantified and assessed.

Measurable

Based on what you have learned in this course, spreadsheets are digital worksheets that enable data analysts to do which of the following tasks? Select all that apply.

Sort and filter data Store data Organize data in columns and rows

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

True

Fill in the blank: A data visualization is the _____ representation of information.

graphical

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

process steps

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

Charts, Maps, Graphs

What is the term for the graphical representation of data?

Data visualization

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

Finding patterns

In the SMART methodology, questions that encourage change are described how?

Action-oriented

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

Making predictions

Recognizing broader concepts and trends from categorized data.

Identifying themes

Structured thinking involves which of the following processes:

Revealing gaps and opportunities Organizing available information Recognizing the current problem or situation

Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply.

- Increase the efficiency of a car manufacturer based on its current assembly process - Reduce a company's carbon footprint based on its current emissions - Improve accessibility for an educational app based on its current functionality

Imagine you are sharing your data with a company stakeholder. Why might you display data with a data visualization instead of a table? Select all that apply.

- It helps them identify trends more quickly

A clothing retailer collects and stores data about its sale revenue. Which of the following would be part of its data ecosystem?

- The cloud that store its database - The database of sales revenue

In data analytics, what term describes a collection of elements that interact with one another?

A data ecosystem

What is the main difference between a formula and a function?

A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process.

An advertising firm has used insights from its analytics team to create a strategy for improving sales. Now, they implement a plan to increase annual revenue. The firm is at which step of the data analysis process?

Act

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

Analytical thinking

After opening the ice cream shop on her farm, the same dairy farmer then surveys the local community about people's favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?

Analyze

Having a technical mindset is an analytical skill involving what?

Breaking things down into smaller steps or pieces

In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?

Capture

Grouping data based on common features.

Categorizing things

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

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

Categorizing things is one of the six problem types data analysts solve. This type of problem might involve which of the following actions?

Classifying or grouping items

The owner of a skate shop notices that every time a certain employee has a shift, there are higher sales numbers at the end of the day. After some investigation, the owner realizes that since the employee was hired, the store earns 15% more each month. In this scenario, the manager used which quality of analytical thinking?

Correlation

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

Correlation

In data analytics, how are dashboards different from reports?

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

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

Data analysis

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

Data strategy

A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe?

Data-driven decision-making

A data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst then shares their analysis with subject-matter experts from the manufacturing team, who validate the findings. Finally, a plan is put into action. This scenario describes what process?

Data-driven decision-making

What is the process of guiding business strategy using facts?

Data-driven decision-making

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

Discovering connections

A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving.

False

Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan.

False

In the function =SUM(G1:G35), identify the range.

G1:G35

A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people's favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?

Manage

A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst's toolkit.

Query

Questions matter, are important, and have significance to the problem you're trying to solve.

Relevant

Identifying data that is different from the norm.

Spotting something unusual

To get the most out of data-driven decision-making, it's important to include insights from people very familiar with the business problem. Identify what these people are called.

Subject-matter experts

Which of the following options describes data analysis?

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

What method involves asking numerous questions in order to get to the root cause of a problem?

The five whys

Questions specify the time to be studied.

Time-bound

In a spreadsheet, what is text wrapping used for?

To allow all of the text to fit inside a cell

Data design is how you organize information; data strategy is the management of the people, processes, and tools used in data analysis.

True

Data-driven decision-making involves the five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. Each plays a role in data-driven decision-making.

True

What tactics can a data analyst use to effectively blend gut instinct with facts? Select all that apply.

Use their knowledge of how their company works to better understand a business need. Apply their unique past experiences to their current work, while keeping in mind the story the data is telling.

The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.

Using data-erasure software Shredding paper files

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

a formula

Fill in the blank: Curiosity, understanding context, having a technical mindset, data design, and data strategy are _____. They enable data analysts to solve problems using facts.

analytical skills

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.

attributes

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.

filter

Fill in the blank: The primary goal of a data _____ is to create new questions using data.

scientist

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

structured

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.

-Help team members make informed, data-driven decisions -Consider the best ways to share data with others -Use data to get to a solid conclusion

Small data differs from big data in what ways? Select all that apply.

-Small data is effective for analyzing day-to-day decisions. Big data is effective for analyzing more substantial decisions. -Small data involves datasets concerned with a small number of specific metrics. Big data involves datasets that are larger and less specific. -Small data focuses on short, well-defined time periods. Big data focuses on change over a long period of time.

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.

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.

True

A recycling center that sponsors a podcast about saving the environment is an example of what strategy?

Trying to reach a target audience

Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill?

Understanding context

In the analyze stage of the data life cycle, what might a data analyst do? Select all that apply.

Use spreadsheets to aggregate data Use a formula to perform calculations Create a report from the data

Fill in the blank: In data analytics, qualitative data _____. Select all that apply.

measures qualities and characteristics is subjective

Fill in the blank: Some of the most common symbols used in formulas include + (addition), - (subtraction), * (multiplication), and / (division). These are called _____.

operators

Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle.

plan

Fill in the blank: During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.

planning

Finding patterns is one of the six problem types data analysts aim to solve. This type of problem might involve which of the following?

Identifying trends from historical data

A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet?

It adds context

What are the key benefits of data visualizations? Select all that apply.

They can illustrate relationships between data points They can help stakeholders understand complex data more quickly They can clearly demonstrate patterns and trends

What are some reasons why a data analyst might use data visualizations?

To create interesting graphs To explain complex data quickly To reinforce data analysis

The share phase of the data analysis process typically involves which of the following activities:

Creating a slideshow to present to stakeholders Communicating findings Summarizing results using data visualizations

Seeking out new challenges and experiences in order to learn is an example of which analytical skill?

Curiosity

A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings and recommendations to the client. What should they have done before that presentation?

Shared the results with subject-matter experts from the marketing team for their input

Questions are simple, significant, and focused on a single topic or a few closely related ideas.

Specific