Getting data out of the electronic patient record: critical steps in building a data warehouse for decision support

Health care has taken advantage of computers to streamline many clinical and administrative processes. However, the potential of health care information technology as a source of data for clinical and administrative decision support has not been fully explored. This paper describes the process of developing on-line analytical processing (OLAP) capacity from data generated in an on-line transaction processing (OLTP) system (the electronic patient record). We discuss the steps used to evaluate the EPR system, retrieve the data, and create an analytical data warehouse accessible for analysis. We also summarize studies based on the data (lab re-engineering, practice variation in diagnostic decision-making and evaluation of a clinical alert). Besides producing a useful data warehouse, the process also increased understanding of organizational and cost considerations in purchasing OLAP tools. We discuss the limitations of our approach and ways in which these limitations can be addressed.