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
Data science
A field of study that uses raw data to create new ways of modeling and understanding the unknown
26
Data strategy
The management of the people, processes, and tools used in data analysis
27
Data visualization
The graphical representation of data
28
Database
A collection of data stored in a computer system
29
Dataset
A collection of data that can be manipulated or analyzed as one unit
30
Equation
A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)
31
Fairness
A quality of data analysis that does not create or reinforce bias
32
Fill handle
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
33
Filtering
The process of showing only the data that meets a specified criteria while hiding the rest
34
Formula
A set of instructions used to perform a calculation using the data in a spreadsheet
35
Function
A preset command that automatically performs a specified process or task using the data in a spreadsheet
36
Gap analysis
A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future
37
Header
The first row in a spreadsheet that labels the type of data in each column
38
Leading question
A question that steers people toward a certain response
39
Math expression
A calculation that involves addition, subtraction, multiplication, or division (also called an equation)
40
Math function
A function that is used as part of a mathematical formula
41
MAX
A spreadsheet function that returns the largest numeric value from a range of cells
42
Measurable question
A question whose answers can be quantified and assessed
43
Metric
A single, quantifiable type of data that is used for measurement
44
Metric goal
A measurable goal set by a company and evaluated using metrics
45
MIN
A spreadsheet function that returns the smallest numeric value from a range of cells
46
Observation
The attributes that describe a piece of data contained in a row of a table
47
Open data
Data that is available to the public
48
Operator
A symbol that names the operation or calculation to be performed
49
Order of operations
Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed
50
Pivot chart
A chart created from the fields in a pivot table
51
Pivot table
A data summarization tool used to sort, reorganize, group, count, total, or average data
52
Problem domain
The area of analysis that encompasses every activity affecting or affected by a problem
53
Problem types
The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual
54
Qualitative data
A subjective and explanatory measure of a quality or characteristic
55
Quantitative data
A specific and objective measure, such as a number, quantity, or range
56
Query
A request for data or information from a database
57
Query language
A computer programming language used to communicate with a database
58
Range
A collection of two or more cells in a spreadsheet
59
Reframing
Restating a problem or challenge, then redirecting it toward a potential resolution
60
Relevant question
A question that has significance to the problem to be solved
61
Report
A static collection of data periodically given to stakeholders
62
Return on investment (ROI)
A formula that uses the metrics of investment and profit to evaluate the success of an investment
63
Revenue
The total amount of income generated by the sale of goods or services
64
Root cause
The reason why a problem occurs
65
Scope of work (SOW)
An agreed-upon outline of the tasks to be performed during a project
66
Small data
Small, specific data points typically involving a short period of time, which are useful for making day-to-day decisions
67
SMART methodology
A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound
68
Sorting
The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize
69
Specific question
A question that is simple, significant, and focused on a single topic or a few closely related ideas
70
Spreadsheet
A digital worksheet
71
SQL
Refer to Structured Query Language
72
Stakeholders
People who invest time and resources into a project and are interested in its outcome
73
Structured Query Language
A computer programming language used to communicate with a database
74
Structured thinking
The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options
75
SUM
A spreadsheet function that adds the values of a selected range of cells
76
Technical mindset
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way
77
Time-bound question
A question that specifies a timeframe to be studied
78
Turnover rate
The rate at which employees voluntarily leave a company
79
Unfair question
A question that makes assumptions or is difficult to answer honestly
80
Visualization
Refer to data visualization