Google Data Analytics Foundation Module 1

Fill in the blank: Analytical thinking involves _____ a problem, then solving it by using data in an organized, step-by-step manner. identifying and defining evaluating and summarizing monitoring and assessing observing and inspecting

identifying and defining

Last is the act phase

in which you and others in the company put the data insights into action. This could mean implementing a new business strategy, making changes to a website, or any other action that solves the initial problem.

The analyze phase

is when you do the necessary data analysis to uncover answers and solutions. Depending on the situation and the data, this could involve tasks such as calculating averages or counting items in categories so you can examine trends and patterns.

SQL

(Structured Query Language)

Which of the following activities are elements of data-driven decision-making? Select all that apply. Ask subject-matter experts to review the results Find and analyze relevant data Remove data insights that stem from human intuition Figure out the business need or problem to be solved

1,2,4

Structured Query Language

A computer programming language used to communicate with a database

Self-reporting

A data collection technique where participants provide information about themselves

Attribute

A characteristic or quality of data used to label a column in a table

Database

A collection of data stored in a computer system

Dataset

A collection of data that can be manipulated or analyzed as one unit

Data

A collection of facts

Query language

A computer programming language used to communicate with a database

Spreadsheet

A digital worksheet

Data science

A field of study that uses raw data to create new ways of modeling and understanding the unknown

Data Analyst

A person who specializes in gathering and analyzing data to inform business decisions.

Function

A preset command that automatically performs a specified process or task using the data in a spreadsheet

Query

A request for data or information from a database

Formula

A set of instructions used to perform a calculation using the data in a spreadsheet

Data-driven decision making

An organizational process to gather and analyze relevant and verifiable data and then evaluate the results to guide business strategies.

In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals? Analyze Capture Manage Plan

Analyze

What type of data visualization might an analyst create in order to communicate data insights to others? Select all that apply. Map Chart Report Graph

Chart and Graph

An e-commerce website collects, observes, and analyzes its customers' online behaviors. Then, it uses the insights gained to choose when to put certain products on sale. What business practice does this describe? Data-driven decision-making Organizing data Performance measurement Analytical thinking

Data-driven decision-making

n your role as a data professional, you examine a dataset of taxi rides to determine which hour of the day typically has the highest demand. Under which discipline does this example best fall? Data analytics Data wrangling Data science Data analysis

Data analysis

Thinking about the way you organize your contacts in a new phone is an example of which analytical skill? Data strategy Understanding context Curiosity Data design

Data design

A data professional considers how they can best manage the key elements of an analysis project. They confirm that team members know how to use the right data, ensure there's a clear path to a solution, and check that the right technology is in place. Which analytical skill does this scenario describe? Data strategy Technical mindset Curiosity Understanding context

Data strategy

While planning a roadtrip, you figure out all of the specific stops you need to take along the way. You also consider how often you'll stop for gas, meals, and sleep. Having this information enables you to execute your plan. What does this scenario describe? Problem-orientation Finding a correlation Big-picture thinking Detail-oriented thinking

Detail-oriented thinking

What is a method for examining and evaluating how a process works currently in order to get to an improved future state? Gap analysis Five whys Data-driven decision-making Root cause analysis

Gap analysis

Stakeholders

People who invest time and resources into a project and are interested in its outcome

Analytical skills

Qualities and characteristics associated with using facts to solve problems

To execute a plan using detail-oriented thinking, what does a data analyst consider? The specifics The root cause The main idea The big picture

The specifics

A data professional working at a nonprofit prepares for a project about community forestry. They use their analytical thinking skills to determine what they want to achieve with the data. They also prioritize staying focused and on track. Which aspect of analytical thinking does this scenario describe? Detail-oriented thinking Strategic thinking Problem-orientation Visualization

Strategic thinking

Which analytical skill involves the ability to break things down into smaller steps and work with them in an orderly and logical way? Problem-solving Simplification Curiosity Technical mindset

Technical mindset

Data strategy

The analytical skill that involves managing the processes and tools used in data analysis

Observation

The attributes that describe a piece of data contained in a row of a table

Data analysis

The process of compiling, analyzing, and interpreting the results of primary and secondary data collection.

Analytical thinking

The process of identifying and defining a problem, then solving it by using data in an organized, step-by-step manner

Oversampling

The process of increasing the sample size of nondominant groups in a population. This can help you better represent them and address imbalanced datasets

An acquaintance tells you that they spend many hours each day "playing." To learn more, you ask them whether they play sports, a musical instrument, or something else. Their answer helps you clarify the meaning of their statement. What does this scenario describe? Making assumptions Analyzing data Understanding context Testing a hypothesis

Understanding context

Fill in the blank: The analytical skill _____ encompasses how someone organizes information. data strategy data mindset data design data analysis

data design

Fill in the blank: A _____ encompasses the various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data. data ecosystem business transformation cloud system data source

data ecosystem

Fill in the blank: Analytical skills are the qualities and characteristics associated with using _____ to solve problems. predictions gut instinct feedback facts

facts

The process phase

is when you will clean and organize your data. Tasks you perform here include removing any inconsistencies; filling in missing values; and, in many cases, changing the data to a format that's easier to work with. Essentially, you're ensuring the data is ready before you begin analysis

Fill in the blank: Data science is creating new ways of _____ and understanding the unknown by using raw data. identifying strategizing modeling arranging

modeling

Fill in the blank: Data analysts use a _____ approach in order to identify, describe, and work out challenges or issues. big-picture detail-oriented strategic problem-oriented

problem-oriented

analytical skills

the ability to collect and analyze information, problem-solve, and make decisions.

Data Analytics

the science of data

Next comes the share phase

when you present your findings to decision-makers through a report, presentation, or data visualizations. As part of the share phase, you decide which medium you want to use to share your findings and select the data to include. Tools for presenting data visually include charts made in Google Sheets, Tableau, and R.

Next, in the prepare phase

you'll find and collect the data you'll need to answer your questions. You'll identify data sources, gather data, and verify that it is accurate and useful for answering your questions.

In the ask phase,

you'll work to understand the challenge to be solved or the question to be answered. It will likely be assigned to you by stakeholders. As this is the ask phase, you'll ask many questions to help you along the way.

Which of the following statements correctly describe data and data analysis? Select all that apply. One goal of data analysis is to draw conclusions. Data is a collection of facts. Data analysis is creating new ways of understanding the unknown using raw data. Data analysis involves collecting, transforming, and organizing data.

1,2,4