Business Intelligence & Analytics

In 2017-18, funding was approved to develop a Business Intelligence (BI) solution for SHIIP to support enhanced analysis at the population level. Project objectives include:

  • Implementation of the Information Builders BI Solution in SHIIP
  • Seamless customization of BI Solution in accordance with SHIIP privacy, security and reporting requirements
  • Establish a knowledgeable SHIIP Technical Team with the skillset to maintain and further develop BI Solution applications in SHIIP
  • Inform stakeholders on the value of BI Implementation in SHIIP and provide a priority list of future BI development activities

The SHIIP BI tool will allow and enable secure and customized access to SHIIP data sources and reports for purposes of analytics, health system planning, research and performance monitoring while still adhering to the SHIIP data privacy and security framework.

The SHIIP BI solution is expected to:

  • Improve timely access to relevant data on service utilization of patients across multiple health care sectors
  • Improve the ability of end users to understand and manage all patients, with particular emphasis on patients with complex health care needs
  • Expand and enhance reporting capabilities in response to regional or provincial priorities
  • Improve reporting for Health Link and Sub-Region care coordination activities
  • Improve ability to access data within SHIIP datasets and generate custom queries and reporting

FAQ

What is the SHIIP BI solution?

  • “Business Intelligence” or BI for short, describes a computer-aided methodology that includes applications, infrastructure, tools, and best practices that enable the transformation of raw data into meaningful and useful information.
  • The SHIIP BI solution will provide access to encrypted, de-identified data at an aggregate level
  • The SHIIP BI Solution is based on Information Builder’s WebFocus technology to leverage industry standard data visualization and analytical capability in decision support.

What will the SHIIP BI solution do?

  • The SHIIP BI tool will allow and enable secure and customized access to SHIIP data sources and reports for purposes of analytics, health system planning, research and performance monitoring while still adhering to the SHIIP data privacy and security framework.
  • The SHIIP BI solution will support population level analysis at the service and system level
  • The SHIIP BI tool will add flexibility and responsiveness to the development process for queries and reports and open up report/graph development to a wider range of non-technical users.
  • Authorized end users will be able to process ad-hoc queries and run customized reports to meet their individual reporting requirements.

Why is the SHIIP BI solution valuable?

  • It will improve timely access to relevant data on service utilization of patients across multiple health care sectors
  • It will improve the ability of end users to understand and manage all patients, with particular emphasis on patients with complex health care needs and patient flow
  • It will expand and enhance reporting capabilities in response to regional or provincial priorities
  • It will improve reporting for Health Link and Sub-Region care coordination activities
  • It will improve ability to access data within SHIIP datasets and generate custom queries and reporting

Who can access the SHIIP BI solution?

  • The SHIIP BI solution has an embedded and an ad-hoc analytical component. The embedded component allows all SHIIP users access to pre-defined reports, dashboards and displays, and access is seamless once the user has logged into SHIIP. The ad-hoc analytical component, also referred to as the ‘Analytical Portal’, will allow a selected group of authorized and trained SHIIP users access to do ad-hoc and user-specific analysis and reporting.

What will change within SHIIP when the BI solution is introduced?

  • The embedded component of the BI solution will replace some of the existing reports and dashboards in SHIIP. Apart from minor changes to report formats, content will remain the same and users may not necessarily notice any changes. If required, all changes will be communicated to SHIIP users prior to the SHIIP version being released.
  • There will be no change to how you access SHIIP or use SHIIP to access information at a patient level.
  • The ad-hoc analytical component of the BI solution, can be launched from within SHIIP. This feature will only be available to authorized users. Guides and/or training manuals will be made available to support users.

When will the SHIIP BI solution be accessible?

  • TBD

How can I support the development of the SHIIP BI solution?

  • There will be an opportunity for key stakeholders to support the development of the SHIIP BI solution through engagement in a needs assessment, as well as user acceptance testing and participation in a pilot. Phase 1 of the project includes the replacement of existing reports and dashboards in SHIIP. Phase 2 will allow for stakeholder engagement to identify needs and requirements for new reports, dashboards, and analytical access requirements to support business decisions and workflows. The phase 2 needs assessment and stakeholder engagement has not yet been scheduled.

How will the BI solution manage access to PHI?

  • The BI solution will honour all of the existing SHIIP rules to limit access to PHI only to authorized users. It will also protect aggregated data through encryption of health numbers and/or masking of PHI, suppressing low cell counts, allowing analytical access only to aggregated data sets and keeping a privacy audit log on user access.

How is this BI solution different from the IntelliHealth data sets?

  • The SHIIP data contains data sets from all contributing sectors and will be expanded over time to include all of the hospital data sets as well as community sector and primary care data sets. These data sets are current (real time or near real time) allowing for operational or time-sensitive system-level decisions to be made.  IntelliHealth does not provide community-level data and data sets lag between 1 and 3 quarters.  SHIIP also allows for tracking the patient journey across sectors.

How is this BI solution different from the Hospital Information System (HIS) data sets?

  • The SHIIP data sets include data from the acute care sector, community sector, primary care sector, home care sector, and mental health sector. These data sets allow for analysis across all health sectors. It is uncertain at this stage if, when, and to what extent HIS applications will interface with other sectors.

How is this BI solution different from the SE Data Centre (SEDC)?

  • The SEDC contains IntelliHealth hospital data and community sector data that is updated on a quarterly basis (in respect of hospitals) and annually in respect of community sector data. SHIIP data sets are real time or near real time and allows for cross sector patient journey tracking.

How is this BI solution different from the EMR dashboard?

  • The EMR Dashboard is an initiative from OntarioMD and provides physicians insight into several defined quality and performance metrics based on their practice and how they compare to others. Allows for primary care data only or data related to defined metrics. SHIIP has included in its development roadmap an integration with the EMR which will provide context across all health sectors for all patients in the physician’s care.

Where can I learn more about the SHIIP BI solution?

  • Progress updates will be available on the SHIIP Knowledge Centre. For more technical or in-depth information, please contact Dirk Hogewoning at the South East LHIN.