Please enable JavaScript.
Coggle requires JavaScript to display documents.
Accessing organizational information - Data ware house, image - Coggle…
Accessing organizational information - Data ware house
a logical collection of information
gathered from many different operational information
aggregate information throughout an organization into a single repository for decision making purposes
extraction, transformation and loading
Data mart - contain a subset of data warehouse information
Multidimensional Analysis and data mining
Databases contain information in a series of two-dimensional tables
Dimension - a particular attribute of 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 and scrubbing
An organization must maintain high-quality data in the data warehouse
A process that weeds out and fixes or discards inconsistent, incorrect or incomplete information
Information cleansing activities
1.missing records or attributes
2.Redundant records
3.Missing key or other required data
4.Erroneous relationships or references
5.inaccurate date
Business intelligence
Information that people use to support their decision -making efforts
Principle BI includes
Technology - enabler of BI
People - right people improve decision
Culture - manage corporate culture