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