CIS 2200 CHAPTER 8 QUESTIONS AND ANSWERS|GUARANTEED SUCCESS

Operational systmes typically include accounting, order entry, customer service, and sales and are not appropriate for business analysis for the following reasons: 1) information from other operational applications is not included 2) operational systems are not integrated, or not available in one place 3) operational information is mainly current- does not include the history that is required to make good decisions 4) operational information frequently has quality issues (errors)- the information needs to be cleansed 5) without information history, it is difficult to tell how and why things change over time 6) operational systems are not designed for analysis and decision support Data Warehouse ** a logical collection of information- gathered from many different operational databases- that supports business analysis activities and decision-making tasks EX: Blackboard Extraction, Transformation, and Loading (ETL) ** 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 Data Mart ** contains a subset of data warehouse information Multidimensional Databases ** Information is multidimensional where there are layers of columns and rows Cube ** the common term for the representation of multi-dimensional information Data Mining ** the process of analyzing data to extract information not offered by the raw data alone Data-Mining Tools use a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them to predict future behavior and guide decision making Information Cleansing or Scrubbing ** a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information Data Visualization describes technologies that allow users to "see" or visualize data to transform information into a business perspective Data Visualization Tools move beyond excel graphs and charts into sophisticated analysis techniques like pie, charts, controls, instruments, maps, time-series graphs, and more can help uncover correlations and trends in data that would otherwise fo unrecognized Business Intelligence Dashboards track corporate metrics like critical success factors and key performance indicators and include advanced capabilities like interactive