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
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