Chapter 6 Flashcards

1
Q

Employees must be able to obtain and analyze different levels, formats, and granularities of organizational information to make effective decisions.

A

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

Successfully collecting, compiling, sorting, and analyzing information can provide tremendous insight into how an organization is performing.

A

….

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

The 4 Primary Traits affecting the value of information are

A
Information Type
Information Timeliness
Information Quality
Information Governance 
***Remember TTQG***
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Transactional Information

A

Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks.

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

Analytical Information

A

Encompasses all organizational information, and its primary purpose is to support managerial analysis.

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

Timeliness is an aspect of information that depends on the situation.

A

….

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

Real Time Information

A

Immediate, up-to-date information.

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

Real Time Systems

A

Provides real-time information in response to requests.

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

Business decisions are only as good as the quality of the information used to make the decisions.

A

…..

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

The 5 Characteristics of High-Quality Information are;

A
1 Accurate
2 Complete
3 Consistent
4 Unique 
5 Timely
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The 4 Primary Sources of low quality information include;

A

1) Customers Intentionally do it
2) Different entry standards
3) Operators enter errors by accident
4) Third Party And External Information

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

What are the potential business effects resulting from low quality information?

A

1) Inability to accurately track customers
2) Difficulty identifying valuable customers
3) Inability to identify selling opportunities
4) Marketing to nonexistent customers
5) DIFFICULTY TRACKING REVENUE
6) Inability to build strong customer relationships

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

High Quality Information can significantly improve the chances of making a good decision. Good decisions can directly impact the organizations bottom line.

A

….

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

Relational Databases

Information is everywhere in an organization and must be organized to be valuable.

A

…..

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

Database

A

Maintains information about various types of attributes:

1) Objects (inventory)
2) Events (transactions)
3) People (employees)
4) Places (warehouses)

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

Database Management System (DBMS)

A

Allows users to create, read, update, and delete data in a relational database.

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

Data Element

A

THe smallest or basic unit of information

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

Data Model

A

Logical data structures that detail the relationships among data elements using graphics or pictures.

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

Metadata

A

Provides details about data

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

Data dictionary

A

Compiles all of the metadata about the data elements in the data model.

21
Q

Entity

A

A person, place, thing, transaction, or event about which information is stored The rows in a table contain entities.

22
Q

Attribute (field, column)

A

The data elements associated with an entity The columns in each table contain attributes.

23
Q

Record

A

A collection of related data elements.

24
Q

What are the 5 Business Advantages to Relational Databases. Pg133

A

25
Q

Scalability

A

Refers to how well a system adapts to increased demands

26
Q

Performance

A

Measures how quickly a system performs a certain process or transaction.

27
Q

Information Redundancy

A

The duplication of data or storing the same information in multiple places.

28
Q

Information Integrity

A

Measures the quality of information

29
Q

Data Warehouse

A

A collection of information from many different operas toon also databases– that supports business analysis activities and decision-making tasks.

30
Q

The primary purpose of a data warehouse is to aggregate information throughout an organization (enterprise-wide) into a single repository for decision-making purposes.

A
31
Q

What is the primary difference between a database and data warehouse? (EXAM QUESTION)

A

A Database store information for a single application.

A data warehouse store information from multiple databases, or multiple applications, and external information such as industry information.

32
Q

Extraction, Transformation, and Loading (FTL)

A

A process that extracts information from several databases and loads the information into a data warehouse.

33
Q

Databases contain information in a series of two dimensional tables. Rows and Columns

A
34
Q

In a data Warehouse and data mart, information is multidimensional, it contains layers of columns and rows.

A
35
Q

Dimension

A

A particular attribute of information. I.E. products, promo, stores, stock price, date, time

36
Q

Cube

A

Common term for multidimensional information.

37
Q

Information cleansing or “Scrubbing”

A

A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

38
Q

Data Mining

A

The process of analyzing data to extract information.

39
Q

Data-Mining-Tools

A

Find patterns and relationships in large volumes of information.

40
Q

Data Mining Tools include query tools, reporting tools, multidimensional analysis tools, statistical tools, and intelligent agents.

A
41
Q

Structured Data

A

Data already in a database or a spreadsheet.

42
Q

Unstructured Data

A

Data does not exist in a fixed location and can include text documents, PDFs, voice messages, emails.

43
Q

Cluster

A

A technique used to divide an information set into mutually exclusive groups such that members of each group are close together as possible to one another and the different groups are as far apart as possible. I.e. Consumer goods by content, brand loyalty or similarity. Retail store layouts and sales performances.

44
Q

Association

A

Revels the degree to which variables are related and the nature……..(rest in powerpoint)

45
Q

Statistical Analysis

A

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

46
Q

Business Intelligence will improve the quality of business decisions & has a direct impact on costs and revenue.

A
47
Q

GOOD BI enables business users to receive data for analysis that is:

A

1) Reliable
2) Consistent
3) Understandable
4) Easily manipulated.

48
Q

Data Visualization

A

Allows users to “see” or visualize data to transform information into a business perspective

49
Q

Data Visualization Tools

A

Sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series……(more in powerpoint)