Google Data Analytics (General terms Course 1)
Visualization
A graphical representation of data
What is the process of guiding business strategy using facts?
Data-driven decision-making
business task
The question or problem data analysis answers for a business
Data Driven Decision Making
Using facts to guide business strategy
issue
a topic or subject to investigate
question
designed to discover information
fairness
ensuring that your analysis doesn't create or reinforce bias
Data strategy
The management of the people, processes, and tools used in data analysis
problem
an obstacle or complication that needs to be worked out
SELECT - SQL command
choose the columns you want to return
FROM - SQL command
choose the tables where the columns you want are located
WHERE - SQL command
filter for certain information
Context
the condition in which something exists or happens
query language
A computer programming language used to communicate with a database (retrieve and manipulate data)
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
Phase: Ask
Ask questions to define both the issue to be solved and what would equal a successful result
Analytical thinking
Identifying and defining a problem and then solving it by using data in an organized, step-by-step manner
Cloud
Place to keep data online, rather than on a computer hard drive
Technical Mindset
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way
Data Design
how you organize information
Data Analytics
Science of data
Fill in the blank: Curiosity, understanding context, having a technical mindset, data design, and data strategy are _____. They enable data analysts to solve problems using facts.
Analytical skills
Question 4 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
Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply.
Increase the efficiency of a car manufacturer based on its current assembly process. Reduce a company's carbon footprint based on its current emissions. Improve accessibility for an educational app based on its current functionality.
A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet?
It adds context
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 clothing retailer collects and stores data about its sales revenue. Which of the following would be part of its data ecosystem?
The database of salves revenue, records of its inventory, the cloud that stores its database
Analytical Skills
The qualities and characteristics associated with solving problems using facts
Formula
a set of instructions that performs a specific calculation using data in the spreadsheet
Phase: Act
Determine what action is needed for "success"
Subject matter experts
people familiar with the business problem
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. It helps them identify trends more quickly It's easy to understand.
stakeholders
people who have invested time and resources into a project and are interested in the outcome
Root cause
The reason why a problem occurs
Gut instinct
An intuitive understanding of something with little or no explanation
Phase: Analyze
Analyze the clean data
What are the processes for data analytics?
Ask, Prepare, Process, Analyze, Share, Act
Phase: Prepare
Build a timeline and collect data
What are / Identify the real-world examples of how a company might make data-driven decisions.
Suggesting new music to a customer based on their listening history Scheduling a certain number of restaurant employees based on the average number of lunch-goers per day Choosing e-commerce solutions based on customer shopping preferences
What is data?
A collection of facts used to draw conclusions, make predictions, and assist in decision making.
Gap analysis
A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future
function
A preset command that automatically performs a specific process or task using data in a spreadsheet
Phase: Process
Clean data to make sure it was complete, correct, relevant, and free of errors and outliers
Phase: Share
Communicate findings and recommendations with the team
Data Science
Creating new ways of modeling and understanding the unknown by using raw data
Data Ecosystem
Group of elements that interact with one another to produce, manage, store, organize, analyze, and share data
Data Analysis
The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making