Monday 16 March 2015

Accessing Organizational Information - Data Warehouse ( Chapter 8 )

DATA WAREHOUSE FUNDAMENTALS





A data warehouse is a logical collection of information - gathered from many different operational databases - that supports business analysis activities and decision making task.




Model Of Typical Data Warehouse


The figure above shows the compiles information from internal databases or transactional / operational databases and external databases through extraction, transformation, and loading (ETL), which is a process that extracts information from internal and external databased information using a common set of enterprise definitions, and load the information into a data warehouse.





MULTIDIMENSONAL ANALYSIS AND DATA MINING


A cube is common term for the representation of multi dimensional information.




A Cube Of Information For Performing a Multidimensional Analysis On Three Different Stores, For Five Different Products And Four Different Promotions


Data Mining is the process of analyzing data to extract information not offered by the raw data alone.



BUSINESS INTELLIGENCE

Business Intelligent (BI) refers to application and technologies that are used to gather, provide access to and analyze data and information to support decision making efforts.

  • Collecting information
  • Discerning patterns and meaning in the information
  • Responding to the resultant information.


ENABLING BUSINESS INTELLIGENCE


Competitive organization accumulate business intelligent to gain sustainable competitive advantage, and they may regard such intelligent as a valuable core competence in some instances.

  • Technology
  • People
  • Culture







No comments:

Post a Comment