2012 Volume 13 Issue 2 Pages 75-80
An analysis was conducted using a new in-memory BI data analysis software program so that the present situation can be understood and efficiently managed regarding the analysis of electronic medical record surgical systems, even for amateurs who are not software engineers (SE).
The number of surgeries from approximately 10,005 DWH (Data warehouse) cases, hospital ward, department, degree of demand such as emergency plans, usage of the operation room, practitioner, number of surgeries, surgery time and situation of labor at anesthesiologist were extracted. The BI data analysis software program allowed for the simple visualization of the conditions of use for the operation room, with which all staff members involved in surgery were able to easily determine “the availability of the operation room”. Moreover, it was possible to show the displayed items in detail by drilling down. Next, when the evaluation axis was “sliced and diced,” and classified by operation room, the total surgery time could thus be determined by room and the intersection of the number of surgical cases and surgery time was thus found to be relatively constant, and the operation room was therefore found to be used efficiently.
This new software program made it possible to effectively respond to requests of the surgical site, thus making it helpful for the management of operation rooms by improving the system analysis quality.
