CHAPTER 8: ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

Data Warehouse Fundamentals :

•   Data warehouse - a logical collection of information -gathered from many different operational databases -that supports business analysis activities and decision-making tasks.
• primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository decision-making purposes.
• Extraction, transformation, and loading (ETL) - a process that extracts information from internal and external databases, transform the information using a common set of interprise definitions, and loads the information into a data warehouse.
• Data mart - contains a subset of data warehouse information.

Multidimensional Analysis and Data Mining : 

• cube - common term for the representation of multidimensional information.

• data mining - the process of analyzing data to extract information not offered by the raw data alone.
•  data-mining tool - uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making.

Information Cleansing or Scrubbing : 

• is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Business Intelligence : 

• information that people use to support their decision-making efforts.
• principle BI enablers includes - technology, people and culture.