CHAPTER 8 : DATA WAREHOUSE

Data Warehouse Fundamentals

- a logical collection of info from many different types of operation database.

ETL ( Extarction , Transformation , Loading )

- a process that extracts info from internal and external database,transform the info using a common set of enterprise and loads the info into a data warehouse

Data Mining – the process of analyzing data to extract info not offered by the raw data alone.

Data Mining Tools – uses a variety of techniques to find pattern and relationships in large volumes of info.

Information cleansing or scrubbing – a process that weeds out and fixes or discards inconsistent or incomplete info.

Business Intelligence

- information that people use to support their decision making efforts.

Principle BI enablers include :

- technology

- people

- culture