Background
University
of Malaya Medical Centre (UMMC) formerly known as University Hospital is
the first teaching public hospital, under the Ministry of Higher Education with
1,617 beds.
Problems Faced &
User Requirement
Before Speedminer came
in to provide its Speedminer BPM & DW, there were noticeable flaws in the
current system that all staffs were using where one of them is that the current
system lack data mining services. As a result all staffs had to come up with
their own initiatives to come up with their own methods to do analyzing and
reporting, whether using the usual MS Excel, MS Access, MS SQL Server and other
database services. Another major problem was the difficulty encountered when
special cases arose where data filtering had to be done manually. If there was
a huge number of records needed to be analyzed, which in most cases there are,
only samples were considered, including samples that were chosen or picked to
be displayed or kept, because of its “pretty” data and results. This does not
produce incorrect information, as only the good ones are chosen and displayed,
whereas the bad ones that need to be considered and mostly concerned are lost
and not produced. There was no systematic system to store and include all the
data, so staffs could actually lie on the reports and data analysis to make
their department/line of work looks good. As a result, this has created massive
incorrect information and data perception caused by huge human errors. There
were no centralized unit for databases and records PPUM felt like they needed
to significantly improve its database storing system. Furthermore, manual
computations needed to be done to actually present or analyze the data were
very time consuming which also creates a lot of confusion not only to the ones
who were performing the calculations, as they needed to recheck and recalculate
several times to get a consistent result, but also to the next persons reading
the data (problems interpreting the data), data display is incomprehensible.
This has led them to invest an extremely huge amount of time, energy and
resources where in some cases more workforce are needed to complete one
computation or data analysis.
Strategy Followed
With Speedminer BPM
& DW, the BI tool developed was developed in a way that all users are able
to build a vast portal which includes multiple pivot tables, dashboards of data
for financial data and HR data especially used by Nadi IT. Speedminer BI helps
to simplify the way that record is being stored and for easy retrieval. Besides
also providing accurate and comprehensive representation of data, all
computations are made easy so that all reports can be generated easily. For
instance, one of the major reports mostly implemented in the radiology
department called the Patient Journey report as a matter of fact allows the
users to track and analyze the journey of each patient in their record through
the inpatient/outpatient/radiology exams.
The introduction of the Speedminer DW and BI has significantly reduced human errors and data representation and record display are nothing but precise and accurate due to the fact that miscalculations, wrong charging and false analysis records can be avoided because with the new BI, staffs can no longer pick the records with good results, it show true state, productivity and potential of the hospital. Analysis generation is precise, accurate and standardized where records used by each users are records that are centralized and calculations are all standardized.
Data Sources
The Data Warehouse and
BI project was awarded as part of the Total Hospital Information System to FSBM
Bhd, the main contractor. This project involved integration of various systems
from different databases i.e. Hospital Information System, Laboratory
Information System, PACS, CCIS etc.
Achievements
According to one of the
users of this new BI in UMMC, the Speedminer DW & BI has helped the
easiness of the financial, management, and record management that ensures
smooth running of operation. Less energy, time and resources are required to
generate reports, perform calculation, analyzing data that leads to increasing
productivity of the hospital. The BI tool was made easy so that users
understand the representation of data and does not need to become expert IT
personnel to actually use the BI. Comprehensive and constructive training as
well as continuous support bestowed by the Speedminer team has made them feel
like they are being “walked-through” the software. Overall all staffs are happy
with their new BI implementation that leads them to work in a less-stressful
and less time-consuming environment. Accurate analysis has made them better
understand the potential and productivity of the facility and has helped them
in decision-making processes and communications between departments.