Chapter 6: Data: Business Intelligence Flashcards
4 Primary Traits of the Value of Data
- data type
- data timeliness
- data quailty
- data governance
Transactional Data
all of the data contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks
Analytical Data
all organizational data, and its primary purpose is to support the performing of managerial analysis tasks
Data Timeliness
an aspect of data that depends on the situation
Real-time Data
immediate, up-to-date data
Real-time System
real-time data in response to requests
Data Quality
successfully collecting, compiling, sorting, and analyzing data can provide tremendous insight into how an organization is performing
Characteristics of High-quality Data
- Accurate
- Complete
- Consistent
- Unique
- Timely
Database
maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
Database Management System (DBMS)
creates, reads, updates, and deletes data in a database while controlling access and security
Relational Database Model
stores information in the form of logically related 2D tables
Advantages of a Relational Database
- increased flexibility
- increased scalability
- increased data integrity
- increased data security
- reduced data redundance
Advantages of using business intelligence to support managerial decision making
enables business users to receive data for analysis that is reliable, consistent, understandable, easily manipulated
Data Warehouse
- a logical collection of data—gathered from many different operational databases—that supports business analysis activities and decision-making tasks
- extend the transformation of data into information
Primary Purpose of a Data Warehouse
is to aggregate data throughout an organization into a single repository for decision-making purposes
