Abstract
ObjectiveCollaborate, Analyse, Research and Audit (CARA) project set out to provide an infrastructure to enable Irish general practitioners (GPs) to use their routinely collected patient management software (PMS) data to better understand their patient population, disease management and prescribing through data dashboards. This paper explains the design and development of the CARA infrastructure.MethodsThe first exemplar dashboard was developed with GPs and focused on antibiotic prescribing to develop and showcase the proposed infrastructure. The data integration process involved extracting, loading and transforming de-identified patient data into data models which connect to the interactive dashboards for GPs to visualise, compare and audit their data.ResultsThe architecture of the CARA infrastructure includes two main sections: extract, load and transform process (ELT, de-identified patient data into data models) and a Representational State Transfer Application Programming Interface (REST API) (which provides the security barrier between the data models and their visualisation on the CARA dashboard). CARAconnect was created to facilitate the extraction and de-identification of patient data from the practice database.DiscussionThe CARA infrastructure allows seamless connectivity with and compatibility with the main PMS in Irish general practice and provides a reproducible template to access and visualise patient data. CARA includes two dashboards, a practice overview and a topic-specific dashboard (example focused on antibiotic prescribing), which includes an audit tool, filters (within practice) and between-practice comparisons.ConclusionCARA supports evidence-based decision-making by providing GPs with valuable insights through interactive data dashboards to optimise patient care, identify potential areas for improvement and benchmark their performance against other practices.Supplementary file 1. Graphical abstract
Reference30 articles.
1. Licken E . Software claims to improve health of GPs’ records Business. The Irish Times 1998. Available: https://www.irishtimes.com/business/software-claims-to-improve-health-of-gps-records-1.153139
2. Diagnostic coding of chronic physical conditions in Irish general practice;Pericin;Ir J Med Sci,2022
3. Data-driven activities involving electronic health records: an activity and task analysis framework for interactive visualization tools;Rostamzadeh;MTI,2020
4. Irish College of General Practitioners . Accredited GP practice software management systems. 2022. Available: https://www.icgp.ie/go/in_the_practice/it_in_the_practice/software_companies
5. ICGP Data Protection Working Group . Processing of patient personal data: a guideline for general practitioners. Irish College of General Practitioners, 2019.