ACIS 1504 Study Guide - Midterm Guide: Dollar Sign, Lookup Table, Online Analytical Processing

• School: Virginia Tech
• Department: Accounting and Information Systems
• Course: ACIS 1504
• Professor: Jean Lacoste

Document Summary

Big data: data sets too large to process with traditional database technology. Data mining: software that searches through data and uses complex statistical calculations. Data analytics: supports fact-based decision making in data-rich environments. Business intelligence: software that searches vast amounts of data to derive information for improved decision making. Olap & data visualization: on-line analytical processing including drill-down, consolidation, and slicing and dicing. Vertical copy will get the row numbers changed. Horizontal copy will get the column letters changed. This is the default in excel: mixed cell reference have a dollar sign in front of either the row or the column name. Only the character that is not preceded by a dollar sign may change when the calculation is copied. Spreadsheet implementation: knowing which features are available in excel, and which icons and buttons to select to invoke those features. Spreadsheet design: refers to those decisions you make prior to implementation.