CHAPTER 8 : ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

History of Data Warehousing

• Data warehouses extend the transformation of data into information
• The data warehouse provided the ability to support decision making without disrupting the day-to-day operations.

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
• have many information
• have information from various databases

• The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision - making purposes
• all of information have in data - warehouse

• 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 (take the information from internal and external, take the information of company need only, and put the information into the data)

• Data mart
• contains a subset of data warehouse information (less of information, only related to financial)
• example : for mini mart, not all of things they have but for D'mart, big and all things they have

put the important of information --> transform the information, what the company need --> put it to data mart

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
• 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.
• To perform data mining users need data-mining tools
• 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

• An organization must maintain high-quality data in the data warehouse
• accurate
• complete
• uniqueness
• Information cleansing or scrubbing - a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
• Contact information in an operational system

Business Intelligence

• information that people use to support their decision-making efforts
• principle BI enablers include:
• technology
• people
• culture