OLAP/EIS Tops Off the Data Warehouse
- Published:
- Briefs, Case Studies, Papers, Reports
- Author(s) and Contributors:
-
Author(s): Henry Stewart
- Source(s) and Collection(s):
-
Presentation(s): CAUSE Conferences (Archives)
- ParentTopics:
Abstract
On-Line Analytical Processing (OLAP) has emerged as a "break through" technology that can provide the foundation for fast, easy, affordable EIS solutions. OLAP technologies, when integrated with a data warehouse, can aggregate vast amounts of legacy data in both graphic and tabular formats. OLAP technologies feature very fast response, drag-and-drop navigation, point-and-click drill-down/drill-up among levels of detail, and value-based color highlighting for "exception reporting." Using OLAP/EIS solutions, senior managers are able to interactively "browse" hundreds of displays that present a visualization of their institution's business process.This paper presents a quick overview of the University of Rochester's approach to data administration including the development of a multi-gigabyte data warehouse, along with distinctions between data querying, reporting, and analysis. OLAP will be featured as the newest form of these information services.