Data Warehouse System to Support Condition Health Care of Elderly

Maeka Health Promotion Hospital conducts a survey on health conditions and collects the data involving activities or organization operations each year, particularly, the data on the elderly health care having too much. This might lead to difficulties in searching and analyzing the information. To solve this problem, it is essential to rely on tools and information technology in making a decision of the administrator rapidly and correctly as well as being the information for caring for and rehabilitating the elderly's health. The objectives of this study are to develop the data warehouse system and to create data visualization to depict the online report in the form of a dashboard. The research results indicate that the data warehouse system in supporting the elderly’s health care consists of four reports such as the report on the elderly’s score Activity of Daily Living (ADL), the statistical report on the elderly’s living, the reports on the elderly’s behavior, ailment and physical disabled and the statistical report on the elderly's health problem and the depression condition evaluation. Meanwhile, the user's satisfaction with the data warehouse system is at a good level ( = 4.21, S.D. = 0.08).