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