CHAPTER 8 ACCESSING ORGANIZATIONAL INFORMATION-DATA WAREHOUSE

HISTORY OF DATA WAREHOUSE

• In 1990s as organizations began to need more timely information about their business, they found that traditional operational information systems were too cumbersome.
• during the latter half of the 20th century, the numbers and types of database increased.

DATA WAREHOUSE FUNDAMENTALS

• data warehouse- logical collection of information-gathered from many different operational databases-that supports business analysis activities and decision making tasks.
• extraction, transformation, and loading( ETL)- process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.
• data mart- contains a subset of data warehouse information. 

 

 MULTIDIMENSIONAL ANALYSIS AND DATA TIMING

• cube-  the common term for the representation of multidimensional information.
• a relational database contains information in a series of two-dimensional tables.
• a dimension is a particular attribute of information.
• data mining-  process of analyzing data to extract information not offered by the raw data alone.
• data  mining tools- use a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

 

INFORMATION CLEANSING OR SCRUBBING 

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

• contact information in operational systems

• standardizing customer name from operational systems

 

• information cleansing activities

 

• accurate and complete information. 

 

BUSINESS INTELLIGENCE

  applications and technologies that are used to gather, provide access to, and analyze data and information to support decision making efforts.

ENABLING BUSINESS INTELLIGENCE

1. TECHNOLOGY- the largest company today can create enterprisewide BI systems that compute and monitor metrics on virtually very variable important for managing the company.
2. PEOPLE- organizations can improve their decision making by having the right people making the decision.
3. CULTURE- a key responsibility of executives is to shape and manage corporate culture.