Concepts

Question 1

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

Answer 1

Data Analysis

Question 2

What are the six steps of the data analysis process?

Answer 2

Ask
Prepare
Process
Analyze
Share
Act

Question 3

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

Answer 3

Data Ecosystem

Question 4

The graphical representation of information.

Answer 4

Visualization

Question 5

A method for examining and calculating how a process works currently in order to get where you want to be in the future

Answer 5

Gap Analysis

Question 6

What is the life cycle of data?

Answer 6

Plan 
Capture 
Manage
Analyze 
Archive 
Destroy

Question 7

A collection of data stored in a computer system

Answer 7

Database

Question 8

People who have invested time and resources into a project and are interested in the outcome.

Answer 8

Stakeholders

Question 9

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

Answer 9

Attribute

Question 10

All of the attributes for something contained in a row of a data table

Answer 10

Observation

Question 11

A unique set of guidelines for a programming language

Answer 11

Syntax

Question 12

What is the basic SQL structure?

Answer 12

SELECT [choose from the column you want]
FROM [from the appropriate table]
WHERE [a certain condition is met]

Question 13

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

Answer 13

Structured thinking

Question 14

The specific and objective measures of numerical facts. This is often the what, how many, and how often about a problem.

Answer 14

Quantitative data

Question 15

Subjective or explanatory measures of qualities and characteristics or things that can’t be measured with numerical data. Used to answer why questions

Answer 15

Qualitative data

Question 16

A static collection of data given to stakeholders periodically.

Answer 16

Report

Question 17

Monitors live incoming data

Answer 17

Dashboard

Question 18

A data summarization tool that is used to summarize, sort, recognize, group, count, total or average data stored in a database

Answer 18

Pivot table

Question 19

A single quantifiable type of data that can be used for measurement.

Answer 19

Metric

Question 20

What are the metrics used in ROI (Return on Investment)?

Answer 20

Profit and Investments

Question 21

What are the types of dashboards?

Answer 21

Strategic- focuses on long term goals and strategies at the highest level of metrics
Operational- short term performance tracking and intermediate goals
Analytical- consists of the datasets and the mathematics used in those sets

Question 22

Something made up of specific metrics over a short, well-defined period of time and used to make day-to-day decisions.

Answer 22

Small data

Question 23

Large less specific datasets covering a long period of time and usually have to be broken down and analyzed.

Answer 23

Big data

Question 24

A collection of two or more cells

Answer 24

Range

Question 25

An agreed upon outline of the work you're going to perform on a project

Answer 25

Scope of Work (SOW)

Question 26

What is the format of SOW

Answer 26

Deliverables Milestones Timeline Reports

Question 27

Small files stored on computers that contain information about users

Answer 27

Cookies

Question 28

Data collected by an individual or group using their own resources

Answer 28

First-party data

Question 29

Data collected by a group directly from its audience and then sold

Answer 29

Second-party data

Question 30

Data collected from outside sources who did not collect it directly.

Answer 30

Third-party data

Question 31

Part of a population that is representative of the population

Answer 31

Sample

Question 32

Data that is counted and has a limited number of values.

Answer 32

Discrete data

Question 33

Data that can be measured using a timer and its value can be shown as a decimal with several spaces.

Answer 33

Continuous data

Question 34

A type of qualitative data that is categorized without a set order

Answer 34

Nominal data

Question 35

A type of qualitative data with a set order or scale

Answer 35

Ordinal data

Question 36

Data that lives within a company's own systems

Answer 36

Internal data

Question 37

Data that lives and is generated outside of an organization

Answer 37

External data

Question 38

Data that is organized in a certain format, such as rows and columns.

Answer 38

Structured data

Question 39

A model that is used for organizing data elements and how they relate to one another.

Answer 39

Data model

Question 40

A data model that gives you a high-level view of your data structure, such as how you want the data to interact across an organization.

Answer 40

Conceptual data model

Question 41

A data model that focuses on the technical details of the model such as relationships, attributes and entities

Answer 41

Logical data model

Question 42

A data model that depicts how the database was built; laying out how each database will be put in place and how the databases., applications and features will interact in specific detail

Answer 42

Physical data modeling

Question 43

A specific kind of data attribute that tells what kind of value the data is.

Answer 43

Data type

Question 44

What are examples of data types in spreadsheets?

Answer 44

number boolean text or string

Question 45

The process of changing the data's format, structure or values.

Answer 45

Data transformation

Question 46

The tendency for different people to observe things differently.

Answer 46

Observer bias

Question 47

The tendency to always interpret ambiguous situations in a positive or negative way

Answer 47

Interpretation bias

Question 48

The tendency to search for or interpret information in a way that confirms preexisting beliefs

Answer 48

Confirmation bias

Question 49

Well-founded standards of right and wrong that dictate how data is collected, shared and used

Answer 49

Data ethics

Question 50

What are some aspects of data ethics?

Answer 50

``` Ownership Transaction Transparency Consent Currency Privacy Oppenness ```

Question 51

The process of protecting people's private or sensitive data by eliminating PII (personally identifiable information)

Answer 51

Data Anonymization

Question 52

Data about data, it tells you where the data comes from, when and how it was created and what it is all about

Answer 52

Metadata

Question 53

A database that contains a series of tables that can be connected to form a relationship

Answer 53

Relational Database

Question 54

An identifier that references a column in which each value is unique

Answer 54

Primary key

Question 55

A field within a table that is a primary key in another table

Answer 55

Foreign key

Question 56

A database in which only related data is stored in each table

Answer 56

Normalized database

Question 57

A way of describing the way something is organized

Answer 57

Schema

Question 58

The process of storing data in multiple locations

Answer 58

Data replication

Question 59

The process of copying data from a storage device to memory or from one computer to another.

Answer 59

Data transfer

Question 60

Changing data to make it more organized and easier to read

Answer 60

Data manipulation

Question 61

The difference between the sample results and the results if you surveyed the entire population.

Answer 61

Margin of error

Question 62

The term for how confident you are in the survey results

Answer 62

Confidence level

Question 63

The range of possible values that the population's results would be at, the confidence level of the study

Answer 63

Confidence interval

Question 64

The determination of whether your results could be due to random chance or not.

Answer 64

Statistical significance

Question 65

An indication that a value does not exist in a dataset

Answer 65

Null

Question 66

A tool for checking the accuracy and quality of data before adding or importing it.

Answer 66

Data validation

Question 67

The process of combining two or more datasets into a single dataset

Answer 67

Data merging

Question 68

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

Answer 68

Changelog

Question 69

A process to confirm that data-cleaning effort was well executed and the resulting data is accurate and reliable

Answer 69

Verification