InfoSpring - Data Solutions

Case Studies

Case Study

The Covid Care at Home (CCAH) program provided at-home virtual care to over 180,000 COVID-19 positive patients across 4 Australian states. InfoSpring provided data and analytic services connecting all program components, and gave key insights to guide service improvement.

PROCESS

Coordinated data flows, ensuring that data from different sources and formats was loaded into patient management software.

Oversaw ensuring timely screening, contacting and service delivery of all active patients in program.

Helped develop and implement online client feedback systems sent to patients via SMS.

Extracted, blended and transformed program, telephony and client feedback data for reporting and analytics.

REFERRALS

Referrals received securely from 4 jurisdictions through a combination of APIs, batch uploads and portals downloads.

ETL

Data extracted from each system, transformed and loaded into patient management software.

TELE-DATA FEED

Telehealth staff called patients to check severity of symptoms and need for further services during duration of infection.

SURVEY

Patients sent a survey at the program completion gauging satisfaction and hospital avoidance.

ETL

Patient data from patient management software, telephony and satisfaction surveys blended for reporting.

OUTCOMES

REPORTING

Reporting delivered to providers daily, monthly and program completion. This involved monitoring compliance metrics.

FORECASTING

Ongoing forecasting based on predictive models developed to help inform upcoming workforce requirements.

CONTINUOUS IMPROVEMENT

Bespoke analysis undertaken to inform program development as new funders came on board.

“Covid Care at Home was a fast-evolving initiative that required many moving parts. InfoSpring helped to connect the components from different jurisdictions as their needs rapidly changed. InfoSpring gave us and funders assurance on what was happening in the program quickly and efficiently.”

- Vanessa Janissen, National Director - Strategy & Service Development (Calvary Healthcare).

Case Study

Medibank customers make over 1M hospital visits per year. Analysis of hospital visits - known as separations - is essential for contract negotiations. InfoSpring helped Medibank develop and validate a robust method of grouping medical claims into hospital separations.

PROCESS

Extracted and blended data from multiple sources to develop a hospital claims database.

Preliminary analysis on 1 years' worth of claims data informed grouping logic and initial code.

Data tested within confined parameters through iterative process of code refinement and larger data-set inclusion.

Full 2 years' worth of data coded (~20M claim lines) and final refinements undertaken to complete acceptance testing.

EXTRACTION

Access to data warehouse tables allowed for data extracts that had all information required for separation coding.

ANALYSIS

Analysis of 1 years' worth of data was performed to validate extract and check assumptions in existing logic.

DEVELOPMENT

Developed order of operations logic to ensure that all relevant claims were bundled according to agreed scope.

REFINEMENT

Data outputs shared with business to help identify errors and improve model over a number of iterations.

ACCEPTANCE TESTING

Full user acceptance testing involved systematically reviewing 2 years' worth of data – achieving 99% compliance.

OUTCOMES

LOGIC

Translated the existing logic into a much simplified sequential order of operations agreed to across all areas involved.

CODE

Logic was translated into a robust set of code that accurately and reliably grouped hospital claims into hospital separations.

VALIDATION

Each stage of logic and code development and refinement was documented and agreed upon until both were signed off as complete.

“InfoSpring came in to assist with the implementation of complicated logic on a large amount of data. Their systematic and thought driven approach to providing a solution was pragmatic and communicated every step of the way. They appropriately liaised with various technical and business partners, ensuring all areas were delivering on their actions. The project was set up for success due to the foundational work completed by InfoSpring”

- Liam Jansen, Head of Provider Analytics (Medibank Private).

Case Study

Nunkuwarrin Yunti provides culturally based health and wellbeing services to the Aboriginal and Torres Strait Islander population in South Australia. InfoSpring delivered dashboards across service operations to improve outcomes and contractual compliance.

PROCESS

Operational data from health services was analysed to identify improvement opportunities.

Full dashboard suite scoped reflecting all aspects of operations and sequenced according to client requirements.

Dashboards developed in test environment, validated and iteratively released and implemented with local staff.

Dashboard suite inputs remapped to provide a fully cloud based reporting system.

ANALYSIS

Client data from patient management system extracted and analysed to identify client journey and opportunities for improvement.

SCOPING

Client journey pathways mapped and dashboard suite content to measure performance developed.

DEVELOPMENT

Data sources for each dashboard mapped to relevant data tables and initial outputs validated with operational staff and system administrators.

DASHBOARDS

Each set of functional dashboards were detailed in a product specification as they were finalised and released.

CLOUD MIGRATION

Cloud dashboard migration included both secure online publication and remapping inputs to a cloud hosted solution.

OUTCOMES

DASHBOARDS

Full suite of validated dashboards developed, refined and delivered to monitor operational function and outputs.

DOCUMENTATION

Dashboard outputs supported by comprehensive data governance, contract maintenance and product specification documentation.

CONTINUOUS IMPROVEMENT

Local staff engaged to be responsible for dashboard metrics to deliver data driven service improvement.