Midterm 2

Question 1

Scope

Answer 1

Refers to all the work involved in creating the products of projects and the processes used to create them

Question 2

Deliverables

Answer 2

Product produced as part of a project, such as a hardware/software, planning docs, meeting minutes

Question 3

Project scope management

Answer 3

Defining and controlling what work is or is not included in a project

Question 4

Business intelligence

Answer 4

Includes a wide range or applications, practices and technologies for the extraction, transformation, integration, analysis, interpretation, and presentation of data to support improved decision making

Employed by organization to make and act on predictions about future conditions

Question 5

Data warehouse

Answer 5

Store large amounts of historical data in a form readily available/ supports analysis and management decision making

Question 6

Extract-transform-load (ETL)

Answer 6

Used to pull data from disparate data sources to populate and maintain data warehouses
-extract, transform, load steps

Question 7

Data mart

Answer 7

Smaller version of data warehouse

Designed from scratch

Question 8

Structural data

Answer 8

Format of data is known in advance

Traditional database

Question 9

Unstructured Data

Answer 9

Not organized in a predefined matter, large quantities from various sources

Ex. Text message, email

Can add a debt to an analysis

Question 10

Spreadsheet

Answer 10

Perform operations on data based on formula created by end user

Question 11

Reporting and querying

Answer 11

Preset data in an easy to understand fashion, not needing help from IT

Question 12

Rationale Database Model

Answer 12

Organizes structured data into collections of two dimensional tables called relations

Question 13

ACID Properties

Answer 13

atomicity, consistency, isolation, and durability

guarantee database transactions are processed reliably and ensure the integrity of data

Question 14

Drill-down analysis

Answer 14

enables decision makers to gain insight into the details of business data to understand why something happened

Question 15

Data mining

Answer 15

used to explore large amounts of data for hidden patterns

predicts future trends and behaviors

Question 16

Data Mining Process

Answer 16

Selection
Preprocessing
Transformation
Actual data mining process
Evaluation of results

Question 17

KPI’s (Key performance indicators)

Answer 17

track progress in executing chosen strategies

consists of a direction, measure, target and time frame

Question 18

Data Governance

Answer 18

ensures firm has reliable and actionable data to make informed business decisions

management of availability, usability, integrity, and security of data

Question 19

The Four V’s

Plus 2 More

Answer 19

volume, variety, velocity, veracity

vulnerability, value

Question 20

Volume

Answer 20

scale of data, how much do we have

Question 21

Variety

Answer 21

different forms of data

Question 22

Velocity

Answer 22

how fast data comes

Question 23

Veracity

Answer 23

how accurate data is

Question 24

Vulnerability

Answer 24

how exposed people are by the use of their personal data

Question 25

Value

Answer 25

how much value does it add to use personal data

Question 26

Extract step of ETL

Answer 26

Access various sources of data and pull from each source the data desired to update the data warehouse

Also filters for unwanted data

Question 27

Transform step of ETL

Answer 27

The data that will be used is edited and converted to a different format

Question 28

Load step of ETL

Answer 28

Updates the existing data warehouse with data that have passed through the extract and transform steps

Question 29

Big data

Answer 29

Data collections that are so enormous and complex that traditional data management software cannot deal with them