Chapter 8: Accessing Organizational Information – Data Warehouse

“Even a rock moves on.”

Anthony Liccione

so what are we waiting for ? lets move forward to our next chapter which is

CHAPTER

Accessing Organizational Information  – Data Warehouse

1. Data Warehouse Fundamentals:
   - data warehouse :
   
   * a logical collection of information * gathered from many different operational databases* supports business analysis activities and decision-making tasks * The primary purpose of a 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
        * loads the information into a data warehouse

         - data mart :
        * contains a subset of data warehouse information

 example of ETL :



 2. Multidimensional Analysis and Data Mining:

      - Cube :
   
     * common term for the representation of multidimensional information

     - data mining : 

       * process of analyzing data to extract information not offered by the raw data alone

    - data mining tools :

       * a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making

3.  Information Cleansing or Scrubbing :

      - process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information

4.  Business Intelligence :

     - applications and technologies that are used to gather, provide access to, and analyze data and information to support decision-making efforts

-   Principle BI enablers include

    * Technology
    * People    * Culture



example of business intelligence : 

감사합니다
σας ευχαριστώ

gratias tibi,

ขอขอบคุณคุณ

thank you

terima kasih