The University of Southampton
University of Southampton Institutional Repository

OLAP for health statistics: how to turn a simple spreadsheet into a powerful analytical tool

Artnik, Barbara, Vidmar, Gaj and Javornik, Jana, (2002) OLAP for health statistics: how to turn a simple spreadsheet into a powerful analytical tool Tkačik, Boris (ed.) In 12th Statistical Days - Proceedings. Statistical Society of the Republic of Slovenia., pp. 476-481.

Record type: Conference or Workshop Item (Paper)


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 sources 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. With proper data collection and/or transformations, informative comparisons within the study population and with international databases become readily accessible. The key advantage of OLAP over relational database management systems and ordinary tables is interactive browsing of multidimensional and hierarchical data, while OLAP can also aid data integrity checking and reporting.

Full text not available from this repository.

More information

Published date: 2002
Venue - Dates: 12th Conference on Integration of Statistics in the Information Society, 2002-01-01


Local EPrints ID: 42836
PURE UUID: 80d48935-7919-4e10-86b9-4e64f86ae2e6

Catalogue record

Date deposited: 15 Feb 2007
Last modified: 17 Jul 2017 15:20

Export record


Author: Barbara Artnik
Author: Gaj Vidmar
Author: Jana Javornik
Editor: Boris Tkačik

University divisions

Download statistics

Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.

View more statistics

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton:

ePrints Soton supports OAI 2.0 with a base URL of

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.