How We Can Help You

The Canadian healthcare system is unique. Significant experience in many distinct areas is required to successfully deliver healthcare analytics projects. We have helped many hospitals implement complex analytical solutions that give analysts, clinicians, managers, and executives new insight into their operations and patients.

Technology Services

Data Warehouse & Analytics Development

Hospitals collect large volumes of data across their organizations. Consolidating and effectively analyzing this raw information has become prohibitively difficult. We help take this vast amount of data and transform it into understandable information that can help hospital staff and leadership make better decisions.

We have successfully led high-profile data warehouse projects that integrate information from commonly used hospital information systems. We are also experts in creating effective data visualization tools that enable people to easily understand the data and uncover trends.

Custom Application Development for Healthcare

Our healthcare clients often need customized applications to meet their unique business needs. Successful development projects require a broad range of skills including planning, programming, database development, project management, quality assurance, and intuitive user interface design. We provide all of these skills to ensure that your next project is a success.

We first focus on understanding your business needs and then we architect the right software solution to meet those needs. We minimize the risks typically associated with software development initiatives by relying on proven best practices and software development lifecycle methodologies.

Subject Matter Expertise

CIHI Coded Abstracts

Over the past decade, 3terra consultants have created numerous analytical solutions based on inpatient (DAD) and outpatient (NACRS) coded data. We help hospitals track performance and outcome indicators as well as key operational metrics across entire hospitals. Our solutions enable advanced patient population analysis to help measure and improve patient care.

We work with both vendor abstracting systems (MED2020, 3M) as well as the CIHI coded submission files. We also have considerable experience implementing standardized provincial indicators.

ADT and Patient Flow Analysis

Understanding how patients move within a hospital is critical for predicting bottlenecks and improving patient flow. Managers need the ability to anticipate and react quickly to capacity issues and understand where recurring problems arise.

We have helped organizations use their ADT and ED data to understand how individual patients and entire populations interact with hospitals, programs, and individual units for both historical and near real-time analysis.

HR Utilization and Payroll

Many valuable operational and quality improvement metrics can be created using hospital payroll data including nursing utilization, overtime, sick rate, agency usage, and employee turnover.

Our successful projects include advanced analytical tools that assist with budgeting, forecasting, efficiency/variation analysis, and even reconciliation against entries to the general ledger.

Case Costing

The Ontario Case Costing Initiative (OCCI) dataset is rich with useful information to benchmark hospital patient populations against peers. Analyzing case costing data identifies areas for quality improvement, care path variation, and improved cost effectiveness.

Additionally, compiling 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. Our solutions help hospitals integrate data from their clinical systems, materials management databases, and case costing platforms to 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.

General ledger analytics

Statistical and financial information within the general ledger is consistently among the highest priority financial 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.

Emergency services

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

In addition to using coded abstract data (NACRS), we have also developed near real-time ED data marts to power live operational dashboards and reports.


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, 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 many 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 have simplified this process by creating a software solution called BASE that automatically collects newborn information from HIS platforms and specialty systems such as Philips IntelliSpace Perinatal. BASE analyzes the compiled information for data quality errors and generates submission files that can be submitted directly to BORN Ontario.


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.


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.