Application of Business Intelligence in studies management of Hazard, Vulnerability and Risk in Cuba

Abstract

In Cuba, the state invests considerable resources in the establishment of preparation plans to mitigate and to minimize the negative impacts of natural threats. As a sample of it, since the year 2010, the country carried out the studies of hazard, vulnerability, and risk (HVR), however, the form in that results of these studies are analyzed present serious limitations for the excessive quantity of data that are dispersed and not very understandable for users belonging to the Centers of Risks' Management make decisions in an agile way. The present work, exposes the management’s pattern of the studies of Hazard, Vulnerability and Risk in Cuba alongside the occurrence of hydrometeorological extreme events in vulnerable territories; and the structuring process of the computer proposal that modifies and computerizes the current analysis procedure of these studies in the country. As contributions of the research and by means of the use of techniques and tools of Business Intelligence, is designed and implemented, for the case of Santiago de Cuba province, the data warehouse that centralizes the results of the studies for hydrometeorological extreme events in 2011 and 2016. A decision support system (DSS-HVR) is built, and integrated at the developed data warehouse in this work, it allows the analysis of the studies in a holistic manner and from several perspectives, to obtain outstanding and better-represented information through interactive and dynamic reports, both tabulate and graph representation, all as a support for a fast and effective decision making.