Download GOOGLE DATA ANALYTICS FOUNDATIONS MODULE 1 PRACTICE EXAM QUESTIONS and more Exams Information Technology in PDF only on Docsity!
GOOGLE DATA ANALYTICS FOUNDATIONS MODULE 1 PRACTICE EXAM
QUESTIONS
Data A collection of facts Data analysis The process of compiling, analyzing, and interpreting the results of primary and secondary data collection. Data Analyst A person who specializes in gathering and analyzing data to inform business decisions. Data Analytics the science of data Data-driven decision making An organizational process to gather and analyze relevant and verifiable data and then evaluate the results to guide business strategies. Fill in the blank: Analytical skills are the qualities and characteristics associated with using _____ to solve problems. predictions gut instinct feedback facts facts 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 analytical skills the ability to collect and analyze information, problem-solve, and make decisions. 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 Fill in the blank: The analytical skill _____ encompasses how someone organizes information. data strategy data mindset data design data analysis data design 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 design Data strategy The analytical skill that involves managing the processes and tools used in data analysis 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 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 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. 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. 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 The analysis phase It 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. 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. 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. 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 While planning a road trip, 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?
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 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 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 Database A collection of data stored in a computer system
Formula A set of instructions used to perform a calculation using the data in a spreadsheet 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 Query language A computer programming language used to communicate with a database Stakeholders People who invest time and resources into a project and are interested in its outcome Structured Query Language A computer programming language used to communicate with a database Spreadsheet A digital worksheet SQL (Structured Query Language) Attribute A characteristic or quality of data used to label a column in a table Function A preset command that automatically performs a specified process or task using the data in a spreadsheet Observation
Data analysis is creating new ways of understanding the unknown using raw data. Data analysis involves collecting, transforming, and organizing data. 1,2,
