Skip to Content
Graphs and charts depicting data analytics information and insights.
Case Study

Analytics framework improves efficiencies and provides valuable insights

July 6, 2022 / 3 min read

A new analytics framework helps a medical research university improve their ePHI user access security and analysis and create operational efficiencies to focus on value-add risk mitigation activities.

The challenge

A private medical research university sought assistance in reviewing multiple healthcare applications to identify account access exceptions, or users not trained to handle health data. The analysis led to the identification and confirmation of user access for select data systems with access to electronic protected health information records (ePHI) covered by HIPAA.

The evaluation required extensive data management and analysis efforts across a number of disparate applications and systems. This process includes the collection, standardization, integration, and analysis of user application files and match-based queries to an approved list of users with permission to access ePHI within university-owned applications.

While the standard approach was effective, it was operationally inefficient, unresponsive to changing requirements, and didn’t provide visualized insights:

The solution

Our cross-functional team of cybersecurity and data analytics experts designed an improved analytics framework to automate the process of data collection, management, and analysis. Leveraging advanced analytical tools including Alteryx, SQL, and Tableau, we greatly improved their efficiency, responsiveness, and ability to produce insightful analysis. The new analytics framework was divided into three phases:

1. Data importing, cleaning, and standardization

2. Query-based matching method within secure SQL server database

3. Generation of department-level reports and dynamic analysis

Additionally, throughout the process, department leader feedback was integrated to improve the accuracy and timeliness of the analysis.

The benefit

This improved approach allows the university to spend time on value add, risk remediation activities versus manual data processing. This shift from tactical tasks to strategic advising results in a sustainable, data-driven solution. The university can now better understand the root causes that lead to user access errors, and increase the speed risks are remediated.

Related Thinking

Wealthy couple talking to their financial advisor.
January 16, 2025

Why the Change Healthcare breach is a wake-up call for CFOs

In The News 5 min read
Construction professionals reading on their laptop about succession planning.
January 10, 2025

Building a legacy: Ensuring effective knowledge transfer as part of succession planning

In The News 5 min read
Aerial view of shipping port.
January 9, 2025

Reflections on 2024 and predictions for the year ahead

In The News 4 min read