General Overview
Year-to-date clinical activity summary across all service lines · 2025
Total Encounters
0
All service lines combined
Outpatient Visits
0
75.3% of total
OT Procedures
0
Avg 112/month
Implantology Cases
0
Avg 72/month
Inpatient Admissions
0
49.3% avg bed occupancy
A&E Cases
0
Avg 54/month
Laboratory Cases
0
Avg 58.5/month
Aesthetic Clinic
0
Hair Transplant: 109
Monthly Service Volume Trend
All service lines · Jan–Dec 2025
Service Mix Distribution
YTD 2025 — share of encounters
Outpatient75.3%
Inpatient6.7%
OT Dept6.1%
Implantology3.9%
Laboratory3.2%
A&E2.9%
Aesthetic1.4%
Hair Transplant0.5%
Service Volume Heatmap by Month
Darker colour = higher volume · All service lines · 2025
Outpatient Visits Analysis
Consultation breakdown, referral hospital distribution · 2025
Total Consultations
15,428
Direct consultations YTD
Total Proxy
61
Proxy patient visits
Total Outpatient
16,606
Incl. all referral channels
SSB Hospital Referrals
738
Largest referring facility
PMMP Hospital
248
Second referring facility
PIHM Hospital
131
Third referring facility
Monthly Outpatient Volume
Consultation vs referral breakdown by month
Referral Hospital Distribution
YTD 2025 referral volumes
Consultations
15,428
SSB Hospital
738
PMMP Hospital
248
PIHM Hospital
131
Proxy
61
A&E & Laboratory Analysis
Emergency department and laboratory case volume · 2025
Laboratory Cases
702
YTD total
A&E Cases
648
YTD total
Avg Monthly Lab
58.5
⚠ Card shows 15
Avg Monthly A&E
54
Range: 36–71
Laboratory Monthly Trend
2025 case volume · Peak April (74), trough September (44)
A&E Monthly Trend
2025 case volume · Peak June (71), trough February (36)
Inpatient Activities
Admissions, discharges, occupancy and efficiency metrics · 2025
Overall Admissions
711
YTD total
New Admissions
40
5.6% of total
Discharges
734
+23 vs admissions
Deceased Cases
4
0.56% of admissions
Avg Daily Census
12.3
Patients/day on ward
ALOS
6.1
Average length of stay (days)
Bed Turnover Interval
6.4
⚠ High idle time
Avg Daily Admissions
2.0
Per operating day
Bed Occupancy Rate by Month (%)
Target: 75–85% · Current avg: 49.3%
Monthly Admissions & Discharges
Inpatient activity flow · 2025
Occupancy at a Glance
Monthly bed occupancy — shaded by threshold status
Operating Theatre Productivity
Procedure type distribution and monthly volume · 2025
Total OT Procedures
1,346
Avg 112/month
Local Anesthesia
815
60.55% of OT
General Anesthesia
436
32.39% of OT
Emergency Cases
49
3.64% — low unplanned load
LA / Sedations
37
2.75% of total
OT @HDU + @JPMC
9
Cross-facility procedures
Monthly OT Procedures
All procedure types · Jan–Dec 2025
Procedure Type Breakdown
Share of total OT activity
Local Anaesthesia815 · 60.55%
General Anaesthesia436 · 32.39%
Emergency Cases49 · 3.64%
LA / Sedation37 · 2.75%
OT @ HDU7 · 0.52%
OT @ JPMC2 · 0.15%
Implantology & Aesthetic Services
Case volume, monthly trend and distribution · 2025
Total Implant Cases
869
True avg: 72.4/month
Total Aesthetics Visits
295
True avg: 24.6/month
Dashboard Avg (Implants)
18
⚠ Incorrect measure
Dashboard Avg (Aesthetic)
3
⚠ Incorrect measure
Implantology Monthly Trend
Peaks: Feb & May (125 each) · Trough: Aug (21)
Aesthetic Clinic Monthly Trend
Peaks: May–Jun · Trough: Oct (11)
Hair Transplant Performance
Service breakdown: consultations, PRP therapy, and surgical cases · 2025
Overall Services
109
All visit types
Total Consultations
32
29.4% of services
PRP Sessions
71
65.1% of services
Actual Transplants
2
6.25% conversion
Reviews Done
4
Post-procedure follow-up
Monthly Avg Services
9.1
Very low throughput
Consultations & PRP Sessions by Month
Jan–Dec 2025 · Service gap visible mid-year
Service Funnel
Consultation → PRP → Transplant conversion
Overall Services
109
100%
↓
Consultations
32
29.4%
↓
PRP Sessions
71
65.1%
↓
Surgical Transplants
2
6.25% of consults
Insights & Strategic Flags
Critical findings, data quality issues and recommendations · 2025
Critical Flags
3
Immediate action required
Data Quality Issues
2
DAX measure fixes needed
Operational Wins
4
Strong performers
Monitoring Items
5
Watch closely
🚨 Critical Flags — Immediate Action
Issues requiring leadership attention
#1 · Bed Occupancy at 49.3%
Annual average is 26–36 percentage points below the recommended 75–85% efficiency threshold. Troughs in Aug–Sep at 42%. Immediate bed capacity review and admissions strategy required.
#2 · Hair Transplant — 2 Procedures in 12 Months
The service delivered only 2 surgical transplants YTD. Operating primarily as a PRP clinic at 9 visits/month. Strategic decision needed: invest to scale, reposition, or decommission.
#3 · Implantology August Collapse (21 Cases)
August dropped 71% from the 72-case monthly average. This is the sharpest single-service volume drop in the dataset. Root cause (staff leave, scheduling, equipment) must be identified.
⚠️ Data Quality Issues
Metrics requiring DAX/measure correction
Average Monthly KPI Cards — Implantology Page
Cards show: Avg Monthly Implants = 18, Avg Monthly Aesthetics = 3.Actual values: 869÷12 = 72.4 and 295÷12 = 24.6. Cards likely calculating per-doctor averages without labelling it as such. Fix DAX measures or relabel.
Lab Utilisation vs OPD Volume
702 lab cases for 16,606 OPD visits = 4.2% test ordering rate. Either lab scope is narrow, tests are externally referred, or data capture is incomplete. Verify lab activity scope with department head.
New vs Overall Admissions Gap
711 Overall Admissions vs only 40 New Admissions. Requires definition clarification — either the metric is counting first-ever visits (very narrow) or re-admission rates are unusually high and need clinical audit.
✅ Operational Strengths
Areas performing well
OT Volume Consistency — 1,346 procedures with low month-to-month variance (91–135). Stable scheduling discipline.
Strong Referral Network — SSB (738) + PMMP (248) + PIHM (131) = 1,117 referral visits from 3 government hospitals. Robust pipeline.
High Outpatient Volume — 16,606 visits at a consistent average of 1,384/month indicates sustained patient demand.
Low Emergency OT Rate — Only 3.64% emergency cases implies strong elective planning and minimal unplanned surgical load.
📊 Top Recommended KPIs to Add
Currently missing — would improve decision-making
OT Utilisation Rate (%)Theatre efficiency
Revenue per EncounterFinancial KPI
New vs Return Patient RatioGrowth signal
Referral Conversion RateFunnel efficiency
DNA / Cancellation RateWaste metric
30-Day Readmission RateQuality indicator
Case Mix Index (CMI)Clinical complexity