Term
|
Definition
| A logical collection of information- gathered from many different operational databases-that supports business analysis activities and decision-making tasks |
|
|
Term
| Transactional Information |
|
Definition
| encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks. Examples: withdrawing cash from an ATM, making an airline reservation, purchasing stocks |
|
|
Term
|
Definition
| encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks. Examples: trends, sales, product statistics, and future growth projections |
|
|
Term
| Operational (regular) database |
|
Definition
| a collection of transactional information |
|
|
Term
| Extraction, transformation, and loading (ETL) |
|
Definition
| 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 |
|
|
Term
|
Definition
| contains a subset of data warehouse information |
|
|
Term
|
Definition
| Extracted from data warehouses |
|
|
Term
|
Definition
| stand alone mini data warehouses |
|
|
Term
| Information cleansing and scrubbing |
|
Definition
| a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information. Part of the ETL process |
|
|
Term
|
Definition
| the process of analyzing data to extract information not offered by the raw data alone |
|
|
Term
|
Definition
| Use a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making |
|
|
Term
| Transaction Processing System |
|
Definition
| the basic business database systme that serves the operational (day-to-day operations) level in an organization |
|
|
Term
| Online transaction processing (OLTP) |
|
Definition
| The general activity of updating (i.e. inserting,modifying, and deleting), queryine (i.e. retrieving), and presenting text and number data from databases for operational purposes |
|
|
Term
| Online analytical processing (OLAP) |
|
Definition
| The general activity of querying (i.e. retrieving) and presenting text and number data from data warehouses (and data marts) for analytical purposes |
|
|
Term
| Decision support systems (DSS) |
|
Definition
| Model information to support managersand business professionals during the decision-making process. Include On-Line analytical processing (OLAP) Tools. Excel can be a DSS |
|
|
Term
| Executive information systems (EIS) |
|
Definition
| A system containin enterprise-wide information presented via simple and easy to use interfaces for quick insight and analysis by executives. Can be OLAP-tool based. E.g. digitl dashboards |
|
|
Term
|
Definition
| The study of the impact that changes in one (or more) parts of the model have on other parts of the model (SOLVER) |
|
|
Term
|
Definition
| Checks te impac of a chnge in an assumption on the proposed solution (IF FUNCTON, SCENARIO MANAGER) |
|
|
Term
|
Definition
| finds the inputs necessary to acheve goal such as a desired level of output (GOAL SEEK) |
|
|
Term
|
Definition
| The ability to view all areas up and down the supply chain. Not possible without IT. |
|
|
Term
|
Definition
| Occurs when ditorted demand information passes from one entity to the next throughout the supply chain (can result in excessive or insufficient inventory) |
|
|
Term
|
Definition
| Companies can respond to demanding and changing customers through supply chain enhancements enabled by IT (e.g. demand planning software using statistical and forecasting techniques) |
|
|
Term
|
Definition
| Increased competition and adoption of IT advances in supply chain management, makes any organization that is ignoring its supply chain modernization at risk of becoming obsolete |
|
|
