Google Data Analytics: Course 1 – Foundations (Answered) 2023

Google Data Analytics: Course 1 – Foundations (Answered) 2023 01-001 - Definition of Data facts, observations, numbers, measurements, videos, pics 01-002 - Definition of Analytics science of logical analysis, science of data 01-003 - Definition of Analysis collection, transformation, organization, conclusions, predictions, decision-making 01-004 - Steps in Data Analysis Process ask, prepare, process, analyze, share, act 01-005 - One way to think of analysis is that it turns data into _____. insights 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-007 - Definition of Business Analytics (UMS,DMFD,MD) use of math and statistics to derive meaning from data to make better decisions 01-008 - What are the 3 types of business analytics? descriptive, predictive, prescriptive 01-009 - Which type of business analytics interprets historical data to identify trends and patterns? descriptive 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 01-012 - Definition of People Analytics improve workplace and business processes 01-013 - Definition of Regression Analysis a statistical method used to examine relationships between variables 01-014 - Definition of Root-Mean-Square Error difference between predicted and observed values 01-015 - What are the 3 disciplines of Data Science? machine learning/AI, statistics, analytics 01-016 - What is the excellence of a machine learning/AI engineer? performance 01-017 - What is the excellence of a statistician? rigor 01-018 - What is the excellence of an analyst? speed in discovering gems of insight 01-019 - Analysts thrive on creative and ___-____ projects. open-ended 01-020 - Analysts enjoy the fun and thrill of ____. exploration 01-021 - What does a Data Scientist do? (NWMUURD) create new ways of modeling and understanding the unknown by using raw data 01-022 - What are 3 reasons you analyze data? (PRT) find patterns, relationships, trends 01-023 - A critical question to ask up-front is, "How do I define ____ for this project? success 01-024 - Definition of a Data Set a collection of data that can be manipulated or analyzed as one unit 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 01-026 - Definition Data-Driven Decision-Making using facts to guide business strategy 01-027 - What are the 2 steps in Data-Driven Decision-Making? define a problem and analyze it 01-028 - What does the phrase, Data Analysis Life Cycle describe? the process of going from data to decision 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 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 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-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 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 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 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-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-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