Google Data Analytics - Course 1

Next, you determine the average total daily sales over the past 12 months at all stores. The range that contains these sales is E2:E39. Identify the correct way to write your function.

=AVERAGE(E2:E39)

A magazine wants to understand why its subscribers have been increasing. A data analyst could help answer that question with a report that predicts the result of a half-price sale on future subscription rates.

False

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

False

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?

Nighttime riders

In which stage of the data life cycle does a business decide what kind of data it needs, how the data will be managed, and who will be responsible for it?

Plan

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

Query

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

Share

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.

The database of sales revenue Records of its inventory The cloud that store its database

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

A database is a collection of data stored in a computer system.

True

Now, it's time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing in one of the rows. You are unsure of how to proceed, so the best course of action is to ask your supervisor for guidance.

True

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

True

The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.

True

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?

WHERE supplier_id = 85317

When would a pie chart be an effective visualization?

When showing a class broken down by age

A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people's favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?

Manage

Data analysts use the five analytical skills of curiosity, understanding context, having a technical mindset, data design, and data strategy to make _____ decisions.

data-driven

A data visualization is the _____ representation of information.

graphical

The data life cycle has six stages, whereas data analysis has six _____.

process steps

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?

Data-driven decision-making

Describe the difference between a question and a problem in data analytics.

A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.

A data analyst is analyzing fruit and vegetable sales at a grocery store. They're able to find data on everything except red onions. What's the best course of action?

Ask a teammate for help finding data on red onions.

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 analysis

Which of the following statements best defines data?

Data is a collection of facts.

What is the process of guiding business strategy using facts?

Data-driven decision-making

In data analysis, which analytical skill involves the management of people, processes, and tools?

Data strategy

What is the term for the graphical representation of data?

Data visualization

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?

Data-driven decision-making

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.

planning

To request, retrieve, and update information in a database, data analysts use a ____.

query

A business task is described as the problem or _____ a data analyst answers for a business.

question

Changing the business task involves defining a new _____.

question or problem to be solved

In data analytics, SQL is an acronym meaning _____ query language.

structured

The people very familiar with a business problem are called _____. They are an important part of data-driven decision-making.

subject-matter experts

A problem is an obstacle to be solved, an issue is a topic to investigate, and a question is designed to discover information.

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

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

True

Data analysts ask, "Why?" five times in order to get to the root cause of a problem.

True

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

True

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

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

You've reached the share phase of the data analysis process. It involves creating a data visualization to highlight the Splashtastic sales insights you've discovered.

True

What steps do data analysts take to ensure fairness when collecting data? Select all that apply.

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

The primary goal of a data _____ is to find answers to existing questions by creating insights from data sources.

analyst

Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.

analytical skills

In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row.

attributes

Data-driven decision-making is described as using _____ to guide business strategy.

facts

In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.

organize

A doctor's office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. To help solve this problem, a data analyst could investigate how many nurses are on staff at a given time compared to the number of _____.

patients with appointments

Sharing the results of your analysis with colleagues who are very familiar with the business problem supports what practice?

Data-driven decision-making

Which of the following are examples of data visualizations? Select all that apply.

Maps Graphs Charts

Once you've found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add the attribute Average Percentage of Total Sales - Splashtastic. Select the correct definition for an attribute.

A characteristic or quality of data used to label a column

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?

Act

An advertising firm has used insights from its analytics team to create a strategy for improving sales. Now, they implement a plan to increase annual revenue. The firm is at which step of the data analysis process?

Act

After you added data to the spreadsheet, you cleaned up the chart. What step did you take to make the chart descriptive?

Adding a title to the chart

Having a technical mindset is an analytical skill involving what?

Breaking things down into smaller steps or pieces

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

Capture

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

Correlation

The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?

Define the problem to be solved

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?

Destroy

Which of the following examples describe fairness in data analysis? Select all that apply.

Factoring in social contexts that could create bias in conclusions Making sure a sample population represents all groups Considering systematic factors that may influence data

The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it's important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments. This will help them create an effective campaign for members. It's time to create your presentation to stakeholders. It will include a data visualization that depicts the relationship between age and follow-up dental appointment attendance rates. For this, a doughnut chart will be most effective.

False

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?

Gap analysis

Understanding context is an analytical skill best described by which of the following? Select all that apply.

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

A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet?

It improves the aesthetic appeal It adds context It clarifies the business strategy

Imagine you are sharing your data with a company stakeholder. Why might you display data with a data visualization instead of a table? Select all that apply.

It's aesthetically pleasing

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?

Make sure their recommendation doesn't create or reinforce bias

Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply.

Reduce a company's carbon footprint based on its current emissions Improve accessibility for an educational app based on its current functionality Increase the efficiency of a car manufacturer based on its current assembly process

What are the key benefits of data visualizations? Select all that apply.

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

In a spreadsheet, what is text wrapping used for?

To allow all of the text to fit inside a cell

You've been working for the nonprofit National Dental Society (NDS) as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff. The NDS is passionate about patient health. Part of this involves automatically scheduling follow-up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow-up is an important step to ensure patient recovery and minimize infection. Unfortunately, many patients don't show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow-up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients. Your supervisor has just sent you an email saying that you're doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow-up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations. An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So, your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member's three dental offices, located in zip code 81137. The table is dental_data_table, and the column name is zip_code. You have written the following query, but received an error when it ran. What is the clause that will correct this query?

WHERE zip_code = 81137

Curiosity, understanding context, having a technical mindset, data design, and data strategy are _____. They enable data analysts to solve problems using facts.

analytical skills

A set of instructions that performs a specific calculation using spreadsheet data is called _____.

a formula

Data ecosystems are made up of elements that _____ with each other. This makes it possible for them to produce, manage, store, organize, analyze, and share data.

interact

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

Analytical thinking

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

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

Analyze

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 number of patients seen per day compared to past years. Analyze the average length of an appointment this year compared to past years.

What tactics can a data analyst use to effectively blend gut instinct with facts? Select all that apply.

Apply their unique past experiences to their current work, while keeping in mind the story the data is telling. Use their knowledge of how their company works to better understand a business need.

The owner of a skate shop notices that every time a certain employee has a shift, there are higher sales numbers at the end of the day. After some investigation, the owner realizes that since the employee was hired, the store earns 15% more each month. In this scenario, the manager used which quality of analytical thinking?

Correlation

Seeking out new challenges and experiences in order to learn is an example of which analytical skill?

Curiosity

You've just started a new job as a data analyst. You're working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store's total daily sales come from that product. Then, you'll present your findings to leadership. You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you'll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company's 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, what's the best way to proceed with the process and analyze steps?

Download the data, then use a spreadsheet to process and analyze it.

A large hotel chain sees about 500 customers per week. A data analyst working there is gathering data through customer satisfaction surveys. They are anxious to begin analysis, so they start analyzing the data as soon as they receive 50 survey responses. This is an example of what? Select all that apply.

Failing to have a large enough sample size Failing to include diverse perspectives in data collection

The patient demographic information includes data such as age, gender, and home address. The fact that the dataset includes people who all live in the same zip code might get in the way of what?

Fairness

Data analysts ensure their analysis is fair for what reason?

Fairness helps them avoid biased conclusions.

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 the share step of the data analysis process.

False

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

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.

False

Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan.

False

Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data.

False

The people who are familiar with a problem and help verify the results of data analysis include customers and competitors.

False

An online gardening magazine wants to understand why its subscriber numbers have been increasing. What kind of reports can a data analyst provide to help answer that question? Select all that apply.

Reports that describe how many customers shared positive comments about the gardening magazine on social media in the past year Reports that examine how a recent 50%-off sale affected the number of subscription purchases Reports that compare past weather patterns to the number of people asking gardening questions to their social media

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.

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

This is a selection from a spreadsheet that ranks the 10 most populous cities in North Carolina. To alphabetize the county names in column D, which spreadsheet tool would you use?

Sort range

A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.

a predefined operation