NextStep webinar · Synthetic demonstration data

Clinic appointment dashboard

Appointments dated 1 January to 16 November 2026 · All records are fictional

20,000Appointment records
49.1%Recorded as completed
17.0%Recorded as no show
160Unknown status

Recorded status

Percentages use all rows in the current view.

Appointments by service

Counts include all recorded statuses.

Appointments by month

November includes 1–16 November only. Compare January through October for full-month volumes.

What the full dataset shows

Of 20,000 records, 9,812 (49.1%) were marked completed and 3,407 (17.0%) were marked no show. The no-show percentage uses every row, including scheduled, cancelled and unknown outcomes. Vaccination had the most records (4,101), and full-month volumes ranged from 1,749 in February to 2,004 in October.

Cleaning decisions. The cleaned copy labels 160 blank statuses as Unknown and keeps the original Google Sheet row number. It flags all 160 rows tied to 80 repeated appointment IDs. Staff can exclude those rows with the filter while the conflicts are unresolved. To resolve them after digitising a paper GOPD register, check the two entries against the register and verify their IDs before correcting either entry.

The source snapshot was retrieved on 21 November 2026. Its audit found zero invalid dates or other format and range exceptions under the checks applied.