Viewing and Protection Organizational Information

history of data warehousing

• data ware house extend the transformation of data into information
• in the 1990's executives became less concerned with the day-to-day business operations and more concerned with overall business functions
• the data warehouse provided the ability to support decision marking without disrupting the day- to-day operations

data warehouse fundamentals

• data warehouse - a logical collection of information, gathered from different operational database that support business analysis activities and decision making task
• the primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision making purpose
• extraction, transformation, and loading (ETL) - a process that extracts information from internal and external databases, transform 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 minig

• databases contain information in a series of two-dimensioanl tables
• in a data warehouse and data mart, information is multidimensional, it contais 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 to dat 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
• information cleansing or scrubbing - a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information

business intelligence

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