ITM 209 Exam 2- Data: Business
Intelligence and Business Analytics
Informing Information Case - ANS-pg 268-269
Foundation data concepts - ANS-Levels of Data: character and field
Records: related fields with attributes and length
Files: grouping of records with classification
Database: integrated collection of logically related data elements, consolidates records
into common pool of data elements, data is independent of application program and
storage device
Primary traits of information value - ANS-Information type
Information timeliness
Information quality
Information governance
Business Benefits of High-Quality Information - ANS-Information is everywhere in an
organization
Employees must be able to obtain and analyze the many different levels, formats, and
granularities of organizational information to make decisions
Successfully collecting, compiling, sorting, and analyzing information can provide
tremendous insight into how an organization is performing
The Costs of Using Low-Quality Information - ANS-Inability to accurately track
customers
Difficulty identifying valuable customers
Inability to identify selling opportunities
, Marketing to nonexistent customers
Difficulty tracking revenue
Inability to build strong customer relationships
Information Quality - ANS-Characteristics of high-quality Information
- Accurate
- Complete
- Consistent
- Unique
- Timely
Storing Information in a Relational Database - ANS-Information is everywhere in an
organization
Information is stored in databases
-Database: maintains information about various types of objects (inventory), events
(transactions), people (employees), and places (warehouses)
Relational Database Business Advantages - ANS-Increased flexibility
Increased scalability and performance
Increased information integrity
Increased information security
Reduced information redundancy
Increased Flexibility - ANS-A well-designed database should
-Handle changes quickly and easily
-Provide users with different views
-Have only one physical views (deals with the physical storage of information on a
storage device
-Have multiple logical views (focuses on how individual users logically access
information to meet their own particular business needs
Increased Scalability and Performance - ANS-A database must scale to meet increased
demand, while maintaining acceptable performance levels
Scalability: refers to how well a system can adapt to increased demands Performance:
Intelligence and Business Analytics
Informing Information Case - ANS-pg 268-269
Foundation data concepts - ANS-Levels of Data: character and field
Records: related fields with attributes and length
Files: grouping of records with classification
Database: integrated collection of logically related data elements, consolidates records
into common pool of data elements, data is independent of application program and
storage device
Primary traits of information value - ANS-Information type
Information timeliness
Information quality
Information governance
Business Benefits of High-Quality Information - ANS-Information is everywhere in an
organization
Employees must be able to obtain and analyze the many different levels, formats, and
granularities of organizational information to make decisions
Successfully collecting, compiling, sorting, and analyzing information can provide
tremendous insight into how an organization is performing
The Costs of Using Low-Quality Information - ANS-Inability to accurately track
customers
Difficulty identifying valuable customers
Inability to identify selling opportunities
, Marketing to nonexistent customers
Difficulty tracking revenue
Inability to build strong customer relationships
Information Quality - ANS-Characteristics of high-quality Information
- Accurate
- Complete
- Consistent
- Unique
- Timely
Storing Information in a Relational Database - ANS-Information is everywhere in an
organization
Information is stored in databases
-Database: maintains information about various types of objects (inventory), events
(transactions), people (employees), and places (warehouses)
Relational Database Business Advantages - ANS-Increased flexibility
Increased scalability and performance
Increased information integrity
Increased information security
Reduced information redundancy
Increased Flexibility - ANS-A well-designed database should
-Handle changes quickly and easily
-Provide users with different views
-Have only one physical views (deals with the physical storage of information on a
storage device
-Have multiple logical views (focuses on how individual users logically access
information to meet their own particular business needs
Increased Scalability and Performance - ANS-A database must scale to meet increased
demand, while maintaining acceptable performance levels
Scalability: refers to how well a system can adapt to increased demands Performance:
