An Agile Dimensional Data Mart Architecture for Clinical Laboratory Towards the Development of an Evolving Enterprise Clinical Data Warehouse

Abstract

Data science and business intelligence streams are getting increasingly popular in current era and the reason behind this trend is the hidden potential of processed data. Data warehousing solutions, whether it is on premise or cloud based, are getting more and more popular, as it is creating the foundation for a crucial business intelligence solution. Organizations who are exploring the power of data, are well equipped with the business challenges moving forward. Even though the terms Data Warehousing and Business Intelligence are pretty common and widely used, unlike other industries healthcare is bit slow in reaping and adopting the power of the data, even though the data volume in healthcare is higher than any other industries. In this paper, authors are trying to develop a dimensional data model for one of the widely used healthcare data segment, which is the laboratory services. This is an effort towards the development of agile Enterprise Data Warehouse for healthcare. The base of this research is Kimball’s agile development methodologies and a phased approach is utilized in the study. © 2020, World Academy of Research in Science and Engineering. All rights reserved.