Course 1 & 2 Vocabulary Flashcards

1
Q

A question whose answers lead to change

A

Action-oriented question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A process or set of rules followed for a specific task

A

Algorithm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Qualities and characteristics associated with using facts to solve problems

A

Analytical skills

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Analytical thinking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

AVERAGE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Big data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Borders

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The question or problem that data analysis resolves for a business

A

Business task

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Cell reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The condition in which something exists or happens

A

Context

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

COUNT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A tool that monitors live, incoming data

A

Dashboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A collection of facts

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Data Analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Data analysis process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Data analyst

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

The science of data

A

Data analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How information is organized

A

Data design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Using facts to guide business strategy

A

Data-driven decision-making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

Data ecosystem

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Exploring different data sources to find out what they have in common

A

Data-inspired decision-making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

Data life cycle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

Data science

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

Data strategy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

The graphical representation of data

A

Data visualization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A collection of data stored in a computer system

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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

A

Dataset

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

Equation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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

A

Fairness

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

First handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

A

Filtering

34
Q

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

A

Formula

35
Q

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

A

Function

36
Q

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

A

Gap analysis

37
Q

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

A

Header

38
Q

A question that steers people toward a certain response

A

Leading question

39
Q

A calculation that involves addition, subtraction, multiplication, or division (also called an equation)

A

Math expression

40
Q

A function that is used as part of a mathematical formula

A

Math function

41
Q

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

A

MAX

42
Q

A question whose answers can be quantified and assessed

A

Measurable question

43
Q

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

A

Metric

44
Q

A measurable goal set by a company and evaluated using metrics

A

Metric Goal

45
Q

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

A

MIN

46
Q

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

A

Observation

47
Q

Data that is available to the public

A

Open data

48
Q

A symbol that names the operation or calculation to be performed

A

Operator

49
Q

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

A

Order of operations

50
Q

A chart created from the fields in a pivot table

A

Pivot chart

51
Q

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

A

Pivot table

52
Q

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

A

Problem domain

53
Q

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

A

Problem types

54
Q

A subjective and explanatory measure of a quality or characteristic

A

Qualitative data

55
Q

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

A

Quantitative data

56
Q

A request for data or information from a database

A

Query

57
Q

A computer programming language used to communicate with a database

A

Query language

58
Q

A collection of two or more cells in a spreadsheet

A

Range

59
Q

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

A

Reframing

60
Q

A question that has significance to the problem to be solved

A

Relevant question

61
Q

A static collection of data periodically given to stakeholders

A

Report

62
Q

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

A

Return on investment (ROI)

63
Q

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

A

Revenue

64
Q

The reason why a problem occurs

A

Root cause

65
Q

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

A

Scope of work (SOW)

66
Q

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

A

Small data

67
Q

A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound

A

SMART methodology

68
Q

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

A

Sorting

69
Q

A question that is simple, significant, and focused on a single topic or a few closely related ideas

A

Specific question

70
Q

A digital worksheet

A

Spreadsheet

71
Q

Refer to Structured Query Language

A

SQL

72
Q

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

A

Stakeholders

73
Q

A computer programming language used to communicate with a database

A

Structured Query Language (SQL)

74
Q

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

A

Structured thinking

75
Q

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

A

SUM

76
Q

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

A

Technical mindset

77
Q

A question that specifies a timeframe to be studied

A

Time - bound question

78
Q

The rate at which employees voluntarily leave a company

A

Turnover rate

79
Q

A question that makes assumptions or is difficult to answer honestly

A

Unfair question

80
Q

(Refer to data visualization)

A

Visualization