Healthcare Services

Healthcare Services

How we can help you

Hospitals are complex organizations that provide many different services for their patients. Unfortunately, most hospitals do not operate using a single, integrated information system and data is often spread across the organization in many different best-of-breed software platforms. We specialize in integrating and consolidating this data for performance management, reporting, and advanced analysis.

The Canadian Healthcare system is unique in many ways and significant experience in many distinct areas is required to successfully deliver clinical analytics projects. We have worked with many hospitals, LHINs, and community providers solving incredibly complex data challenges and giving analysts, managers, and executives new insight into their operations.

Case Costing

Compiling case costing data that meets OCCI standards is a very time consuming and error prone process. Hospitals spend a significant amount of effort manually identifying and resolving data quality issues.

We help hospitals integrate data from their clinical systems, materials management databases, and case costing platforms, such as MedAssets. We provide analysts with the tools they need to identify and resolve data quality issues. We also enable ad hoc reporting and case-level analysis which has saved our clients months of manual effort.

Emergency Services

Managing ED wait times is of critical importance to hospitals. We provide insight into ED time-of-day volumes, ER admissions and bed wait times, revisits, assessment wait times, and patients that leave without being seen.

We link ED and other outpatient records from both National Ambulatory Care Reporting System (NACRS) submission files and MED2020's WinRecs with subsequent inpatient, mental health and rehabilitation stays from both within a facility, and with records from other facilities.

Inpatient Services

We help hospitals track lengths of stay, case weights, transfers, readmissions, alternate level of care (ALC) days, and many other metrics broken down by patient demographics, services, procedures, and a variety of standard case groupings.

We've worked with many Hospital Information Systems (HIS) including AllScripts and Meditech and have also integrated data from CIHI coded data sources such as DAD/NACRS submission files and MED2020's WinRecs.


Statistical and financial information within the General Ledger is consistently among the highest priority data for hospitals to analyze. Hospitals often need more robust reporting and self-serve capabilities than what their standard financial reports provide.

We have developed numerous G/L solutions that reconcile against clinical systems, enable departmental analysis, highlight deviations from budget/forecast and provide the ability to drill down to transaction level detail.

Patient Flow

Producing summary-level visit reports and dashboards isn't always enough. Analysts need the ability to look across patients' episodes of care to detect trends relating to readmissions, transfers, and frequent ED visits.

We've worked with hospitals to combine data across sites and numerous data sources to provide an end-to-end view of a patient's interactions within the healthcare system.


MIS Trial balance files that are submitted as part of the Ontario Healthcare Reporting Standards (OHRS) contain invaluable insight into financial and statistical performance for healthcare organizations.

We have used this data to provide hospitals with performance tools, Hay benchmark reporting, and functional centre efficiency analysis. We also create indicators that allow hospitals to quickly determine how well they perform relative to hospitals that provide similar services.

Maternal & Child Services

Hospitals provide data about every birth in Ontario to the BORN Information System. For most hospitals this process involves an analyst compiling the hundreds of data fields for mother and child and resolving any issues with records that do not meet the many BORN data quality checks.

We simplify this process by collecting newborn information from HIS platforms and specialty systems such as Philips IntelliSpace Perinatal to integrate and produce accurate submission files.


Maximizing Operating Room efficiency requires a thorough understanding of performance indicators, both from a process and financial perspective. Delays in patient service, increased procedure costs and scheduling inefficiencies all impact O/R performance.

We connect to O/R systems within hospitals, such as SIS and PICIS, to enable analysis of key metrics such as start time compliance, room utilization and surgical time durations, from prep through post-operative care. Combining this information with other systems, such as case costing and scheduling, can provide a comprehensive view of O/R costs and workloads.

H/R and Payroll

Many valuable operational metrics can be derived from hospital payroll data including overtime, sick rate, and employee turnover.

Advanced analytical tools that we've developed assist with budgeting, forecasting, FTE reporting, departmental timesheet analysis, and even reconciliation against entries to the General Ledger.


Using the National Rehabilitation Reporting System (NRS) we have provided hospitals calculated FIM scores before and after discharge, breakdowns of outcomes by Rehab Patient Group (RCG), service interruptions, and FIM improvement efficiency.

Linking from rehabilitation to other data sources, such as ED visits and inpatient stays can identify treatment patterns and areas for efficiency gains.

Mental Health

Mental Health data is very detailed and the algorithms used to calculate outcomes are complex. We've used coded records from Ontario Mental Health Record System (OMHRS) to present assessment outcomes, calculate SCIPP groupings with CMI scores and identify length of stay efficiency. We have also used Mental Health data to provide analysis on readmissions, and linkages to acute and outpatient events to identify treatment patterns for regular and short stay visits.

Complex Continuing Care

Continuing care is a growing area of emphasis in healthcare. We provide assistance in performing assessment tracking, site resident summary analysis, analysis of therapy minutes, and calculation of RUG classes and groups. To measure efficiency we provide CMI outcome comparison vs LOS by patient stream and level of care, while also tracking falls, ulcers, restraint use and other events during continuing care stays.

Community Care Access Centres (CCACs)

Community Care Access Centres (CCACs) provide a number of services that help people live independently at home.

Using data from the OACCAC integrated data store, we've helped CCACs gain insight into their referrals, RAI assessments, Alternate Level of Care (ALC) data, and waitlist stats for Long Term Care facilities. We also link referrals to originating acute care episodes to help assess efficiency between the hospitals and the CCACs.