- 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 aggregate information throughout an organization into a single repository for decision-making purposes.
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 mart- contains a subset of data warehouse information.
Multidimensional Analysis and Data Mining
Data mining- the process of analyzing data to extract information not offered by the raw data alone
Data mining tool- uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making.
Information Cleansing or Scrubbing
- A process that weeds out and fixes or discards inconsistent, incorrect or incomplete information
Information cleansing cleans:
- Missing records or attributes
- Redundant records
- Missing keys or other required data
- Erroneous relationship or references
- Inaccurate data
Business Intelligence
- Information that people use to support their decision-making efforts
Principle of Business Intelligence:
- Technology
- People
- Culture
0 Komentar