Author/Editor | Vidmar, Gaj; Hudomalj, Emil | |
Title | Decision suport for everyone: OLAP in MS Excel | |
Type | članek | |
Source | In: Bohanec M, Gams M, Grobelnik M, et al, editors. Informacijska družba IS'2002: Inteligentni sistemi, Izkopavanje znanja in podatkovna skladišča; 2002 okt 14-18; Ljubljana. Ljubljana: Inštitut Jožef Stefan, | |
Publication year | 2002 | |
Volume | str. 147-50 | |
Language | eng | |
Abstract | Over the last ten years, Online Analytical Processing (OLAP) has become a very popular tool for interactive analysis of multidimensional information. Providing online operation and flexible summarising, tabulating and charting options, it has become an essential part of the decision support process in corporate setting. Our aim is to demonstrate how easy and effective it is to implement basic OLAP without any expert knowledge or high-priced software, using just the most common spreadsheet program. On a standard personal computer with MS Windows platform, we implemented a demonstrational application with public health data in MS Excel 2000, without any programming. After data cleansing the flat-file worksheet is instantly converted into an OLAP apptication with the user-friendly pivot table technology. A bonus of this approach is that the results can be made directly accessible over the WWW by publishing the workbook to a web server. Provided that the user has MS Internet Explorer and MS Office 2000 installed, all the drill-in, drill-out and dimensionswapping capabilities are accessible within the browser, while the data source remains fully protected. If the application is properly designed, privacy constraints are respected since all the information is only provided at the aggregate level. Contrary to widespread belief, storage and processing capabilities are not a serious issue with this approach with up to tens of thousands of records. | |
Descriptors | DECISION MAKING, COMPUTER-ASSISTED COMPUTER COMMUNICATION NETWORKS CAUSE OF DEATH SOCIOECONOMIC FACTORS DATABASES, FACTUAL |