CHAPTER 8 : ACEESSING ORGANIZATIONAL INFORMATION-DATA WAREHOUSE
History of Data Warehouse
- Data warehouses extend the
transformation of data into information
- In the 1990’s executives
became less concerned with the day-to-day business operation
and more
concerned with overall business functions
- The data warehouse
provided the ability to support decision making without disrupting the
day-to-day operations
Data Warehouse Fundamentals
- Data warehouse - a logical collection of information –
gathered from many different
operational databases – that supports business
analysis activities and decision-making task
-The primary purpose of a data warehouse is to aggregate information throughout an
organization into a single repository for
decision-making purposes
- Extraction,tranformation,and loading - a
process that extracts information from internal
and external databases,
transforms the information using a common set of enterprise
definitions, and
loads the information into a data warehouse
-Data mart – contains a subset of data warehouse
information
Data Warehouse Fundamantels
Multidimensional Analysis and Data Mining
- Databases contain information in a series of
two-dimensional tables
-In a data warehouse and data mart,
information is multidimensional, it contains layers of
columns and rows
a) Dimension – a particular attribute of information
- Cube - common term for the representation of mutidimensional information
Information Cleansing or Scrubbing
- An organization must 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
- Contact information in an operational system
Business Intelligence
- Business intelligence – information that people use to support
their decision-making
efforts
- Principle BI enablers include:
–Technology
–People
–Culture
No comments:
Post a Comment