Selected projects

Context

Scheduling systems in health facilities generate detailed appointment and attendance records, yet they are often reported only as monthly totals. The planned project uses a synthetic data set representing a clinic network’s appointments, patients and attendance outcomes.

Approach

The analysis will model appointments, patients and attendance tables, then use SQL to calculate wait-time distribution, no-show rate by weekday and service, and monthly utilisation against available slots.

Outcome

No results are published yet. The intended deliverable is a documented query set and a short findings summary, built on synthetic data only — never real, client or confidential health data.

Context

Operations teams often track deliveries in dispatch sheets that are difficult to compare across routes and periods. The planned project uses a simulated set of shipment records, routes and delivery timestamps.

Approach

The planned work consolidates shipment records and defines on-time delivery measures by route and period, shaped into a Power BI dashboard concept for a weekly operations review.

Outcome

No dashboard has been delivered yet. The intended output is a working prototype and documented KPI set, using demonstration data only.

Context

Planned as academic coursework: a recurring management report assembled from several inconsistent source files.

Approach

The planned model builds a Power Query import and cleaning routine, adds validation rules and exception lists, and produces a monthly reporting template with a documented review step.

Outcome

No workbook is published yet. The intended output is a repeatable reporting template and data quality checklist. Academic project, not a commercial engagement.