Data Warehouse and BI to catalize information use in health sector for decision making: a case study

Health sector in most countries including Zanzibar lacks the single repository that integrates health management data produced by multitude of sources. The study proves cost effective but successful implementation of Data Warehouse (DW) plays useful role to influence informed decision making in the health sector. Successful DW needs to include necessary features such as Online Analytic Process (OLAP) which gives decision makers the freedom to analyses information into different format business intelligence (BI) tools, data mining and data presentation tools. In this study, we attempted to identify DW needs to consider culture of organization and what organization actual wants for decision making. The study proposed the cost effective DW and BI tools solution to catalyze informed decision making in health care industry. The study also aims to discuss challenges and sets out recommendations