Chapter 8

                DATA.......................WAREHOUSE

Data warehouse is a logical collection of information

- gathered from many different operational database

- support business analysis activities and decision making tasks.

Before the data are loading into the data warehouse, the data first will be extracted from internal and external database and then transform the info using a common set of enterprise definitions. This process is called......

ETL - Extraction, transformation and loading

Different with databases (contain information in a series of two- dimensional tables), data warehouse and data mining have information that is multidimensional (contain layers of column and rows)

There are also a process called Information cleansing or scrubbing. This process weeds out and fix or delete inconsistent, incorrect, or incomplete info. It is to maintain high-quality data in the data warehouse.

Biz intelligence - info that people use to support in decision making. There are 3 principle BI enablers which is technology, people and culture......