Sunday 9 March 2014

CHAPTER 8

Chapter 8 : Accessing Organizational Information - Data Warehouse

Assalamualaikum guys. today we will learn about this chapter. let read :)

Data Warehouse – logical collection of information gathered from many different operational databases that supports business analysis activities and decision making activities

Extraction, transformation and loading – a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.



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



Information cleansing or scrubbing – a process that weeds out and fixes or discards inconsistent, incorrect and incomplete information
-          Contact information in an operational system
-          Standardizing customer name from operational system 
-          Information cleansing activities


-          Accurate and complete information

No comments:

Post a Comment