t0day i want t0 write about chapter 8. it is Accessing Organizational Information - Data Warehouse.
In this chapter i learn about the roles, purposes, the relationship between business intelligence and a data warehouse and etc. ok i will write what i understands in this chapter. :)
Data Warehouse Fundamentals :
- Data warehouse - a logical collection of information -gathered from many different operational databases -that supports business analysis activities and decision-making tasks.
- primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository decision-making purposes.
- Extraction, transformation, and loading (ETL) - a process that extracts information from internal and external databases, transform the information using a common set of interprise definitions, and loads the information into a data warehouse.
- Data mart - contains a subset of data warehouse information.
Multidimensional Analysis and Data Mining :
- 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.
- 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 :
- is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
Business Intelligence :
- information that people use to support their decision-making efforts.
- principle BI enablers includes - technology, people and culture.
ok that all fr0m me t0day.. bye u all.
g0od nite. . . :)
No comments:
Post a Comment