Data Analytics Google Coursera Vocab

Front 1

Six Phases of data analysis

Back 1

Ask, Prepare, Process, Analyze, Share, Act

Hint 1

A.P.P.A.S.A

Front 2

Analytical skills

Back 2

Qualities and characteristics associated with using facts to solve problems.

Front 3

Analytical thinking

Back 3

The process of identifying and defining a problem, then solving it by using data in an organized, step-by-step manner

Front 4

Context

Back 4

The condition in which something exists or happens

Front 5

Data

Back 5

A collection of facts

Front 6

Data analysis

Back 6

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making

Front 7

Data analyst

Back 7

Someone who collects, transforms, and organizes data in order to draw conclusions, make predictions, and drive informed decision-making

Front 8

Data Analytics

Back 8

The science of data

Front 9

Data design

Back 9

How information is organized

Front 10

Data-driven decision-making

Back 10

Using facts to guide business strategy

Front 11

Data ecosystem

Back 11

The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data

Front 12

Data science

Back 12

A field of study that uses raw data to create new ways of modeling and understanding the unknown

Front 13

Data strategy

Back 13

The management of people, processes, and tools used in data analysis

Front 14

Data visualization

Back 14

The graphical representation of data

Front 15

Dataset

Back 15

A collection of data that can be manipulated or analyzed and one unit

Front 16

Gap analysis

Back 16

A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future

Front 17

Root cause

Back 17

The reason why a problem occurs

Front 18

Technical mindset

Back 18

The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way

Front 19

Visualization

Back 19

Same as data visualization

Front 20

5 aspects of analytical thinking

Back 20

Visualization, strategy, problem-orientation, correlation, big picture and detail oriented thinking

Hint 20

V.S.P.C.B.D

Front 21

Database

Back 21

A collection of data stored in a computer system

Front 22

Formula

Back 22

A set of instructions used to perform a calculation using the data in a spreadsheet

Front 23

Function

Back 23

A preset command that automatically performs a specified process or task using the data on a spreadsheet

Front 24

Query

Back 24

A request for data or information from a database

Front 25

Query language

Back 25

A computer programming language used to communicate with a database

Front 26

Stakeholders

Back 26

People who invest time and resources into a project and are interested in it outcome

Front 27

Structured Query Language (SQL)

Back 27

A computer programming language used to communicate with a database

Front 28

Spreadsheet

Back 28

A digital worksheet

Front 29

Attribute

Back 29

A characteristic or quality of data used to label a column in a table

Front 30

Function

Back 30

A preset command that automatically performs a specified process or task using the data in a spreadsheet

Front 31

Oversampling

Back 31

The process of increasing the sample size of non-dominant groups in a population. This can help you better represent them and address imbalanced datasets.

Front 32

Self-reporting

Back 32

A data collection technique where participants provide information about themselves.

Front 33

Business Task

Back 33

The question or problem data analysis solves for a business

Front 34

Fairness

Back 34

A quality of data analysis that does not create or reinforce bias

Front 35

Observation

Back 35

The attributes that describe a piece of data contained in a row of a table

Front 36

Action oriented question

Back 36

A question whose answers lead to change

Front 37

Cloud

Back 37

A place to keep data online rather than a computer hard drive

Front 38

Data analysis process

Back 38

The six Phases of ask, prepare, process, analyze, share, and act whose purpose is to gain insights that drive informed decision-making.

Front 39

Data life cycle

Back 39

The sequence of stages that data experiences which includes: plan, capture, manage, analyze, archive, and destroy.

Front 40

Leading question

Back 40

A question that steers people toward a certain response

Front 41

Measurable question

Back 41

A question whose answers can be quantified and assessed.

Front 42

Problem types

Back 42

The various problems that data analysts encounter includes: categorizing, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual

Front 43

Relevant question

Back 43

A question that has significance to the problem being solved

Front 44

SMART methodology

Back 44

A tool for determining a question's effectiveness. Specific, Measurable, Action-oriented, Relevant, and Time-bound.

Front 45

Structured thinking

Back 45

The process of recognizing the current problem or situation, organizing available info, revealing gaps and opportunities, and identifying problems

Front 46

Time-bound question

Back 46

A question that specifies a timeframe to be studied

Front 47

Unfair question

Back 47

A question that makes assumptions or is difficult to answer honestly

Front 48

Algorithm

Back 48

A process or set of rules followed for a specific task

Front 49

Big data

Back 49

Large, complex datasets typically involving long periods of time, which enable data analysts to address far-reaching business problems

Front 50

Dashboard

Back 50

A tool that monitors live, incoming data

Front 51

Data-inspired decision-making

Back 51

The process of exploring different data sources to find what they have in common

Front 52

Metric

Back 52

A single, quantifiable type of data that is used in measurement

Front 53

Metric goal

Back 53

A measurable goal set by a company and evaluated using metrics

Front 54

Pivot chart

Back 54

A chart created from the fields of the pivot table

Front 55

Pivot table

Back 55

A data summarization tool used to sort, reorganize, group, count, total, or average data

Front 56

Problem types

Back 56

The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual

Front 57

Qualitative data

Back 57

A subjective and explanatory measure of a quality or characteristic

Front 58

Quantitative data

Back 58

A specific and objective measure, such as number, quantity, or range

Front 59

Report

Back 59

A static collection of data periodically given to stakeholders

Front 60

Return on investment (ROI)

Back 60

A formula that uses metrics of investment and profit to evaluate the success of investment

Front 61

Revenue

Back 61

The total amount of income generated by the sale of goods or services

Front 62

Small data

Back 62

Small, specific data points typically involving a short period of time, which are useful for making day to day decisions

Front 63

AVERAGE

Back 63

A spreadsheet function that returns an average of the values selected from a range

Front 64

Borders

Back 64

Lines that can be added around two or more cells on a spreadsheet

Front 65

Cell reference

Back 65

A cell or a range of cells in a worksheet typically used in formulas or functions

Front 66

COUNT

Back 66

A spreadsheet function that counts the number of cells in a range that meet a specific criteria

Front 67

Equation

Back 67

A calculation that involves addition, subtraction, multiplication, or division (also called math expression)

Front 68

Fill handle

Back 68

A box in the lower right hand corner of a selected spreadsheet cell that can be dragged through neighboring cells in order to continue an instruction

Front 69

Filtering

Back 69

The process of showing only the data that meets a specified criteria while hiding the rest

Front 70

Header

Back 70

The first row in a spreadsheet that labels the type of data in each column

Front 71

Math function

Back 71

A function that is used as part of a mathematical formula

Front 72

MAX

Back 72

A spreadsheet function that returns the largest numeric value from a range of cells

Front 73

MIN

Back 73

A spreadsheet function that returns the smallest numeric value from a range of cells

Front 74

Open data

Back 74

Data that is available to the public

Front 75

Operator

Back 75

A symbol that names the operation or calculation to be performed

Front 76

Order of operations

Back 76

Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed

Front 77

Problem domain

Back 77

The area of analysis that encompasses every activity affecting or affected by a problem

Front 78

Range

Back 78

A collection of two or more cells in a spreadsheet

Front 79

Scope of Work (SOW)

Back 79

An agreed upon outline of the tasks to be performed during a project

Front 80

Sorting

Back 80

The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize

Front 81

SUM

Back 81

A spreadsheet function that adds the values of a selected range of cells

Front 82

Cloud

Back 82

A place to keep data online instead of a hard drive

Front 83

Reframing

Back 83

Restating a problem or challenge, then redirecting it toward a potential resolution

Front 84

Turnover rate

Back 84

The rate at which employees voluntarily leave a company

Front 85

Agenda

Back 85

A list of scheduled appointments

Front 86

Audio file

Back 86

Digitized audio storage usually in MP3, AAC, or other compressed format

Front 87

Boolean data

Back 87

A data type with only two possible values, usually true or false

Front 88

Continuous data

Back 88

Data that is measured and can have almost any numeric value

Front 89

Cookie

Back 89

A small file stored on a computer that contains information about its users.

Front 90

Data element

Back 90

A piece of information in a data set.

Front 91

Data model

Back 91

A tool for organizing data elements and how they relate to one another

Front 92

Digital photo

Back 92

An electronic or computer-based image usually in BMP or JPG format

Front 93

Discrete data

Back 93

Data that is counted and has a limited number of values

Front 94

External data

Back 94

data that lives, and is generated, outside of an organization

Front 95

Field

Back 95

A single piece of information from a row or column of a spreadsheet; in a data table, typically a column in the table

Front 96

First-party data

Back 96

Data collected by an individual or group using their own resources

Front 97

Long data

Back 97

A dataset in which each row is one time point per subject, so each subject has data in multiple rows

Front 98

Nominal data

Back 98

A type of qualitative data that is categorized without a set order

Front 99

Ordinal data

Back 99

Qualitative data with a set order or scale

Front 100

Ownership

Back 100

The aspect of data ethics that presumes individuals own the raw data they provide and have primary control over its usage, processing, and sharing

Front 101

Pixel

Back 101

In digital imaging, a small area of illumination of a display screen that, when combined with other adjacent areas, forms a digital image

Front 102

Population

Back 102

In Data Analytics, all possible values in a dataset

Front 103

Record

Back 103

A collection of related data in a data table, usually synonymous with row

Front 104

Sample

Back 104

In Data Analytics, a segment of a population that is representative of the entire population

Front 105

Second-party data

Back 105

Data collected by a group directly from its audience and then sold

Front 106

Social media

Back 106

Websites and applications through which users create and share content or participate in social networking

Front 107

String data type

Back 107

A sequence of characters and punctuation that contains textual information (also text data type)

Front 108

Text data type

Back 108

String data type

Front 109

Structured data

Back 109

Data organized in a certain format such as rows and columns

Front 110

United States Census Bureau

Back 110

An agency in the U.S. Department of Commerce that serves as the nations leading provider of quality data about it's people and economy

Front 111

Unstructured data

Back 111

Data that is not organized in any easily identifiable manner

Front 112

Video file

Back 112

A collection of images, audio files, and other data usually encoded in a compressed format such as MP4, MV4, MOV, AVI, or FLV

Front 113

Wide data

Back 113

A dataset in which every data subject has a single row with multiple column to hold the values of various attributes.