Skip to content

A1C monitoring for a diabetes population

Find the patients behind the care gap.

Care Gap Explorer turns healthcare data into an explainable A1C monitoring workflow, from population-level gaps to the evidence behind each patient.

116 patients · 25 open gaps · data through Aug 23, 2026 · synthetic data

Care Gap Explorer Home: 116 patients in the cohort, 25 open A1C gaps, 21 never tested and 91 current, above the first five patients needing attention.

Why this matters

A1C is how diabetes is followed over time. A missing one is easy to miss.

A1C is a blood test that reflects average blood glucose over roughly the past two to three months. Repeating it is how a care team follows a patient's diabetes from one visit to the next.

When no recent result is on file, that monitoring has lapsed: a care gap. Across a whole population, finding those patients means reading records one at a time, or a measure you can trust and explain.

91
CurrentAn A1C in the 365 days before the data date.
4
OverdueAn earlier A1C, but none in the last 365 days.
21
Never testedNo A1C anywhere in the available data.

116 patients, measured on Aug 23, 2026. A monitoring status is not a diagnosis and does not determine treatment.

The product

One measure, six ways to work with it.

From the population to one patient and back, every page reads the same patient-level measure.

Care Gaps

Identify monitoring gaps

Every patient with an open A1C gap, in one work queue: never tested first, then the longest overdue.

  • Filter by status, care setting, age and insulin
  • Review any patient's evidence without leaving the list
Open Care Gaps
Care Gaps: tabs for all, never tested and overdue, filters, and the list of open gaps with a Review button on each row.

Patient workspace

Understand the patient

Why a patient has their status, with the evidence beside it: the latest A1C, every result on file, medications and procedures.

  • The care-gap assessment in plain words
  • A1C history, testing per year, therapy
Open Patients
A patient workspace showing status, latest A1C, last seen and diabetes therapy, and the A1C monitoring status.

Tasks

Coordinate follow-up

A follow-up task for each open gap: status, assignee, due date, notes and every change. Completing a task never changes the clinical status.

  • Review, outreach, scheduling, completion
  • Demo workflow data, kept in your browser
Open Tasks
A follow-up task beside its clinical evidence, with status, assignee, due date, a workflow note and activity history.

Analytics

Explore the population

How monitoring is going across the whole cohort, always with the denominator in view.

  • Coverage and the make-up of the gaps
  • Gap rates by age band and care setting
  • Testing over time and the spread of results
Open Analytics
Analytics: four figures, A1C testing over time, and donut charts for monitoring coverage and the make-up of open gaps.

Ask AI

Ask questions of the data

Ask in plain words and get counts, patient lists and comparisons, then ask how the answer was calculated. Rule-based and computed in your browser, not a language model.

  • Follow-up questions on the last answer
  • The population, filters and denominator behind every answer
Open Ask AI
Ask AI listing never-tested patients, follow-up suggestions, and how the answer was calculated.

Data & Quality

See how the numbers were produced

The pipeline, the checks and the reconciliation behind every figure, computed from the same patient rows every page uses.

  • 116 = 91 + 25, and 25 = 21 + 4, checked on every build
  • Every data-quality check, with its result
Open Data & Quality
Data & Quality: the reconciliation of 116 = 91 + 25 and 25 = 21 + 4, and the A1C monitoring measure.

How it works

From data to decision

Six steps, each with one job. Each hands the next a smaller, cleaner set, until one row describes one patient.

  1. Step 1

    Synthetic source

    Health records for 1,159 synthetic patients.

  2. Step 2

    Raw / Bronze

    A faithful copy, kept exactly as received.

  3. Step 3

    Clean / Silver

    Checked and typed. 223 problem rows set aside, each with a reason.

  4. Step 4

    Diabetes cohort

    116 patients with a recorded diabetes diagnosis, alive on the data date.

  5. Step 5

    A1C measure

    One row per patient: the latest A1C and the monitoring status.

  6. Step 6

    Care Gap Explorer

    The pages you use to find, review and follow up.

Built to be explainable

Every number can be traced back to patients.

The decisions that make a care-gap count trustworthy, written down and checked.

Patient-level measure

One row per patient, so every count is a count of people.

Explicit denominator

116 patients with diabetes, alive on the data date. Every rate divides by it.

Fixed reporting date

Measured on Aug 23, 2026, the day the data ends, so the answer does not drift.

Written definitions

Current, overdue and never tested, with the 365-day boundary stated: 365 days old is current, 366 is overdue.

No patient dropped

Patients without an A1C are kept. An inner join would silently remove all 21.

Data-quality checks

Problem rows are quarantined with a reason, never quietly deleted.

Reconciliation

Every source table balances: source rows = clean rows + quarantined rows.

Checked on every build

116 = 91 + 25

25 = 21 + 4

cohort = current + open gaps; open gaps = never tested + overdue

Technical case study

The engineering behind the measure.

Fourteen slides for data and analytics engineering teams: building the cohort, the join that keeps never-tested patients, patient-level grain, the fixed reporting date, and the checks that reconcile every number.

Cover slide: Care Gap Explorer, from healthcare data to actionable A1C monitoring gaps, with one dot per patient: 91 current, 4 overdue, 21 never tested.

About this project

What Care Gap Explorer is, and what it is not.

  • A portfolio demonstration

    Built to show healthcare data engineering and product work end to end.

  • Synthetic healthcare data

    Generated records (Synthea). No real patient appears anywhere; data through Aug 23, 2026.

  • Not clinical decision support

    Not intended for diagnosis or treatment, and makes no recommendation for any person.

  • Workflow is a demonstration

    Tasks, notes and assignments are demo data, saved only in your browser.

Explore Care Gap Explorer

See how healthcare data moves from population-level monitoring gaps to patient-level evidence, workflow and analytics.