Chapter 8 Data Warehouse

Data warehouse.

 What is that ? Do you know about it ? maybe some of you think 'warehouse' that sells clothes right ? It's simple. Warehouse is place for storage of goods. So, automatically we can say it as place of storage of data. Get it ? Picture below shows you data warehouse 

It is a logical collection of information that gathered from many different operational databases that supports business activities & decision making start.

Data warehouse compiled information from internal or transactional/operational databases & external databases through extraction, transformation, and loading (ETL)
Data warehouse sends subsets of the information to data mart.
Information is multidimensional : contains layers of columns and rows
To present multidimensional information, a cube is used in common term.

Data mining is the process of analyzing data to extract information not offered by raw data alone and to  perform it, users need data mining tools such as query tools, reporting tools, statistical tools and intelligent agent. This tools use a variety of techniques to find patterns and relationship in large volume of information.

To  increase quality of organizational information and effectiveness, businesses must develop strategy to keep information clean. Information cleansing or scrubbing is process that weed out & fixes or discard inconsistent, incorrect or incomplete information.

In addition, business intelligence is information that people use to support their decision making efforts.
Principle BI enablers include technology, culture and people.