Course 2 - Ask Questions to Make Data-Driven Decisions Flashcards

1
Q

Action-oriented question

A

A question whose answers lead to change

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

Algorithm

A

A process or set of rules followed for a specific task

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

Analytical skills

A

Qualities and characteristics associated with using facts to solve problems

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

Analytical thinking

A

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

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

Attribute

A

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

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

AVERAGE

A

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

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

Big data

A

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

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

Borders

A

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

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

Business task

A

The question or problem that data analysis resolves for a business

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

Cell reference

A

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

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

Cloud

A

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

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

Context

A

The condition in which something exists or happens

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

COUNT

A

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

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

Dashboard

A

A tool that monitors live, incoming data

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

Data

A

A collection of facts

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

Data analysis

A

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

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

Data analysis process

A

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

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

Data analyst

A

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

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

Data analytics

A

The science of data

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

Data design

A

How information is organized

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

Data-driven decision-making

A

Using facts to guide business strategy

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

Data ecosystem

A

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

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

Data-inspired decision-making

A

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

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

Data life cycle

A

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

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

Data science

A

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

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

Data strategy

A

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

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

Data visualization

A

The graphical representation of data

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

Database

A

A collection of data stored in a computer system

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

Dataset

A

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

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

Equation

A

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

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

Fairness

A

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

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

Fill handle

A

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

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

Filtering

A

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

34
Q

Formula

A

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

35
Q

Function

A

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

36
Q

Gap analysis

A

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

37
Q

Header

A

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

38
Q

Leading question

A

A question that steers people toward a certain response

39
Q

Math expression

A

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

40
Q

Math function

A

A function that is used as part of a mathematical formula

41
Q

MAX

A

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

42
Q

Measurable question

A

A question whose answers can be quantified and assessed

43
Q

Metric

A

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

44
Q

Metric goal

A

A measurable goal set by a company and evaluated using metrics

45
Q

MIN

A

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

46
Q

Observation

A

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

47
Q

Open data

A

Data that is available to the public

48
Q

Operator

A

A symbol that names the operation or calculation to be performed

49
Q

Order of operations

A

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

50
Q

Pivot chart

A

A chart created from the fields in a pivot table

51
Q

Pivot table

A

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

52
Q

Problem domain

A

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

53
Q

Problem types

A

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

54
Q

Qualitative data

A

A subjective and explanatory measure of a quality or characteristic

55
Q

Quantitative data

A

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

56
Q

Query

A

A request for data or information from a database

57
Q

Query language

A

A computer programming language used to communicate with a database

58
Q

Range

A

A collection of two or more cells in a spreadsheet

59
Q

Reframing

A

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

60
Q

Relevant question

A

A question that has significance to the problem to be solved

61
Q

Report

A

A static collection of data periodically given to stakeholders

62
Q

Return on investment (ROI)

A

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

63
Q

Revenue

A

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

64
Q

Root cause

A

The reason why a problem occurs

65
Q

Scope of work (SOW)

A

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

66
Q

Small data

A

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

67
Q

SMART methodology

A

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

68
Q

Sorting

A

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

69
Q

Specific question

A

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

70
Q

Spreadsheet

A

A digital worksheet

71
Q

SQL

A

Refer to Structured Query Language

72
Q

Stakeholders

A

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

73
Q

Structured Query Language

A

A computer programming language used to communicate with a database

74
Q

Structured thinking

A

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

75
Q

SUM

A

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

76
Q

Technical mindset

A

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

77
Q

Time-bound question

A

A question that specifies a timeframe to be studied

78
Q

Turnover rate

A

The rate at which employees voluntarily leave a company

79
Q

Unfair question

A

A question that makes assumptions or is difficult to answer honestly

80
Q

Visualization

A

Refer to data visualization