- Data warehouse – A logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
- The primary purpose of a data warehouse is to combined information throughout an organization into a single repository for decision-making purposes – data warehouse support only analytical processing.
- Extraction, transformation and loading (ETL) – 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 warehouse then send subsets of the information to data mart.
- Data mart – contains a subset of data warehouse information.
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
- Data mining - the process of analyzing data to extract information not offered by the raw data alone
- To perform data mining users need data-mining tools
information and infers rules that predict future behavior and guide decision making
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
Business Intelligence
- Business intelligence - information that people use to support their decision-making efforts
- Principle BI enablers include:
- People
- Culture
No comments:
Post a Comment