Case Study
Client | Alexandra Hospital |
Product | CUBOT Financial Information System for Healthcare |
Categories | Healthcare, Revenue Analysis |
Data Sources | SAP Billing System and Excel Files |
Metrics of Focus | Revenue Performance, Cost Accounting |
Time to Deliver | Approximately 3 Months |
Singapore’s public healthcare is regarded as one of the best systems for healthcare in the world and we have worked with several publicly managed hospitals in Singapore. While the structure of the healthcare system has evolved over the last decade or so, having different managing bodies, IT centralization to IHIS, and having different holding bodies. Alexandra hospital is a public hospital with a sizeable occupancy of about 300 beds, offering multiple specialist services and therefore tertiary care. Our implementation for healthcare providers is fairly extensive by means of data processing, ETL and scheduling, as well as the calculation of metrics for Healthcare finance. Because the reporting needs for finance is fairly high due to the need for end of month reports, as well as the fact that it is the department closest to the information on profitability, the implementation demands are also higher.
The analytics solution that was delivered meant that healthcare administrators were able to use data from multiple systems effectively in order to drive better hosptial performance.
Through the use of transaction information, the hospital finance team was able to make use of data to generate general ledger reports. Data processing and scheduling were streamlined to provide the finance team with all their information needs within 3 hours of closing for the day. Less time spent collating GL reports meant that more time could be allocated to understanding revenue and cost trends.
Healthcare Finance in Singapore reports Bill Sizes to the Ministry of Health, who then publishes average bill sizes for DRGs across public hospitals in Singapore for patients to make more informed choices.
The need to drive costs down for hospital operations often arises from the administrative side of healthcare, rather than the medical side. Therefore the finance department’s role in reducing bill sizes is to understand anomalies and higher than average costs within DRGs to then understand why a higher cost may occur. The strength of the CUBOT’s data discovery features was really used in this scenario, where analysts were exploring bill size statistics within many categories, down to a reasonable level of depth.
Doctors fees were calculated based on the number of private and subsidised patients that the doctors consulted. Using the defined logic to calculate their fees, the process can be automated to save more time performing this routine activity.
Furthermore, the idea is that doctors should be rewarded for taking on greater workloads, and so the calculation of the rewards required fair amount of logical inputs that were not friendly to calculate in regular MS Excel or Access.
Understanding customers is just as important for revenue analysis as customer segments and patient characteristics become apparent. Demographic information, housing information were particularly noteworthy for Singapore public hospitals from a finance perspective.
Challenges |
Solutions |
Product Module |
---|---|---|
Enormous learning effort to design and implement data reporting and analytics | Soltion for Healthcare Finance | Vizualytics Solutions |
Automating routine GL reports | ETL, Automated Calculations, Data Integration | CUBOT ETL Vizualytics Services |
Data not available in time | Scheduled data processing & calculations that are nearly real-time | CUBOT ETL |
Difficult to derive some information through excel | Calculating logic-based metrics through scripts | Vizualytics Services |
Lack of insight into relationships, patterns and category-wise information easily | Data Modelling and Drill-Down features | CUBOT Analyze |
Up to date information such as patient bills, visits, hospital and department financial results, workloads and referrals are just a few clicks away