Google Data Analytics

Context

The condition in which something exists or happens

Data visualization

The graphical representation of data

Syntax

the predetermined structure of a language that includes all required words, symbols, and punctuation, as well as their proper placement.

true

Data analysts use queries to request, retrieve, and update information within a database. True False

SELECT * FROM album WHERE album_id AND album_id>=277

How would you format this SQL? You are working with a database table that contains data about music albums. You are only interested in data related to the album with ID number 277. The album IDs are listed in the album_id column from the album table. You write the SQL query below. Add a WHERE clause that will return only data about the album with ID number 277.

Nighttime riders

On a railway line, peak ridership occurs between 7:00 AM and 5:00 PM. The fairness of a passenger survey could be improved by over-sampling data from which group? Daytime riders Female passengers Male passengers Nighttime riders

Analytical skills

Qualities and characteristics associated with using facts to solve problems

Semicolon

The ______________ is a statement terminator

observation

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

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? Clean the data Create data visualizations Define the problem to be solved Collect and store data

Data-driven decision-making

Using facts to guide business strategy

When showing a class broken down by age

When would a pie chart be an effective visualization? When showing a change in someone's age over time When showing a class broken down by age When showing the ages of males versus females When showing the relationship between age and income

Charts Graphs Maps

Which of the following are examples of data visualizations? Select all that apply. Charts Graphs Maps Reports

Data design

How information is organized

stakeholder

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

Ask Prepare Explore Model Implement Act Evaluate

What are the 7 steps of the SAS data life cycle?

Correlation

Which aspect of analytical thinking involves being able to identify a relationship between two or more pieces of data? Visualization Context Data design Correlation

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? Process Act Share Analyze

Data science

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

False

A furniture manufacturer wants to find a more environmentally friendly way to make its products. A data analyst helps solve this problem by gathering relevant data, analyzing it, and using 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 data science. True False

Gap analysis

A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future

query

A request for data or information from a database

Fairness helps them avoid biased conclusions.

Data analysts ensure their analysis is fair for what reason? Fairness helps them communicate with stakeholders. Fairness helps them avoid biased conclusions. Fairness helps them stay organized. Fairness helps them pick and choose which data to include from a dataset.

True

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

facts

Data is a collection of _____ that can be used to draw conclusions, make predictions, and assist in decision-making.

<>

means "does not equal"

Formula

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

Place a comma after each data field (column) and enter

How do you request multiple data fields (columns) from a table

destroy

A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? Manage Archive Destroy Plan

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. True False

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? Process Prepare Act Ask

query

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

Curiosity

A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using? Data strategy Curiosity Understanding context Having a technical mindset

Function

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

Fairness

A quality of data analysis that does not create or reinforce bias

False

A real estate company needs to hire a human resources assistant. The owner asks a data analyst to help them decide where to advertise the job opening. The analyst learns that the majority of human resources professionals are women, validates this finding with research, and targets ads to a women's community college. This is fair because the analyst conducted research to make sure the information about gender breakdown of human resources professionals was accurate. True False

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? Analytical thinking Performance measurement Data-driven decision-making Collaboration with stakeholders

Gap analysis

An airport wants to make its luggage-handling process faster and simpler for travelers. A data analyst examines and evaluates how the process works currently in order to achieve the goal of a more efficient process. What methodology do they use? Strategy Data visualization The five whys Gap analysis

Adding descriptive headers to columns of data in a spreadsheet Gathering additional information about data to understand the broader picture Identifying the motivation behind the collection of a dataset

Understanding context is an analytical skill best described by which of the following? Select all that apply. Adding descriptive headers to columns of data in a spreadsheet Gathering additional information about data to understand the broader picture Identifying the motivation behind the collection of a dataset Working with facts in an orderly manner

Visualization Strategy Problem-orientation Correlation Big-picture and detail-oriented thinking

What are the 5 aspects of analytical thinking?

1. Ask: Business Challenge/Objective/Question 2. Prepare: Data generation, collection, storage, and data management 3. Process: Data cleaning/data integrity 4. Analyze: Data exploration, visualization, and analysis 5. Share: Communicating and interpreting results 6. Act: Putting your insights to work to solve the problem (And there are variations i.e. EMC, SAS

What are the 6 steps of data analytics?

Discovery Pre-processing data Model planning Model building Communicate results Operationalize

What are the 6 steps of the EMC data life cycle?

Scheduling a certain number of restaurant employees to work based on the average number of lunch-goers per day Choosing e-commerce solutions based on customer shopping preferences Suggesting new music to a customer based on their listening history

Identify the real-world examples of how a company might make data-driven decisions. Select all that apply. Scheduling a certain number of restaurant employees to work based on the average number of lunch-goers per day Choosing e-commerce solutions based on customer shopping preferences Suggesting new music to a customer based on their listening history Making spending decisions based on the gut instinct of the company accountant

Condition 1 AND Condition 2 AND Condition 3

If you have multiple conditions in your SQL query WHERE clause, how may this be formatted?

* (SELECT*)

If you replace SELECT field1 with SELECT _____ , you would be selecting all of the columns in the table instead of the field1 column only

to look for a certain pattern

In SQL, % tells the database to look for what?

dot

In a SQL query, the dataset name is always followed by a ________, and then the table name

To label a column

In a table, an attribute is a characteristic or quality of data used for what purpose? To reference a cell To label a column To gather related data To perform a calculation

Data strategy

In data analysis, which analytical skill involves the management of people, processes, and tools? Data analytics Data strategy Data control Data design

false

In data analytics, a model is a group of elements that interact with one another. True False

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?

capture

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

Analyze

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

Share

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

To allow all of the text to fit inside a cell

Question 1 In a spreadsheet, what is text wrapping used for? To allow text to overflow into an adjacent cell To allow all of the text to fit inside a cell To clip text within a cell so it doesn't overflow into an adjacent cell To remove text that is too long to fit in a cell

An intuitive understanding of something with little or no explanation

Question 4 Select the best description of gut instinct. An intuitive understanding of something with little or no explanation Using your innate ability to analyze results Choosing facts that complement your personal experiences Manipulating data to match your intuition

SELECT * FROM invoice WHERE customer_id = 35

Question 6 You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 35. You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 35.

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. locate organize ingest merge

process steps

Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. data analytics tools process steps key questions data types

analyst

Fill in the blank: The primary goal of a data _____ is to find answers to existing questions by creating insights from data sources. engineer scientist analyst designer

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. True False

Breaking things down into smaller steps or pieces

Having a technical mindset is an analytical skill involving what? Breaking things down into smaller steps or pieces Understanding the condition in which something exists or happens Managing people, processes, and tools Balancing roles and responsibilities

Ask "why" 5 times

How can the root cause be strategically identified and tackled

Identify the root cause of a problem

The five whys is a technique that involves asking, "Why?" five times in order to achieve what goal? Use facts to guide business strategy Visualize how a process should look in the future Put a plan into action Identify the root cause of a problem

Plan: What plans and decisions do you need to make? What data do you need to answer your question? Capture: Where does your data come from? How will you get it? Manage: How will you store your data? What should it be used for? How do you keep this data secure and protected? Analyze: How will the company analyze the data? What tools should they use? Archive: What should they do with their data when it gets old? How do they know when it's time? Destroy: Should they ever dispose of any data? If so, when and how? What kind of data should they gather? How should they gather this data? Where will the data live? How will they store the data? Once they have the data, how will they use it? How do they keep their data secure and protected? What should they do with old data? What are their options? First, the ice cream company should plan exactly what they are looking for. In this case, they want to know their customers' ice cream flavor preferences. This qualitative data can be gathered from a simple survey from the customers that visit the shop. The data will live in a data base, and it will be stored securely here. Once they have the data, they can use it to determine how much of each flavor they should purchase going forward. They can keep their data secure and protected by archiving it. With the old data, they can either keep it in a secure archive or destroy it.

The hiring manager explains that they do not collect any customer data, and they don't know where to begin. The hiring manager asks you: Can you please explain how you would approach this task?

Data analytics

The science of data

Data ecosystem

The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data

Data Design

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

The specifics

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

Data analysis

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

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

Attribute

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

analyze

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 Plan Archive Capture

Make sure their recommendation doesn't create or reinforce bias

Avens Engineering needs more engineers, so they purchase ads on a job search website. The website's data reveals that 86% of engineers are men. Based on that number, an analyst decides that men are more likely to be successful applicants, so they target the ads to male job seekers. What should the analyst have done instead? Decline to accept ads from Avens Engineering because of fairness concerns. Make sure their recommendation doesn't create or reinforce bias Let Avens Engineering decide which type of applicants to target ads to. Only show ads for the engineering jobs to women.

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

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. Choose a topic for data analysis Store data Sort and filter data Organize data in columns and rows

True

Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data. True False

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. A question can have many answers, whereas a problem only has one solution. A question is uncertain, whereas a problem is clearly specified. A question is a topic to investigate, whereas a problem is a subject to investigate. A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.

false

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

True

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

Analyze

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

plan

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. capture manage plan analyze

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. filter sort categorize copy

graphical

Fill in the blank: A data visualization is the _____ representation of information. graphical tabulated contextual attributed

database

Fill in the blank: A query language is a computer programming language that enables data analysts to retrieve and manipulate data from a _____. database drive spreadsheet folder

a formula

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

WHERE field1 = 'Chavez'

If you are looking for a specific customer with the last name Chavez, the WHERE clause would be

WHERE field1 LIKE 'Ch%' (Sometimes an * is used instead of %)

If you are looking for all customers with a last name that begins with the letters "Ch," the WHERE clause would be:

Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Analyze the average length of an appointment this year compared to past years. Analyze the number of patients seen per day compared to past years.

Question 2 A doctor's office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ways could a data analyst help solve this problem? Select all that apply. Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Analyze the average length of an appointment this year compared to past years. Analyze the number of patients seen per day compared to past years. Analyze a recent change in the average rating for the doctor's office on social media.

True

Question 2 The columns in a spreadsheet are ordered by letter, and the rows are ordered by number. True False

False

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

True

Question 3 A database is a collection of data stored in a computer system. True False

structured

Question 4 In data analytics, SQL is an acronym meaning _____ query language. statistical structured syntax software

Data strategy

The management of the people, processes, and tools used in data analysis

Correlation

The manager at a music shop notices that more trombones are repaired on the days when Alex and Jasmine work the same shift. After some investigation, the manager discovers that Alex is excellent at fixing slides, and Jasmine is great at shaping mouthpieces. Working together, Alex and Jasmine repair trombones faster. The manager is happy to have discovered this relationship and decides to always schedule Alex and Jasmine for the same shifts. In this scenario, the manager used which quality of analytical thinking? Problem-orientation Correlation Big-picture thinking Visualization

Analytical thinking

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

Business task

The question or problem data analysis resolves for a business

Root cause

The reason why a problem occurs

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

Which of the following options describes data analysis? Creating new ways of modeling and understanding the unknown by using raw data The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making Using facts to guide business strategy

Data is a collection of facts.

Which of the following statements best defines data? Data is a business process. Data is an assortment of questions. Data is a collection of facts. Data is the use of calculations and statistics.

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 elements Data life cycle Data insight Data analysis

Having a technical mindset

You are planning a road trip. Your first step is to break down the planning into smaller pieces. You begin by calculating your budget. Then, you choose a destination and departure date. Next, you plan where to stay, what vehicle to take, and how long you want to be on the road. Which analytical skill does this scenario describe? Having a technical mindset Understanding context Curiosity Data design

AS

You can make it easier on yourself by assigning a new name or alias to the column or table names to make them easier to work with (and avoid the need for comments). This is done with a SQL ______ clause.

False

You read an interesting article about data analytics in a magazine and want to share some ideas from the article in the discussion forum. In your post, you include the author and a link to the original article. This would be an inappropriate use of the forum. True False

Query language

A computer programming language used to communicate with a database

query language

A computer programming language used to communicate with a database

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

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? Archived the datasets in order to keep them secure Shared the results with subject-matter experts from the marketing team for their input Created a model based on the results of the analysis Surveyed customers about results, conclusions, and recommendations

Analyzing 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? Analyzing the number of customers by calculating daily foot traffic Analyzing social media engagement Analyzing consumer preferences using artificial intelligence Analyzing customer buying behaviors

True

Data analysts answer questions and solve problems. These are called business tasks. True False

analytical skills

Fill in the blank: Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making. analytical skills thought processes data models business strategies

data-driven

Fill in the blank: Data analysts use the five analytical skills of curiosity, understanding context, having a technical mindset, data design, and data strategy to make _____ decisions. intuitive forward-looking more efficient data-driven

maps charts graphs

Fill in the blank: Data visualization involves using _____ to represent and present data. Select all that apply. maps charts graphs reports

facts

Fill in the blank: Data-driven decision-making is described as using _____ to guide business strategy. intuition facts gut instinct visualizations

planning

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. manage planning archive capture

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. attributes names diagnostics commonalities

inclusive

Fill in the blank: In data analytics, fairness means ensuring that your analysis does not create or reinforce bias. This requires using processes and systems that are fair and _____. inclusive restrictive partial favorable

Data analyst

Someone who collects, transforms, and organizes data in order to drive informed decision-making

true

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

Technical mindset

The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way

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

What are the key benefits of data visualizations? Select all that apply. They can help stakeholders understand complex data more quickly They can ensure that you get fewer questions about your analysis They can illustrate relationships between data points They can clearly demonstrate patterns and trends

Plan: Decide what kind of data is needed, how it will be managed, and who will be responsible for it. Capture: Collect or bring in data from a variety of different sources. Manage: Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so. Analyze: Use the data to solve problems, make decisions, and support business goals. Archive: Keep relevant data stored for long-term and future reference. Destroy: Remove data from storage and delete any shared copies of the data.

What are the phases of data (data life cycle)

Identifying the problem Designing data requirements Pre-processing data Performing data analysis Visualizing data

What are the steps in the project-based data analytics life cycle?

Validate the choices made as a result of the data insights Review the results of data analysis and identify any inconsistencies

What do subject-matter experts do to support data-driven decision-making? Select all that apply. Validate the choices made as a result of the data insights Collect, transform, and organize data Review the results of data analysis and identify any inconsistencies Offer insights into the business problem

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.

What is the main difference between a formula and a function? A formula begins with an equal sign (=); a function begins with an asterisk (*). 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. A formula is used to add or subtract; a function is used to multiply or divide. A formula can be used multiple times in a spreadsheet; a function can only be used once.

Use SELECT to choose the columns you want to return. Use FROM to choose the tables where the columns you want are located. Use WHERE to filter for certain information.

What is the syntax of every SQL query?

Data visualization

What is the term for the graphical representation of data? 1 point Data visualization Data language Data collection Data summary

Next, enter the table name after the FROM; the table columns you want after the SELECT; and, finally, the conditions you want to place on your query after the WHERE. Make sure to add a new line and indent when adding these

What order should you type a SQL Query in?

Analytical thinking

What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner? Visualization Analytical thinking Context Data design

Understand the social context Include data self-reported by individuals Use an inclusive sample population

What steps do data analysts take to ensure fairness when collecting data? Select all that apply. Clean the data provided Understand the social context Include data self-reported by individuals Use an inclusive sample population

Comments

_________________ are text placed between certain characters, /* and */, or after two dashes (--) as shown below.