Sunday 27 September 2015


DATA WAREHOUSING

-Data warehouse
A logical collection of information gathered from many different operational databases that support business analysis activities and decision making tasks
the primary purpose of a data warehouse is to aggeregate information throughout an organizational into a single repository for decision making purposes

- ETL (extraction, transformation, loading)
Process that extracts information from internal and external database, transform the information using a common set of entreprise definitions, and loads the information into a data warehouse

-Data mart
contains a subset of data warehouse information

-Multidimensional analysis 
cube - common term for the representation of multidimensional information
-Data mining
data mining - the process af analyzing data ti extract information not offered by the raw data alone 

-Business intelligence (BI)
informatiom that people use to support their decision making efforts

-Principle BI
Technology
people
culture







No comments:

Post a Comment