Author/Editor     Artnik, Barbara; Vidmar, Gaj; Javornik, Jana
Title     OLAP for health statistics: how to turn a simple spreadsheet into a powerful analytic tool
Translated title     OLAP v zdravstveni statistiki: kako spremeniti preglednico v zmogljivo analitično orodje
Type     članek
Source     In: Tkačik B, editor. Vključevanje in povezovanje statistike v informacijsko družbo. Zbornik 12. statistični dnevi; 2002 nov 25-27; Radenci. Ljubljana: Statistični urad Republike Slovenije,
Publication year     2002
Volume     str. 476-81
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 easily applicable and useful OLAP can be in the public sector. To achieve that, we used data compiled from different ources for the purpose of exploring the relations between causes of death (according to ICD-10) and socio-economic characteristics (educational level, marital status, profession, etc.) for selected years 1992,1995 and 1998 in Slovenia. Using a standard personal computer and the Windows platform, the application was implemented in Microsoft Excel 2000, without any programming. After data cleansing (elimination of incorrect entries, duplicates and inconsistencies based on exploratory statistical methods), the case-based spreadsheet data was instantly converted into an OLAP application 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 Microsoft Internet Explorer and Microsoft Office 2000 installed, all the drill-in, drill-out and dimension-swapping capabilities are accessible within the browser, while the data source remains fully protected. Privacy constraints are respected since all the information is only provided at the aggregate level. Even though our dataset provides exhaustive coverage of mortality at the national level, storage and processing capabilities did not prove to be an issue. Hence, we argue that OLAP methodology should find a place in health statistics. (Abstract truncated at 2000 characters)
Descriptors     MORTALITY
CAUSE OF DEATH
SOCIOECONOMIC FACTORS
COMPUTER GRAPHICS
MICROCOMPUTERS