Chapter 9 Keyword List:

Data Warehouse: A central repository of information. Holds multiple subject areas. Holds very detailed information. Works to integrate all data sources.

Data Mart: Often holds only one subject area- for example, Finance, or Sales. May hold more summarized data (although many hold full detail). Concentrates on integrating information from a given subject area or set of source systems.

Difference between a data mart and data warehouse

An OLAP cube is a multi-dimensional array of data. Online analytical processing (OLAP) is a computer-based technique of analyzing data to look for insights.

Pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). Often used for OLAP types of analysis. Microsoft Pivot Table

Optimization: the “best use” of limited resources available. The solver add-in for Excel uses linear programming to solve this type of problem.

Regression for Prediction and Forecasting a statistical method that allows you to examine the relationship between two or more variables of interest.

Simulation an approximate imitation of the operation of a process or system, allowing for what-if analysis.

Decision Support System (DSS), an information system that supports business or organizational decision-making activities.

Geographic Information System (GIS), a computer system for capturing, storing, checking, and displaying data related to positions on Earth's surface.

Data Mining, the process of finding anomalies, patterns and correlations within large data sets to predict outcomes. (general questions on tutorial in the link)

Correlation: a statistical technique that can show whether and how strongly pairs of variables are related.

Cluster Analysis: tries to identify homogenous groups of cases if the grouping is not previously known

Market Basket Analysis: What items do customers buy together?

Expert System (ES): a computer system that emulates the decision-making ability of a human expert. It makes a decision, often based on If-Then statements.

Decision Tree uses a tree-like model of decisions and their possible consequences, including chance event outcomes, resource costs, and utility. Can be used to graph an expert system or as a decision support tool.

Artificial Intelligence (AI) makes it possible for machines to learn from experience, adjust to new inputs and perform human-like tasks. Machine Learning - Snowflake

Neural Network: are computing systems that are inspired by, but not identical to, biological neural networks that constitute animal brains, often designed for pattern recognition.

Software Agent "a software program that can perform specific tasks for a user and possessing a degree of intelligence that permits it to performs parts of its tasks autonomously and to interact with its environment in a useful manner.”

From Intelligent Software Agents - Brenner, Zarnekow and Wittig.

Other information not for quiz or exam