CHAPTER 8 : ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

Data warehouse fundamentals

-Data warehouse - a logical collection of information-gathered from many different operational database- that supports business analysis activities and decision-making tasks.

-Primary purpose - to aggregate information throughout an organization into a single repository in such way that employees can make decisions and undertake business analysis activities.

-Extraction, transformation and loading (ETL) - a process that extracts information from internal and external database, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.

-Data warehouse- then send subsets of the information to data mart.

-Data mart - contain the subsets of data warehouse information.

MULTIDIMENSIONAL ANALYSIS AND DATA MINING
cube- the common term for the representation of multi dimensional databases.

data mining - process of analyzing data to extract information not offered by the raw data alone.
data-mining tools - variety of techniques to find patterns and relationship in large volumes of information and infer rules from them that predict future behaviour decision making.

INFORMATION CLEANSING AND SCRUBBING

                                                -contact information in operational system

                                           -standardizing customer name from operational systems

                                                         -information cleansing activities

                                                       -accurate and complete information


BUSINESS INTELLIGENCE

-application and technologies that are used to gather, provide access to and analyze data and information to support decision-making efforts.specifically :-

• collecting information.
• discerning patterns and meaning in the information.
• responding to the resultant information.