Development of Decision Support System in Impact and Severity from Flood in Phuket

  • เอสเธอร์ เสงี่ยมกุล College of Computing, Prince of Songkla University, Phuket Campus
  • ธนาภรณ์ ปานรังศรี College of Computing, Prince of Songkla University, Phuket Campus
Keywords: Decision support system, Business intelligence, Flood, Disaster management, Data warehouse


The purpose of research is the development of decision support system in the impact and the severity of floods. Data management in agencies involved in disaster management collected the different structured data and various technologies. Therefore, they occur the problems and delays in data analysis
and decision making. This research presents the disaster data management using Business Intelligence (BI). The researcher collected requirements (Infrastructure data and indicators). Requirements were collected and classified for Information architecture design. The result of Information architecture
can be made to Schema design. In the case study, which focuses on the severity of risk areas of the floods. Data were collected from Department of Disaster Prevention and Mitigation, Phuket (DDPM Phuket) and Phuket land use data from GDEN, PSU Phuket campus. Data can be extracted, transform, and load into Data warehouse using ETL process and online analytical processing (OLAP) method. The result of the analysis is presented as reports on the dashboard.
The dashboard and data warehouse are evaluated by 15 domain experts. This BI system can be utilized. The mean score was 4.53 (S.D. = 0.62). The system can facilitate decision making. The mean score was 4.07 (S.D. = 0.77). The system can be used to plan, track and analyze flood data in Phuket.


Download data is not yet available.