Database Warehouse Fundamental
A data warehouse is a logical collection of information which is gathered from many different operational databases that supports business analysis activities and decision making tests.
The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository in such way that employees can make decisions and undertake business analysis activities.
The data warehouse model complies information from internal databases, transactional databases and external databases through extraction, transformation and loading (ETL), which is a process that extract information from external and internal databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.
The data warehouse then sends subsets of the information to data marts. A data mart contains a subset of data warehouse information.
•Cube – common term for the representation of
multidimensional information
•Data
mining – the process of analyzing data to extract
information not offered by the raw data alone
INFORMATION CLEANSING OR SCRUBBING
- to increase the quality of organizational information and thus the effectiveness of decision making, business must formulate a strategy to keep information clean.
- Information cleansing and scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect or incomplete information.
- specialized software tools use sophisticated algorithms to parse, standardize, correct, match, and consolidate data warehouse information.
The relationship between business intelligence and a data warehouse
• Business intelligence – information that people use to support their decision-making efforts
• Principle BI enablers include:
– Technology
– People
– Culture
0 comments:
Post a Comment