Google Data Analytics Certification Glossary: Terms and Definitions

studied byStudied by 18 people
5.0(1)
Get a hint
Hint

World Health Organization

1 / 407

flashcard set

Earn XP

Description and Tags

This deck contains terms and definitions from the glossary of the Google Data Analytics certification program, which includes 8 courses and is available on Coursera.

408 Terms

1

World Health Organization

An organization whose primary role is to direct and coordinate international health within the United Nations system

New cards
2

X-axis

The horizontal line of a graph usually placed at the bottom, which is often used to represent time scales and discrete categories

New cards
3

Y-axis

The vertical line of a graph usually placed to the left, which is often used to represent frequencies and other numerical variables

New cards
4

YAML

A language that translates data to improve readability

New cards
5

A/B testing

The process of testing two variations of the same web page to determine which page is more successful at attracting user traffic and generating revenue

New cards
6

Absolute reference

A reference within a function that is locked so that rows and columns won’t change if the function is copied

New cards
7

Access control

Features such as password protection, user permissions, and encryption that are used to protect a spreadsheet

New cards
8

Accuracy

The degree to which data conforms to the actual entity being measured or described

New cards
9

Action-oriented question

A question whose answers lead to change

New cards
10

Administrative metadata

Metadata that indicates the technical source of a digital asset

New cards
11

Aesthetic (R)

A visual property of an object in a plot

New cards
12

Agenda

A list of scheduled appointments

New cards
13

Aggregation

The process of collecting or gathering many separate pieces into a whole

New cards
14

Algorithm

A process or set of rules followed for a specific task

New cards
15

Aliasing

Temporarily naming a table or column in a query to make it easier to read and write

New cards
16

Alternative text

Text that provides an alternative to non-text content, such as images and videos

New cards
17

Analytical skills

Qualities and characteristics associated with using facts to solve problems

New cards
18

Analytical thinking

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

New cards
19

Annotation

Text that briefly explains data or helps focus the audience on a particular aspect of the data in a visualization

New cards
20

Anscombe’s quartet

Four datasets that have nearly identical summary statistics but contain different plotted values

New cards
21

Area chart

A data visualization that uses individual data points for a changing variable connected by a continuous line with a filled in area underneath

New cards
22

Argument (R)

Information needed by a function in R in order to run

New cards
23

Arithmetic operator

An operator used to perform basic math operations such as addition, subtraction, multiplication, and division

New cards
24

Array

A collection of values in spreadsheet cells

New cards
25

Assignment operator

An operator used to assign values to variables and vectors

New cards
26

Attribute

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

New cards
27

Audio file

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

New cards
28

AVERAGE

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

New cards
29

AVERAGEIF

A spreadsheet function that returns the average of all cell values from a given range that meet a specified condition

New cards
30

Bad data source

A data source that is not reliable, original, comprehensive, current, and cited (ROCCC)

New cards
31

Balance

The design principle of creating aesthetic appeal and clarity in a data visualization by evenly distributing visual elements

New cards
32

Bar graph

A data visualization that uses size to contrast and compare two or more values

New cards
33

Bias

A conscious or subconscious preference in favor of or against a person, group of people, or thing

New cards
34

Big data

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

New cards
35

Boolean data

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

New cards
36

Borders

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

New cards
37

Box plot

A data visualization that displays the distribution of values along an x-axis

New cards
38

Bubble chart

A data visualization that displays individual data points as bubbles, comparing numeric values by their relative size

New cards
39

Bullet graph

A data visualization that displays data as a horizontal bar chart moving toward a desired value

New cards
40

Business metric

A standard of measurement used to solve a business task

New cards
41

Business task

The question or problem data analysis resolves for a business

New cards
42

C#

An object-oriented programming language used to create games and mobile apps in the .NET open source developer platform

New cards
43

C++

An extension of the C programming language that is used to create console games, such as those for Xbox

New cards
44

Calculated field

A new field within a pivot table that carries out certain calculations based on the values of other fields

New cards
45

Calculus

A branch of mathematics that involves the study of rates of change and the changes between values that are related by a function

New cards
46

CASE

A SQL statement that returns records that meet conditions by including an if/then statement in a query

New cards
47

Case study

A common way for employers to assess job skills and gain insight into how a candidate approaches common data-related challenges

New cards
48

CAST

A SQL function that converts data from one datatype to another

New cards
49

Causation

When an action directly leads to an outcome, such as a cause-effect relationship

New cards
50

Cell reference

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

New cards
51

Changelog

A file containing a chronologically ordered list of modifications made to a project

New cards
52

Channel

A visual aspect or variable that represents characteristics of the data in a visualization

New cards
53

Chart

A graphical representation of data from a worksheet

New cards
54

Circle view

A data visualization that shows comparative strength in data

New cards
55

Clean data

Data that is complete, correct, and relevant to the problem being solved

New cards
56

Cloud

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

New cards
57

Cluster

A collection of data points on a data visualization with similar values

New cards
58

COALESCE

A SQL function that returns non-null values in a list

New cards
59

Code chunk

A piece of code added in an R Markdown file that is used to process, visualize or analyze data

New cards
60

Coding

The process of writing instructions to a computer in the syntax of a specific programming language

New cards
61

Column chart

A data visualization that uses individual data points for a changing variable, represented as vertical columns

New cards
62

Combo chart

A data visualization that combines more than one visualization type

New cards
63

Compatibility

How well two or more datasets are able to work together

New cards
64

Completeness

The degree to which data contains all desired components or measures

New cards
65

Computer programming

The process of giving instructions to a computer in order to perform an action or set of actions

New cards
66

CONCAT

A SQL function that adds strings together to create new text strings that can be used as unique keys

New cards
67

CONCATENATE

A spreadsheet function that joins together two or more text strings

New cards
68

Conditional formatting

A spreadsheet tool that changes how cells appear when values meet specific conditions

New cards
69

Conditional statement

A declaration that if a certain condition holds, then a certain event must take place

New cards
70

Confidence interval

A range of values that conveys how likely a statistical estimate reflects the population

New cards
71

Confidence level

The probability that a sample size accurately reflects the greater population

New cards
72

Confirmation bias

The tendency to search for or interpret information in a way that confirms pre-existing beliefs

New cards
73

Consent

The aspect of data ethics that presumes an individual’s right to know how and why their personal data will be used before agreeing to provide it

New cards
74

Consistency

The degree to which data is repeatable from different points of entry or collection

New cards
75

Context

The condition in which something exists or happens

New cards
76

Continuous data

Data that is measured and can have almost any numeric value

New cards
77

CONVERT

A SQL function that changes the unit of measurement of a value in data

New cards
78

Cookie

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

New cards
79

Correlation

The measure of the degree to which two variables change in relationship to each other

New cards
80

COUNT

A spreadsheet function that counts the number of cells within a range the meet a specified condition

New cards
81

COUNTA

A spreadsheet function that counts the total number of values within a specified range that meet specified criteria

New cards
82

COUNTIF

A spreadsheet function that returns the number of cells within a range that match a specified value

New cards
83

COUNT DISTINCT

A SQL function that only returns the distinct values in a specified range

New cards
84

CRAN (Comprehensive R Archive Network) (R)

An online archive with R packages, source code, manuals, and documentation

New cards
85

CREATE TABLE

A SQL clause that adds a temporary table to a database that can be used by multiple people

New cards
86

Cross-field validation

A process that ensures certain conditions for multiple data fields are satisfied

New cards
87

CSS (Cascading Style Sheets)

A programming language used for web page design that controls graphic elements and page presentation

New cards
88

CSV (comma-separated values) file

A delimited text file that uses a comma to separate values

New cards
89

Currency

The aspect of data ethics that presumes individuals should be aware of financial transactions resulting from the use of their personal data and the scale of those transactions

New cards
90

Dashboard

A tool that monitors live, incoming data

New cards
91

Data

A collection of facts

New cards
92

Data aggregation

The process of gathering data from multiple sources and combining it into a single, summarized collection

New cards
93

Data analysis

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

New cards
94

Data analysis process

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

New cards
95

Data analyst

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

New cards
96

Data analytics

The science of data

New cards
97

Data anonymization

The process of protecting people's private or sensitive data by eliminating identifying information

New cards
98

Data bias

When a preference in favor of or against a person, group of people, or thing systematically skews data analysis results in a certain direction

New cards
99

Data blending

A Tableau method that combines data from multiple data sources

New cards
100

Data composition

The process of combining the individual parts in a visualization and displaying them together as a whole

New cards

Explore top notes

note Note
studied byStudied by 70 people
... ago
5.0(1)
note Note
studied byStudied by 45 people
... ago
5.0(2)
note Note
studied byStudied by 24 people
... ago
5.0(1)
note Note
studied byStudied by 261 people
... ago
4.8(4)
note Note
studied byStudied by 22 people
... ago
5.0(2)
note Note
studied byStudied by 6 people
... ago
5.0(1)
note Note
studied byStudied by 1 person
... ago
5.0(1)
note Note
studied byStudied by 922 people
... ago
5.0(5)

Explore top flashcards

flashcards Flashcard (27)
studied byStudied by 7 people
... ago
5.0(1)
flashcards Flashcard (30)
studied byStudied by 94 people
... ago
4.0(1)
flashcards Flashcard (43)
studied byStudied by 40 people
... ago
5.0(1)
flashcards Flashcard (25)
studied byStudied by 213 people
... ago
4.7(3)
flashcards Flashcard (63)
studied byStudied by 12 people
... ago
5.0(1)
flashcards Flashcard (105)
studied byStudied by 2 people
... ago
5.0(2)
flashcards Flashcard (124)
studied byStudied by 6 people
... ago
5.0(1)
flashcards Flashcard (93)
studied byStudied by 440 people
... ago
5.0(1)
robot