Fast and accurate reporting of HIV Wellness data

100%

Improvement in accuracy of reported data

90%

Improvement in speed of reporting

Background

A major South African medical scheme faced significant challenges with the collection and analysis of it's members' health data. These ranged from finding unique employee identifiers to keeping accurate historical data for individual members aligned with the POPIA act.

Challenge

Platinum Health is a closed medical scheme for employees and dependents of mining companies. It is vital that the scheme has full insight into its members’ HIV status. In the past, Platinum Health produced an Excel-based HIV Wellness report, aligned with the government guidelines to improve the health outcomes and wellness for long-term HIV survivors. The collection and analysis of HIV status data posed major challenges for Platinum Health. The data was derived from disparate data sources that lacked rigorous data integrity cross-checks. Exacerbating the problem, the volume of records had exceeded Excel’s capability and the organisation had to use aggregated datasets for its final reports. In addition, the Wellness report had to be maintained manually. The real challenge was matching employees and their dependents to the testing results as not all members could be identified by SA ID numbers and as a result multiple combinations were possible for a single employee. Historical data also had to remain associated with individuals, whose membership status could have changed over time. The existing Excel system was unable to cater for this.

Approach

Keyrus has implemented a reporting system that overcomes all the challenges to produce accurate reporting. Keyrus’ certified consultants, with their vast experience with Microsoft Power BI as well as Qlik BI and analytics tools, transformed and modeled data from the various data sources into a well-designed data warehouse. They used the core component of SQL Server, the Database Engine, as well as SQL Server Integration Services (SSIS) scripting and views to transform the data from Platinum Health’s medical systems into the structured database. QlikView models were put in place to provide cross-checking, while Power BI delivers the final visualisation. The SSIS Fuzzy Lookup feature was employed to overcome the challenge of matching employees and their dependents to the testing results. All possible combinations are mapped so that results are accurately associated with the correct person. A QlikView model validates member and dependant mapping across all the different data sources.

Key results

Dramatic time-saving and improved visibility into HIV Wellness statistics

Monthly HIV Wellness reports are ran within minutes rather than days

Reports based on consistent, accurate data and sound logic

Benefits

The data reporting solution solves these issues to reveal precise, up-to-date information about members and their dependents. The information is 100% secure. The medical scheme now benefits from dramatic time-saving and improved visibility into those all-important HIV Wellness statistics. The customer is confident that their monthly reports are an accurate reflection of the health of their members and that the data is aggregated for reporting purposes. Platinum Health can now run its monthly HIV Wellness report within minutes rather than days, freeing up time for valuable analysis. The final report produces wellness statistics month-on-month, which was previously impossible. Finally, Platinum Health is able to accurately identify data mismatches, resulting in process and integration issues being resolved quickly, and enforce consistent application of the correct logic.

What our clients say

We now benefit from dramatic time-saving and improved visibility into the HIV Wellness statistics and our monthly reports are an accurate reflection of the health of our members.

Alta De Beer, Service Delivery Manager, Platinum Health