chapter eight : DATA WAREHOUSE

hey there! its been a long time since my last post here. today i would post about the DATA WAREHOUSE. enjoy :)

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.