Course 3 - Prepare Data for Exploration Flashcards
(157 cards)
1
Q
Access control
A
Features such as password protection, user permissions, and encryption that are used to protect a spreadsheet
2
Q
Action-oriented question
A
A question whose answers lead to change
3
Q
Administrative metadata
A
Metadata that indicates the technical source of a digital asset
4
Q
Agenda
A
A list of scheduled appointments
5
Q
Algorithm
A
A process or set of rules followed for a specific task
6
Q
Analytical skills
A
Qualities and characteristics associated with using facts to solve problems
7
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
8
Q
Attribute
A
A characteristic or quality of data used to label a column in a table
9
Q
Audio file
A
Digitized audio storage usually in an MP3, AAC, or other compressed format
10
Q
AVERAGE
A
A spreadsheet function that returns an average of the values from a selected range
11
Q
Bad data source
A
A data source that is not reliable, original, comprehensive, current, and cited (ROCCC)
12
Q
Bias
A
A conscious or subconscious preference in favor of or against a person, group of people, or thing
13
Q
Big data
A
Large, complex datasets typically involving long periods of time, which enable data analysts to address far-reaching business problems
14
Q
Boolean data
A
A data type with only two possible values, usually true or false
15
Q
Borders
A
Lines that can be added around two or more cells on a spreadsheet
16
Q
Business task
A
The question or problem data analysis resolves for a business
17
Q
Cell reference
A
A cell or a range of cells in a worksheet typically used in formulas and functions
18
Q
Cloud
A
A place to keep data online, rather than a computer hard drive
19
Q
Confirmation bias
A
The tendency to search for or interpret information in a way that confirms pre-existing beliefs
20
Q
Consent
A
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
21
Q
Context
A
The condition in which something exists or happens
22
Q
Continuous data
A
Data that is measured and can have almost any numeric value
23
Q
Cookie
A
A small file stored on a computer that contains information about its users
24
Q
COUNT
A
A spreadsheet function that counts the number of cells in a range that meet a specified criteria
25
CSV (comma-separated values) file
A delimited text file that uses a comma to separate values
26
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
27
Dashboard
A tool that monitors live, incoming data
28
Data
A collection of facts
29
Data analysis
The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
30
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
31
Data analyst
Someone who collects, transforms, and organizes data in order to draw conclusions, make predictions, and drive informed decision-making
32
Data analytics
The science of data
33
Data anonymization
The process of protecting people's private or sensitive data by eliminating identifying information
34
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
35
Data design
How information is organized
36
Data-driven decision-making
Using facts to guide business strategy
37
Data ecosystem
The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data
38
Data element
A piece of information in a dataset
39
Data ethics
Well-founded standards of right and wrong that dictate how data is collected, shared, and used
40
Data governance
A process for ensuring the formal management of a company’s data assets
41
Data-inspired decision-making
Exploring different data sources to find out what they have in common
42
Data interoperability
The ability to integrate data from multiple sources and a key factor leading to the successful use of open data among companies and governments
43
Data life cycle
The sequence of stages that data experiences, which include plan, capture, manage, analyze, archive, and destroy
44
Data model
A tool for organizing data elements and how they relate to one another
45
Data privacy
Preserving a data subject’s information any time a data transaction occurs
46
Data science
A field of study that uses raw data to create new ways of modeling and understanding the unknown
47
Data security
Protecting data from unauthorized access or corruption by adopting safety measures
48
Data strategy
The management of the people, processes, and tools used in data analysis
49
Data type
An attribute that describes a piece of data based on its values, its programming language, or the operations it can perform
50
Data visualization
The graphical representation of data
51
Database
A collection of data stored in a computer system
52
Dataset
A collection of data that can be manipulated or analyzed as one unit
53
Descriptive metadata
Metadata that describes a piece of data and can be used to identify it at a later point in time
54
Digital photo
An electronic or computer-based image usually in BMP or JPG format
55
Discrete data
Data that is counted and has a limited number of values
56
Equation
A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)
57
Ethics
Well-founded standards of right and wrong that prescribe what humans ought to do, usually in terms of rights, obligations, benefits to society, fairness, or specific virtues
58
Experimenter bias
The tendency for different people to observe things differently (Refer to Observer bias)
59
External data
Data that lives and is generated outside of an organization
60
Fairness
A quality of data analysis that does not create or reinforce bias
61
Field
A single piece of information from a row or column of a spreadsheet; in a data table, typically a column in the table
62
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
63
Filtering
The process of showing only the data that meets a specified criteria while hiding the rest
64
First-party data
Data collected by an individual or group using their own resources
65
Foreign key
A field within a database table that is a primary key in another table (Refer to primary key)
66
Formula
A set of instructions used to perform a calculation using the data in a spreadsheet
67
FROM
The section of a query that indicates where the selected data comes from
68
Function
A preset command that automatically performs a specified process or task using the data in a spreadsheet
69
Gap analysis
A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future
70
General Data Protection Regulation of the European Union (GDPR)
Policy-making body in the European Union created to help protect people and their data
71
Geolocation
The geographical location of a person or device by means of digital information
72
Good data source
A data source that is reliable, original, comprehensive, current, and cited (ROCCC)
73
Header
The first row in a spreadsheet that labels the type of data in each column
74
Internal data
Data that lives within a company’s own systems
75
Interpretation bias
The tendency to interpret ambiguous situations in a positive or negative way
76
Leading question
A question that steers people toward a certain response
77
Long data
A dataset in which each row is one time point per subject, so each subject has data in multiple rows
78
Math expression
A calculation that involves addition, subtraction, multiplication, or division (also called an equation)
79
Math function
A function that is used as part of a mathematical formula
80
MAX
A spreadsheet function that returns the largest numeric value from a range of cells
81
Measurable question
A question whose answers can be quantified and assessed
82
Mentor
Someone who shares knowledge, skills, and experience to help another grow both professionally and personally
83
Metadata
Data about data
84
Metadata repository
A database created to store metadata
85
Metric
A single, quantifiable type of data that is used for measurement
86
Metric goal
A measurable goal set by a company and evaluated using metrics
87
MIN
A spreadsheet function that returns the smallest numeric value from a range of cells
88
Naming conventions
Consistent guidelines that describe the content, creation date, and version of a file in its name
89
Networking
Building relationships by meeting people both in person and online
90
Nominal data
A type of qualitative data that is categorized without a set order
91
Normalized database
A database in which only related data is stored in each table
92
Notebook
An interactive, editable programming environment for creating data reports and showcasing data skills
93
Observation
The attributes that describe a piece of data contained in a row of a table
94
Observer bias
The tendency for different people to observe things differently (also called experimenter bias)
95
Open data
Data that is available to the public
96
Openness
The aspect of data ethics that promotes the free access, usage, and sharing of data
97
Operator
A symbol that names the operation or calculation to be performed
98
Order of operations
Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed
99
Ordinal data
Qualitative data with a set order or scale
100
Ownership
The aspect of data ethics that presumes individuals own the raw data they provide and have primary control over its usage, processing, and sharing
101
Pivot chart
A chart created from the fields in a pivot table
102
Pivot table
A data summarization tool used to sort, reorganize, group, count, total, or average data
103
Pixel
In digital imaging, a small area of illumination on a display screen that, when combined with other adjacent areas, forms a digital image
104
Population
In data analytics, all possible data values in a dataset
105
Primary key
An identifier in a database that references a column in which each value is unique (Refer to foreign key)
106
Problem domain
The area of analysis that encompasses every activity affecting or affected by a problem
107
Problem types
The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual
108
Qualitative data
A subjective and explanatory measure of a quality or characteristic
109
Quantitative data
A specific and objective measure, such as a number, quantity, or range
110
Query
A request for data or information from a database
111
Query language
A computer programming language used to communicate with a database
112
Range
A collection of two or more cells in a spreadsheet
113
Record
A collection of related data in a data table, usually synonymous with row
114
Redundancy
When the same piece of data is stored in two or more places
115
Reframing
The process of restating a problem or challenge, then redirecting it toward a potential resolution
116
Relational database
A database that contains a series of tables that can be connected to form relationships
117
Relevant question
A question that has significance to the problem to be solved
118
Report
A static collection of data periodically given to stakeholders
119
Return on investment (ROI)
A formula that uses the metrics of investment and profit to evaluate the success of an investment
120
Revenue
The total amount of income generated by the sale of goods or services
121
Root cause
The reason why a problem occurs
122
Sample
In data analytics, a segment of a population that is representative of the entire population
123
Sampling bias
Overrepresenting or underrepresenting certain members of a population as a result of working with a sample that is not representative of the population as a whole
124
Schema
A way of describing how something, such as data, is organized
125
Scope of work (SOW)
An agreed-upon outline of the tasks to be performed during a project
126
Second-party data
Data collected by a group directly from its audience and then sold
127
SELECT
The section of a query that indicates the subset of a dataset
128
Small data
Small, specific data points typically involving a short period of time, which are useful for making day-to-day decisions
129
SMART methodology
A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound
130
Social media
Websites and applications through which users create and share content or participate in social networking
131
Sorting
The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize
132
Specific question
A question that is simple, significant, and focused on a single topic or a few closely related ideas
133
Sponsor
A professional advocate who is committed to moving forward the career of another
134
Spreadsheet
A digital worksheet
135
SQL
Refer to Structured Query Language
136
Stakeholders
People who invest time and resources into a project and are interested in its outcome
137
String data type
A sequence of characters and punctuation that contains textual information (also called text data type)
138
Structural metadata
Metadata that indicates how a piece of data is organized and whether it is part of one or more than one data collection
139
Structured data
Data organized in a certain format such as rows and columns
140
Structured Query Language
A computer programming language used to communicate with a database
141
Structured thinking
The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options
142
SUM
A spreadsheet function that adds the values of a selected range of cells
143
Technical mindset
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way
144
Text data type
A sequence of characters and punctuation that contains textual information (also called string data type)
145
Third-party data
Data provided from outside sources who didn’t collect it directly
146
Time-bound question
A question that specifies a timeframe to be studied
147
Transaction transparency
The aspect of data ethics that presumes all data-processing activities and algorithms should be explainable and understood by the individual who provides the data
148
Turnover rate
The rate at which employees voluntarily leave a company
149
Unbiased sampling
When the sample of the population being measured is representative of the population as a whole
150
Unfair question
A question that makes assumptions or is difficult to answer honestly
151
United States Census Bureau
An agency in the U.S. Department of Commerce that serves as the nation’s leading provider of quality data about its people and economy
152
Unstructured data
Data that is not organized in any easily identifiable manner
153
Video file
A collection of images, audio files, and other data usually encoded in a compressed format such as MP4, MV4, MOV, AVI, or FLV
154
Visualization
Refer to data visualization
155
WHERE
The section of a query that specifies criteria that the requested data must meet
156
Wide data
A dataset in which every data subject has a single row with multiple columns to hold the values of various attributes of the subject
157
World Health Organization
An organization whose primary role is to direct and coordinate international health within the United Nations system
