Development of business intelligence system to support the monitoring and financial assessment of Faculty of Medicine Ramathibodi Hospital, Mahidol University

Abstract

             This research aims to use financial and accounting data to generate reports in business intelligence system to enhance the efficiency of financial analysis and planning and to know the opinions of the data users for financial monitoring and assessment of such reports. As for the research methods, there have been studied in the preparation of current reports to analyze the gap between the report based on the needs of the data users and the report according to the principle of financial statement analysis compared with currently available reports. Then the system was designed and tested and assess the user's feedback on the reports that have been generated. The data were collected from “the Fiscal Performance Monitoring and Assessment Committee” in the number of 14 persons. Data were analyzed by using mean and standard deviation.

             The findings showed that more reports in the smart business system need to be developed for 11 Reports. The result of the committee's assessment of the opinions was "very agreeable" that the report developed had an easy and fast process to use. The report format contained important information that was complete, beautiful, and accurate according to the principles of financial statement analysis.  It could be used in planning of work management and could set goals at both the overall and mission levels. It could also be used to monitor the performance to meet the target values and could be used to lay out ways to improve the performance of the work operation.