Google Data Analytics
Context
The condition in which something exists or happens
Data visualization
The graphical representation of data
Syntax
the predetermined structure of a language that includes all required words, symbols, and punctuation, as well as their proper placement.
true
Data analysts use queries to request, retrieve, and update information within a database. True False
SELECT * FROM album WHERE album_id AND album_id>=277
How would you format this SQL? You are working with a database table that contains data about music albums. You are only interested in data related to the album with ID number 277. The album IDs are listed in the album_id column from the album table. You write the SQL query below. Add a WHERE clause that will return only data about the album with ID number 277.
Nighttime riders
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? Daytime riders Female passengers Male passengers Nighttime riders
Analytical skills
Qualities and characteristics associated with using facts to solve problems
Semicolon
The ______________ is a statement terminator
observation
The attributes that describe a piece of data contained in a row of a table
Define the problem to be solved
The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase? Clean the data Create data visualizations Define the problem to be solved Collect and store data
Data-driven decision-making
Using facts to guide business strategy
When showing a class broken down by age
When would a pie chart be an effective visualization? When showing a change in someone's age over time When showing a class broken down by age When showing the ages of males versus females When showing the relationship between age and income
Charts Graphs Maps
Which of the following are examples of data visualizations? Select all that apply. Charts Graphs Maps Reports
Data design
How information is organized
stakeholder
People who invest time and resources into a project and are interested in its outcome
Ask Prepare Explore Model Implement Act Evaluate
What are the 7 steps of the SAS data life cycle?
Correlation
Which aspect of analytical thinking involves being able to identify a relationship between two or more pieces of data? Visualization Context Data design Correlation
act
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 which step of the data analysis process? Process Act Share Analyze
Data science
A field of study that uses raw data to create new ways of modeling and understanding the unknown
False
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. This scenario describes data science. True False
Gap analysis
A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future
query
A request for data or information from a database
Fairness helps them avoid biased conclusions.
Data analysts ensure their analysis is fair for what reason? Fairness helps them communicate with stakeholders. Fairness helps them avoid biased conclusions. Fairness helps them stay organized. Fairness helps them pick and choose which data to include from a dataset.
True
Data design is how you organize information; data strategy is the management of the people, processes, and tools used in data analysis. True False
facts
Data is a collection of _____ that can be used to draw conclusions, make predictions, and assist in decision-making.
<>
means "does not equal"
Formula
A set of instructions used to perform a calculation using the data in a spreadsheet
Place a comma after each data field (column) and enter
How do you request multiple data fields (columns) from a table
destroy
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? Manage Archive Destroy Plan
True
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 False
Act
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? Process Prepare Act Ask
query
A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst's toolkit. Spreadsheet Query Visualization Dashboard
Curiosity
A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using? Data strategy Curiosity Understanding context Having a technical mindset
Function
A preset command that automatically performs a specified process or task using the data in a spreadsheet
Fairness
A quality of data analysis that does not create or reinforce bias
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. True False
Data-driven decision-making
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? Analytical thinking Performance measurement Data-driven decision-making Collaboration with stakeholders
Gap analysis
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? Strategy Data visualization The five whys Gap analysis
Adding descriptive headers to columns of data in a spreadsheet Gathering additional information about data to understand the broader picture Identifying the motivation behind the collection of a dataset
Understanding context is an analytical skill best described by which of the following? Select all that apply. Adding descriptive headers to columns of data in a spreadsheet Gathering additional information about data to understand the broader picture Identifying the motivation behind the collection of a dataset Working with facts in an orderly manner
Visualization Strategy Problem-orientation Correlation Big-picture and detail-oriented thinking
What are the 5 aspects of analytical thinking?
1. Ask: Business Challenge/Objective/Question 2. Prepare: Data generation, collection, storage, and data management 3. Process: Data cleaning/data integrity 4. Analyze: Data exploration, visualization, and analysis 5. Share: Communicating and interpreting results 6. Act: Putting your insights to work to solve the problem (And there are variations i.e. EMC, SAS
What are the 6 steps of data analytics?
Discovery Pre-processing data Model planning Model building Communicate results Operationalize
What are the 6 steps of the EMC data life cycle?
Scheduling a certain number of restaurant employees to work based on the average number of lunch-goers per day Choosing e-commerce solutions based on customer shopping preferences Suggesting new music to a customer based on their listening history
Identify the real-world examples of how a company might make data-driven decisions. Select all that apply. Scheduling a certain number of restaurant employees to work based on the average number of lunch-goers per day Choosing e-commerce solutions based on customer shopping preferences Suggesting new music to a customer based on their listening history Making spending decisions based on the gut instinct of the company accountant
Condition 1 AND Condition 2 AND Condition 3
If you have multiple conditions in your SQL query WHERE clause, how may this be formatted?
* (SELECT*)
If you replace SELECT field1 with SELECT _____ , you would be selecting all of the columns in the table instead of the field1 column only
to look for a certain pattern
In SQL, % tells the database to look for what?
dot
In a SQL query, the dataset name is always followed by a ________, and then the table name
To label a column
In a table, an attribute is a characteristic or quality of data used for what purpose? To reference a cell To label a column To gather related data To perform a calculation
Data strategy
In data analysis, which analytical skill involves the management of people, processes, and tools? Data analytics Data strategy Data control Data design
false
In data analytics, a model is a group of elements that interact with one another. True False
Data Ecosystem
In data analytics, what is the term for elements that interact with one another in order to produce, manage, store, organize, analyze, and share data?
capture
In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization? Analyze Capture Manage Archive
Analyze
In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals? Analyze Plan Capture Manage
Share
In which data analysis phase would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding? Prepare Process Act Share
To allow all of the text to fit inside a cell
Question 1 In a spreadsheet, what is text wrapping used for? To allow text to overflow into an adjacent cell To allow all of the text to fit inside a cell To clip text within a cell so it doesn't overflow into an adjacent cell To remove text that is too long to fit in a cell
An intuitive understanding of something with little or no explanation
Question 4 Select the best description of gut instinct. An intuitive understanding of something with little or no explanation Using your innate ability to analyze results Choosing facts that complement your personal experiences Manipulating data to match your intuition
SELECT * FROM invoice WHERE customer_id = 35
Question 6 You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 35. You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 35.
organize
Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data. locate organize ingest merge
process steps
Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. data analytics tools process steps key questions data types
analyst
Fill in the blank: The primary goal of a data _____ is to find answers to existing questions by creating insights from data sources. engineer scientist analyst designer
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 False
Breaking things down into smaller steps or pieces
Having a technical mindset is an analytical skill involving what? Breaking things down into smaller steps or pieces Understanding the condition in which something exists or happens Managing people, processes, and tools Balancing roles and responsibilities
Ask "why" 5 times
How can the root cause be strategically identified and tackled
Identify the root cause of a problem
The five whys is a technique that involves asking, "Why?" five times in order to achieve what goal? Use facts to guide business strategy Visualize how a process should look in the future Put a plan into action Identify the root cause of a problem
Plan: What plans and decisions do you need to make? What data do you need to answer your question? Capture: Where does your data come from? How will you get it? Manage: How will you store your data? What should it be used for? How do you keep this data secure and protected? Analyze: How will the company analyze the data? What tools should they use? Archive: What should they do with their data when it gets old? How do they know when it's time? Destroy: Should they ever dispose of any data? If so, when and how? What kind of data should they gather? How should they gather this data? Where will the data live? How will they store the data? Once they have the data, how will they use it? How do they keep their data secure and protected? What should they do with old data? What are their options? First, the ice cream company should plan exactly what they are looking for. In this case, they want to know their customers' ice cream flavor preferences. This qualitative data can be gathered from a simple survey from the customers that visit the shop. The data will live in a data base, and it will be stored securely here. Once they have the data, they can use it to determine how much of each flavor they should purchase going forward. They can keep their data secure and protected by archiving it. With the old data, they can either keep it in a secure archive or destroy it.
The hiring manager explains that they do not collect any customer data, and they don't know where to begin. The hiring manager asks you: Can you please explain how you would approach this task?
Data analytics
The science of data
Data ecosystem
The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data
Data Design
Thinking about the way you organize your contacts in a new phone is an example of which analytical skill? Data design Curiosity Data strategy Understanding context
The specifics
To execute a plan using detail-oriented thinking, what does a data analyst consider? The big picture The main idea The specifics The root cause
Data analysis
The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
database
A collection of data stored in a computer system
Dataset
A collection of data that can be manipulated or analyzed as one unit
data
A collection of facts
Attribute
A characteristic or quality of data used to label a column in a table
analyze
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 Plan Archive Capture
Make sure their recommendation doesn't create or reinforce bias
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? Decline to accept ads from Avens Engineering because of fairness concerns. Make sure their recommendation doesn't create or reinforce bias Let Avens Engineering decide which type of applicants to target ads to. Only show ads for the engineering jobs to women.
Store data Sort and filter data Organize data in columns and rows
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. Choose a topic for data analysis Store data Sort and filter data Organize data in columns and rows
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 False
A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.
Describe the difference between a question and a problem in data analytics. A question can have many answers, whereas a problem only has one solution. A question is uncertain, whereas a problem is clearly specified. A question is a topic to investigate, whereas a problem is a subject to investigate. A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.
false
During the capture stage of the data life cycle, a data analyst may use spreadsheets to aggregate data. True False
True
During the process phase of data analysis, a data analyst cleans data to ensure it's complete and correct. True False
Analyze
During which phase of data analysis would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions? Act Analyze Prepare Process
plan
Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle. capture manage plan analyze
filter
Fill in the blank: A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions. filter sort categorize copy
graphical
Fill in the blank: A data visualization is the _____ representation of information. graphical tabulated contextual attributed
database
Fill in the blank: A query language is a computer programming language that enables data analysts to retrieve and manipulate data from a _____. database drive spreadsheet folder
a formula
Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____. a report a program a formula an operation
WHERE field1 = 'Chavez'
If you are looking for a specific customer with the last name Chavez, the WHERE clause would be
WHERE field1 LIKE 'Ch%' (Sometimes an * is used instead of %)
If you are looking for all customers with a last name that begins with the letters "Ch," the WHERE clause would be:
Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Analyze the average length of an appointment this year compared to past years. Analyze the number of patients seen per day compared to past years.
Question 2 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 average length of an appointment this year compared to past years. Analyze the number of patients seen per day compared to past years. Analyze a recent change in the average rating for the doctor's office on social media.
True
Question 2 The columns in a spreadsheet are ordered by letter, and the rows are ordered by number. True False
False
Question 3 A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving. True False
True
Question 3 A database is a collection of data stored in a computer system. True False
structured
Question 4 In data analytics, SQL is an acronym meaning _____ query language. statistical structured syntax software
Data strategy
The management of the people, processes, and tools used in data analysis
Correlation
The manager at a music shop notices that more trombones are repaired on the days when Alex and Jasmine work the same shift. After some investigation, the manager discovers that Alex is excellent at fixing slides, and Jasmine is great at shaping mouthpieces. Working together, Alex and Jasmine repair trombones faster. The manager is happy to have discovered this relationship and decides to always schedule Alex and Jasmine for the same shifts. In this scenario, the manager used which quality of analytical thinking? Problem-orientation Correlation Big-picture thinking Visualization
Analytical thinking
The process of identifying and defining a problem, then solving it by using data in an organized, step-by-step manner
Business task
The question or problem data analysis resolves for a business
Root cause
The reason why a problem occurs
The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
Which of the following options describes data analysis? Creating new ways of modeling and understanding the unknown by using raw data The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making Using facts to guide business strategy
Data is a collection of facts.
Which of the following statements best defines data? Data is a business process. Data is an assortment of questions. Data is a collection of facts. Data is the use of calculations and statistics.
Data analysis
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 elements Data life cycle Data insight Data analysis
Having a technical mindset
You are planning a road trip. Your first step is to break down the planning into smaller pieces. You begin by calculating your budget. Then, you choose a destination and departure date. Next, you plan where to stay, what vehicle to take, and how long you want to be on the road. Which analytical skill does this scenario describe? Having a technical mindset Understanding context Curiosity Data design
AS
You can make it easier on yourself by assigning a new name or alias to the column or table names to make them easier to work with (and avoid the need for comments). This is done with a SQL ______ clause.
False
You read an interesting article about data analytics in a magazine and want to share some ideas from the article in the discussion forum. In your post, you include the author and a link to the original article. This would be an inappropriate use of the forum. True False
Query language
A computer programming language used to communicate with a database
query language
A computer programming language used to communicate with a database
Shared the results with subject-matter experts from the marketing team for their input
A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings and recommendations to the client. What should they have done before that presentation? Archived the datasets in order to keep them secure Shared the results with subject-matter experts from the marketing team for their input Created a model based on the results of the analysis Surveyed customers about results, conclusions, and recommendations
Analyzing customer buying behaviors
An online gardening magazine wants to understand why its subscriber numbers have been increasing. A data analyst discovers that significantly more people subscribe when the magazine has its annual 50%-off sale. This is an example of what? Analyzing the number of customers by calculating daily foot traffic Analyzing social media engagement Analyzing consumer preferences using artificial intelligence Analyzing customer buying behaviors
True
Data analysts answer questions and solve problems. These are called business tasks. True False
analytical skills
Fill in the blank: Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making. analytical skills thought processes data models business strategies
data-driven
Fill in the blank: Data analysts use the five analytical skills of curiosity, understanding context, having a technical mindset, data design, and data strategy to make _____ decisions. intuitive forward-looking more efficient data-driven
maps charts graphs
Fill in the blank: Data visualization involves using _____ to represent and present data. Select all that apply. maps charts graphs reports
facts
Fill in the blank: Data-driven decision-making is described as using _____ to guide business strategy. intuition facts gut instinct visualizations
planning
Fill in the blank: 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. manage planning archive capture
attributes
Fill in the blank: In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row. attributes names diagnostics commonalities
inclusive
Fill in the blank: In data analytics, fairness means ensuring that your analysis does not create or reinforce bias. This requires using processes and systems that are fair and _____. inclusive restrictive partial favorable
Data analyst
Someone who collects, transforms, and organizes data in order to drive informed decision-making
true
Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making. True False
Technical mindset
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way
They can help stakeholders understand complex data more quickly They can illustrate relationships between data points They can clearly demonstrate patterns and trends
What are the key benefits of data visualizations? Select all that apply. They can help stakeholders understand complex data more quickly They can ensure that you get fewer questions about your analysis They can illustrate relationships between data points They can clearly demonstrate patterns and trends
Plan: Decide what kind of data is needed, how it will be managed, and who will be responsible for it. Capture: Collect or bring in data from a variety of different sources. Manage: Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so. Analyze: Use the data to solve problems, make decisions, and support business goals. Archive: Keep relevant data stored for long-term and future reference. Destroy: Remove data from storage and delete any shared copies of the data.
What are the phases of data (data life cycle)
Identifying the problem Designing data requirements Pre-processing data Performing data analysis Visualizing data
What are the steps in the project-based data analytics life cycle?
Validate the choices made as a result of the data insights Review the results of data analysis and identify any inconsistencies
What do subject-matter experts do to support data-driven decision-making? Select all that apply. Validate the choices made as a result of the data insights Collect, transform, and organize data Review the results of data analysis and identify any inconsistencies Offer insights into the business problem
A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process.
What is the main difference between a formula and a function? A formula begins with an equal sign (=); a function begins with an asterisk (*). A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. A formula is used to add or subtract; a function is used to multiply or divide. A formula can be used multiple times in a spreadsheet; a function can only be used once.
Use SELECT to choose the columns you want to return. Use FROM to choose the tables where the columns you want are located. Use WHERE to filter for certain information.
What is the syntax of every SQL query?
Data visualization
What is the term for the graphical representation of data? 1 point Data visualization Data language Data collection Data summary
Next, enter the table name after the FROM; the table columns you want after the SELECT; and, finally, the conditions you want to place on your query after the WHERE. Make sure to add a new line and indent when adding these
What order should you type a SQL Query in?
Analytical thinking
What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner? Visualization Analytical thinking Context Data design
Understand the social context Include data self-reported by individuals Use an inclusive sample population
What steps do data analysts take to ensure fairness when collecting data? Select all that apply. Clean the data provided Understand the social context Include data self-reported by individuals Use an inclusive sample population
Comments
_________________ are text placed between certain characters, /* and */, or after two dashes (--) as shown below.
