cHaPtEr 8

aSsAlAmUaLaIkUm

ESSING ORGANIZATIONAL INFORMATION-DATA WAREHOUSE

ACC

1.     Describe the roles purpose of data warehouse and date marts in an organization

Data warehouse is a logical collection of information gathered from many different operational databases that support business analysis and decision-making tasks.

Data marts-contains a subset of date warehouse information

2.     Compare the multidimensional nature of data warehouse with the two-dimensional nature of databases

Data base contain information in a series of two dimensional tables which means that you can only ever view two dimensional of information at one time.In a database warehouse and data marts information is multidimensional it contains layers of columns and rows.Each layer in a data warehouse or data marts represents information according to an additional dimension.Dimensions could such things as products,promotion,stores,category,region.stock price,date,time and even the weather.The ability to look information from different dimensions can add tremendous business insight.

3.     Identify the importance of ensuring the cleanliness of information throughout an organization

Maintain high quality data in the data warehouse.a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information,contact information in an operational system,standardizing customer name from operational system,information cleansing activities and accurate and complete information quality management.

4.     Explain the relationship between business intelligence and data warehouse

Business intelligence is the information that people use to support their decision-making efforts.

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