CHAPTER8

Accessing Organizational Information- Data Warehouse

Describe the roles and purposes of data warehouse and data marts in an organization.

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 aggregate information throughout an organization into a single repository for decision making purpose.

Data marts- contains a subset  of data warehouse information.

Compare the multidimensional nature of data warehouse (and data marts) with the two- dimensional nature of databases.

Databases contain information in a series of two dimensional tables.It contains layers of columns and rows.

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

The maintain high-quality data in the data warehouse.INFORMATION CLEANSING OR SCRUBBING a process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information like contact information in an operational system,standardizing customer name from operational systems,information cleansing activities and accurate and complete information.

Explain the relationship between business intelligence and a data warehouse

Refers to applications and technologies that are use to gather ,provide access to,and analyze data and information to support decision making effort. Principles BI enablers include technology,people,culture.