Google Data Analytics: Course 1 - Foundations

01-037 - You are writing a SQL query to analyze data about recent trampoline sales. The store_sales table describes the number of trampolines sold at several sporting goods stores. What is the correct clause to retrieve data from this table? a. WHERE store_sales b. WHERE_store_sales c. FROM store_sales d. FROM = store_sales

FROM store_sales

04-016 - Definition of IDE

Integrated Developer Environment

01-029 - A clothing retailer collects and stores data about its sales revenue. Which of the following would be part of its data ecosystem? Select all that apply. a. Inventory records b. Sales database c. Database of competing retailers d. The cloud that stores its database

Inventory records, Sales database, the cloud that stores its database

04-002 - What are column labels called?

attributes, fields

05-002 - A question is designed to ____ information

discover

04-012 - Which chart type would be good to track sales over time? a. Line b. Map c. Donut d. Bar

line

01-015 - What are the 3 disciplines of Data Science?

machine learning/AI, statistics, analytics

02-012 - What is the data strategy for analysis tools?

making sure the right technology is being used for the job

04-003 - What are rows called?

observations or records

01-026 - Definition Data-Driven Decision-Making

using facts to guide business strategy

02-003 - What are the 5 aspects to analytical thinking? (VSPO, CBPDO)

visualization, strategy, problem-orientation, correlation, big-picture and detail-oriented thinking

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

Offer insights into the business problem, Review the results of data analysis and identify any inconsistencies, Validate the choices made as a result of the data insights

04-017 - Which program is a popular IDE?

RStudio

01-024 - Definition of a Data Set

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

01-030 - In data analytics, how is data described? a. An aggregate of intelligence b. A series of calculations and statistics c. A technical business process d. A collection of facts

a collection of facts

03-003 - Definition of a database

a collection of structured data

01-025 - Definition of a Data Ecosystem

a group of elements that interact to create an environment in which to produce, store, manage, organize, analyze, and share information

02-021 - Definition of Gap Analysis

a method of comparing a current state to a desired state

04-005 - Definition of a function

a preset command that automatically performs a process or task

02-019 - What is the 5 Whys technique?

a process to determine the root cause

05-004 - Definition of Business Task

a question or problem that data analysis answers for a business

04-004 - Definition of a formula

a set of instructions to perform a specific calculation

01-013 - Definition of Regression Analysis

a statistical method used to examine relationships between variables

05-001 - Definition of issue

a topic or subject to investigate

01-035 - A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet? a. Adds context b. Improves the aesthetic appeal c. Clarifies the business strategy d. Eliminates unnecessary details

add context

01-039 - Definition of gut instinct

an intuitive understanding of something with little or no evidence

05-003 - Definition of problem

an obstacle or complication that needs to be worked out

02-013 - What do you call identifying and defining a problem and then solving it by using data in an organized, step-by-step manner?

analytical thinking

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

analytical thinking

02-017 - What are 3 types of thinking?

analytical, creative, critical

01-004 - Steps in Data Analysis Process

ask, prepare, process, analyze, share, act

02-014 - What is this group of aspects called? Visualization, strategy, problem-orientation, correlation, big-picture and detail-oriented thinking

aspects of analytical thinking

04-015 - Which chart type would be good to compare total visitors to visitors who make purchases? a. Line b. Map c. Donut d. Bar

bar

02-007 - Definition of a technical mindset

breaking things into smaller steps

01-003 - Definition of Analysis

collection, transformation, organization, conclusions, predictions, decision-making

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

correlation

01-021 - What does a Data Scientist do? (NWMUURD)

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

02-002 - What are the 5 data analysis skills? (CCTM,DDDS)

curiosity, context, technical mindset, data design, data strategy

02-008 - What are these called: curiosity, context, technical mindset, data design, data strategy?

data analysis skills

01-043 - 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. Does this scenario describe data science or data-driven decision-making?

data-driven decision-making

01-027 - What are the 2 steps in Data-Driven Decision-Making?

define a problem and analyze it

01-009 - Which type of business analytics interprets historical data to identify trends and patterns?

descriptive

01-008 - What are the 3 types of business analytics?

descriptive, predictive, prescriptive

01-014 - Definition of Root-Mean-Square Error

difference between predicted and observed values

04-014 - Which chart type would be good to show customer segments? a. Line b. Map c. Donut d. Bar

donut

05-004 - Definition of data analysis fairness

ensuring your analysis doesn't create or reinforce bias and is inclusive

01-020 - Analysts enjoy the fun and thrill of ____.

exploration

01-001 - Definition of Data

facts, observations, numbers, measurements, videos, pics

01-022 - What are 3 reasons you analyze data? (PRT)

find patterns, relationships, trends

02-011 - What is the cornerstone of the data analysis skill of context?

how information fits into the big picture

02-006 - Definition of data design

how you organize information

01-006 - List 5 ways to use data (IP, IOT, LNP, SC, MD)

improve processes, identify opportunities and trends, launch new products, serve customers, make decisions

01-012 - Definition of People Analytics

improve workplace and business processes

01-005 - One way to think of analysis is that it turns data into _____.

insights

02-005 - Definition of data strategy

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

04-013 - Which chart type would be good to connect sales to regions? a. Line b. Map c. Donut d. Bar

map

01-019 - Analysts thrive on creative and ___-____ projects.

open-ended

02-018 - The more ways you can think, the easier it is to think ___ the ___, and come up with fresh ideas.

outside-the-box

01-023 - A critical question to ask up-front is, "How do I define ____ for this project?

success

02-009 - Definition of context

the condition in which something exists or happens

02-015 - Definition of visualization

the graphical representation of information

01-028 - What does the phrase, Data Analysis Life Cycle describe?

the process of going from data to decision

02-004 - Definition of analytical thinking

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

02-016 - Definition of correlation

the tendency to vary together

04-007 - SQL. List 2 wildcard symbols?

* %

04-010 - SQL. What are two ways to insert a comment in a SQL statement?

-- or /asterisk asterisk/

04-008 - SQL. Which is the statement terminator symbol?

;

04-009 - List 3 logical condition symbols

<=, <>, >

01-038 - The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making describes what? a. Data life cycle b. Data analytics c. Data science d. Data analysis

Data analysis

01-031 - What is the process of guiding business strategy using facts? a. Strategic improvement b. Identification of data and decisions c. Analytical strategy d. Data-driven decision-making

Data-driven decision-making

01-040 - 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? a. Data science b. Identification of trends c. Customer service d. Data-driven decision-making

Data-driven decision-making

01-042 - You have just finished analyzing data for a marketing project. Before moving forward, you share your results with members of the marketing team to see if they might have additional insights into the business problem. What practice does this support? a. Data management b. Data science c. Data-driven decision-making d. Data analytics

Data-driven decision-making

01-032 - Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply. a. Increase the efficiency of a mfg based on current assembly process b. Improve accessibility for an education app based on its current functionality c. Reduce a company's carbon footprint based on its current emissions d. Spread awareness about income inequality based on local salaries

Increase the efficiency of a mfg based on current assembly process, and Improve accessibility for an education app based on its current functionality

04-011 - SQL. When listing multiple elements, which requires a comma, SELECT or WHERE?

SELECT

04-018 - SQL. What does the * mean?

Select all data that meets the criteria as state in the query

01-036 - You are querying a database of manufacturing company suppliers. The column name for supplier identification numbers is supplier_id. What is the correct clause to retrieve only data about the supplier with identification number 85317? a. WHERE = supplier_id 85317 b. FROM = supplier_id 85317 c. FROM supplier_id = 85317 d. WHERE supplier_id = 85317

WHERE supplier_id = 85317

01-016 - What is the excellence of a machine learning/AI engineer?

performance

03-001 - What are the 6 phases of the data life cycle?

plan, capture, manage, analyze, archive, destroy

01-010 - Which type of business analytics centers on taking information on trends and patterns to forecast future outcomes?

predictive

01-011 - Which type of business analytics uses testing and other techniques to determine which outcome will yield the best result for a given scenario?

prescriptive

02-001 - Definition of analytical skills

qualities and characteristics associated with using facts to solve problems

01-034 - The analyze phase of the data life cycle includes which of the following steps? Select all that apply. a. Creating a report from data b. Choosing the format of spreadsheet headings c. Using a formula to perform calcs d. Using a spreadsheet to aggregate data

report, formula, spreadsheet

04-006 - SQL. Data returned from a SQL query is stored in a ____ table, called the ____

result table, called the result set

04-001 - What does a query language allow you to do?

retrieve and manipulate data

01-017 - What is the excellence of a statistician?

rigor

01-002 - Definition of Analytics

science of logical analysis, science of data

01-018 - What is the excellence of an analyst?

speed in discovering gems of insight

03-002 - What are the 3 functions of the manage phase of the data life cycle?

storage, security, maintenance

01-033 - An analysis firm is conducting a data analysis of rainwater trends to give recommendations to agricultural companies. When they reach the manage stage of the data life cycle, which of the following might they do? Select all that apply. a. Place their data in a location it can be accessed, even if it may not be used b. Store and clean the data they have collected c. Decide which security tools they will use to protect it d. Collect and organize data relevant to rainwater

store and clean, security tools

05-010 - What are doughnut charts good for?

to depict the relationship between two things

02-020 - What are 3 reasons to use a problem-oriented approach?

to identity, define, and/or solve a problem

01-007 - Definition of Business Analytics (UMS,DMFD,MD)

use of math and statistics to derive meaning from data to make better decisions

02-010 - Definition of problem-orientation

using an issue-oriented approach to identify, describe, and solve challenges