INMT 342 Final: IM 342 Final Exam Review from book and powerpoints
Document Summary
Data warehouse is a subject-oriented, integrated, time-variant, non-updatable collection of data used in support of management decision-making processes. Goal: to increase the value of the organization"s data asset. Purpose: consolidate and integrate data from a variety of sources and to format data to be able to make decisions. Business require an integrated, companywide view of high quality information. Separation of operational and information systems (improved performance: operational system: aka systems of record are used to run business in real time. Informational systems: designed to support managerial decision making based on historical data. New info about customer habits, new products, which product sells, etc. 40% failure rate and cost of 20 million dollars. Focuses on a particular problem (project oriented) Enterprise wide (top down): comprehensive warehouse is built initially. Level one: operational data are stored in various systems of record throughout the organization. Level two: reconciled data are the type of data stored in the enterprise data warehouse.
