An application of a healthcare data warehouse system

This paper describes the establishment ofthe proof of concept (POC) data warehouse platform for the healthcare system which encompassed the system design, ETL data processing, and On-Line Analytical Process (OLAP) analysis. The healthcare data warehouse system implemented is developed in both client-server platform as well as web-based platform. In each platform, we provide both the OLAP and reports in interactive graphical layout and deployed in the cloud environment. In the data cleansing process, a cleansing methodology has been proposed and implements to ensure a consistent and correct loading of data into data warehouse.