a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasksThe primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
ETL Extraction, transformation, and loading-
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.
Multidimensional Analysis and Data Mining-
the process of analyzing data to extract information not offered by the raw data alone.
process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
information that people use to support their decision-making efforts.
Analyze, decide quickly, make decisions, protect corporate asset.
a simplified representation or abstraction of reality
Transaction processing system (TPS) -
the basic business system that serves the operational level (analysts) in an organization. DSS (Decision Support System)
Executive information system (EIS)
a specialized DSS that supports senior level executives within the organization
Online analytical processing (OLAP) –
the manipulation of information to create business intelligence in support of strategic decision making.
Online transaction processing (OLTP) –
the capturing of transaction and event information using technology to (1) process the information according to defined business rules, (2) store the information, (3) update existing information to reflect the new information
AI (Artificial Intelligence) – what is it-
the ability to build a system that can mimic human intelligence
Four Categories of AI systems – know what each can be defined as