THE EIGHTH CHAPTER

        So on this eight chapter we learn about ACCESSING ORGANIZATIONAL INFORMATION (DATA WAREHOUSE). So what it is data warehouse ? You want to know more about this ? ok read this !

Data warehouse 

• A logical collection of information of information
• Gathered from many different operational databases
• That supports business analysis activities and decision making tasks

Purpose of data warehouse is to aggregate information throughout an organization into a single repository for decision making purposes.

Extraction, transformation and loading (ETL) – A 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 mining

Databases contain information in a series of two dimensional tables.
In a data warehouse and data mart, information is multidimensional  it contains layers of columns and rows
• Dimension – a particular attributes of information.

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. To perform data mining users need data- mining tools.

Information cleansing or scrubbing

A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
Information cleansing activities :
• Missing records or attributes
• Redundant records
• Missing keys or other required data
• Erroneous relationships or references
• Inaccurate data

Business intelligence

Information that people use to support their decision making efforts.

Principle business intelligence include :
• Technology
• People
• Culture