Chapter 6 Flashcards

1
Q

What are the four aspects of data?

A

Data type, timeliness, quality, governance

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

Data type

A

Transactional (data), analytical (information)

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

Data governance

A

The management of the availability, usability, integrity, and security of data, implemented via policies

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

Database

A

A collection of tables to keep track of anything in which users are interested

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

DBMS

A

Creates, reads, updates, and deletes data in a database while controlling access and security

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

Data warehouse

A

A collection of data gathered from internal and external databases to support business analysis and decision-making

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

Internal databases

A

Marketing, sales, inventory, billing

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

External databases

A

Competitor information, industry information, mailing lists, stock market analysis

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

Scrubbing

A

Data cleaning: fixes or discards dirty data

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

ETL

A

Extraction, transformation, loading

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

Data mining

A

The process of analyzing a large amount of data to extract hidden patterns
and relationships among various factors
POP TART CAT WHOOOO

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

Cluster analysis is a form of what?

A

Data mining

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

Cluster analysis

A

To divide data into mutually exclusive groups such that the members within a group are as close together to one another as possible

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

Association detection

A

To reveal the relationship between variables, and the nature and frequency of the relationships

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

What is an example of association detection?

A

Market Basket Analysis

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

What is market basket analysis?

A

Analyzing what people buy together

17
Q

PRIZM

A

Sorts customers by shopping behaviors and media preferences

18
Q

P$YCLE

A

Sorts customers by their financial and

investment behaviors

19
Q

ConneXions

A

Sorts customers by their usage of technology, voice, video and data services

20
Q

Demographics

A

Quantifiable characteristics of a given population (marriage status, age, income, etc.)

21
Q

Information granularity

A

The extent of detail within the information

22
Q

Metadata

A

Provides details about data

23
Q

Information cube

A

The representation of multidimensional information: store info, product info, promotion info

24
Q

Association detection

A

Reveals the relationship between variables along with the nature and frequency of the relationships

25
Q

Statistical analysis

A

Performs such functions as information correlations, distributions, calculations, and variance analysis

26
Q

What are the five characteristics of data quality?

A
  1. Unique
  2. Accurate
  3. Complete
  4. Consistent
  5. Timely