CHAPTER 8 - Accessing Organizational Information - Data Warehouse

History of Data Warehouse

• in the 1990s as organizations began to need more timely information about their business, they found that traditional operational information systems were too cumbersome to provide relevant data efficiently and quickly. 
• operational systems typically include accounting, order entry, customer service, and sales and are not appropriate for business analysis.

Data Warehouse Fundamentals

• data warehouse is a logical collection of information - gathered from many different operational database - that support business analysis activities and decisions making task
• the primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository in such way that employees can make decisions and undertake business analysis activities.
• extraction, transformation, and loading (ETL), which is a process that extract information from internal and external databases, transform the information using common sets of enterprise definitions, and loads the information into data marts
• data marts contains a subset of data warehouse information, it is to distinguish between data warehouse and data marts, think of data warehouse as having more organizational focus and data marts as having focused information subsets particular to the needs of a given business unit such as finance or production and operations.

                           

Multidimensional analysis and data mining

• A dimension is a particular attribute of information .
• a cube is the common term for the representation of the multidimensional informational.
• data mining is the process of analyzing data to extract information not offered by the raw data alone.
• data mining tool use a variety of techniques to find pattern and relationships in large volumes of information and infer rules from them 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
• Contact information in an operational system

Standardizing Customer name from Operational Systems



Accurate and complete information


Information cleansing activities

Bu business intelligence

•Business intelligence – information that people use to support their decision-making efforts

•

•Principle BI enablers include:

–Technology

–People

–Culture