UConn AIMS has worked on a variety of projects and initiatives over the last several years; a selection of our past and ongoing efforts are detailed below.
Core Data Analytics Solution and Related Services for the State of CT Health IT
The State of Connecticut is taking critical steps to accelerate the use of health information technology (HIT) and provide state residents with timely, coordinated, and person-centered care. In this context, and to achieve the State’s aims of healthier people, better healthcare, smarter spending, and health equity, the State is establishing a holistic information management solution to include Health Information Exchange (HIE) and health information services, as envisioned by Public Act 16-77. Under the public act, the Health Information Technology Officer (HITO) was established within the Office of the Lt. Governor with authority to develop and coordinate implementation of a statewide health IT plan and administer a statewide HIE.
To realize the State’s vision, the HITO has established a memorandum of agreement (MOA) with the University of Connecticut (UConn) and its Analytics and Information Management Solutions (AIMS) group. This agreement is to develop the underlying HIE and Core Data Analytic Solution (CDAS) architecture and roadmap, solicit industry-leading vendor expertise, and oversee development activities. The HITO and AIMS’ Solution Architect are focused on the design, development, and implementation of an innovative statewide quality measures analytics system, including electronic clinical quality measures (eCQM) and other quality analytics, in support of healthcare quality improvement activities and value-based purchasing models. The CDAS shall provide meaningful insight and analysis on transactional and clinical healthcare data and related activities in a way that supports the quadruple aim of better health, better care, lower costs, and improved work-life of healthcare providers.
COVID-19 Decision Support Dashboards (DSD)
At the onset of the COVID-19 pandemic, UConn AIMS was asked to assist Governor Ned Lamont's office and the ReOpen CT initiative by creating a set of curated dashboards to provide insight into the virus's impact on the state. As part of this initiative, the COVID decision support dashboards (DSD) were built for organizing and visualizing various public state data sources regarding COVID case trends, economy and employment trends, and hospital equipment allocations. This was a collaborative effort with Boston Consulting Group (BCG) in which UConn AIMS was able to rapidly land data from API, email, and uploaded sources into CDAS, where it was then transformed it into usable data lake tables for downstream analytics. BCG made the first set of dashboards, which were subsequently absorbed and enhanced by UConn AIMS leading up to the release of DSD 2.0.
Mobile and Nursing Home Data Visualizations
As the pandemic has progressed, the DSD initiative has sparked several offshoot data initiatives, including dashboards reflecting COVID Mobile Testing data as well as nursing home testing data. To incorporate these datasets into CDAS, UConn AIMS has worked directly with the health organization representatives to facilitate upload and quality processes. From there, the data has been harmonized in CDAS and pushed into Tableau to create useful visualizations.
UConn AIMS, in collaboration with UConn Health, applied to and was awarded an opportunity by the Community Health Center Association of Connecticut (CHCACT) to provide analytics designed to better understand the impact of telehealth on clinical practice within the federally qualified community health centers (FQHCs) in Connecticut. For this initiative, UConn AIMS will leverage CDAS’s modular architecture to establish secure, normalized datasets for analytics and visualizations. The project team will provide the subject expertise to define and implement the easiest process for FQHCs to send the required data to CDAS, and then initiate the following process steps: data ingestion and processing, delivering analytics output, and revising said outputs.
UConn Health Center’s Health Disparities Institute Collaboration
This collaboration between the UConn Health Center’s Health Disparities Institute (HDI), the Department of Social Services (DSS), and UConn AIMS seeks to: 1) investigate patterns of behavioral health services utilization among CT’s Black adult male Medicaid beneficiaries; 2) examine the geospatial distribution of the Medicaid-eligible behavioral health services (in-person, telehealth, and telephonic) they access; and 3) explore potential socially determined barriers to and facilitators of services utilization. In their capacity as a collaborator on this grant project awarded by the Commonwealth Fund, UConn AIMS will provide data management and transformation services to facilitate downstream analytics.
HealthscoreCT Cost Estimator
The Office of Health Strategy requested the UConn AIMS assist in the creation of the state’s healthcare Cost Estimator, a dashboard and web application that uses All-Payer Claims Database (APCD) Limited Data Set (LDS) data to identify the total cost of selected “shoppable” healthcare services or procedures by healthcare provider organizations. This set of curated dashboards aims to provide consumers with useful information about the typical costs and frequencies of specific medical services and procedures throughout the state.
In addition to hosting the site in our secure environment, UConn AIMS used CDAS clean, filter, enhance, analyze, and secure the relevant APCD LDS data. 3M Core Grouping Software was applied to the data to provide additional insights, and Tableau was used to create advanced visualizations. Based on requirements provided by OHS, UConn AIMS launched the Cost Estimator 1.0 on September 30, 2019. The Cost Estimator 2.0 was subsequently released in February 2020 and included several enhancements to the existing functionality.