✚
Surgeon Clinic

KPI Command Center

Live
—
🟢 On Track
—
meeting target
🟡 Watch
—
drifting
🔴 Critical
—
needs action
◆ Total KPIs
—
tracked live

Key Performance Indicators

Tap any card for its 30-day trend

💰 Financial Performance

Last 30 days · profit = collected − supply cost

🧑‍⚕️ Surgeon & Procedure Performance

Last 30 days

✅ Action Center

What needs attention today

🔎 Insights & Root Causes

Last 30 days

🏥 OR Session

One row per operating-theatre block. Feeds → OR Utilization, Case Volume, Cancellation Rate.

Block time booked (480 = 8 hrs)
Time theatre was in use

Just added

Nothing added yet this session.

🔪 Surgical Case

The core patient record. Feeds → Case Volume, Scheduling Lag, Pre-Op Clearance, Revenue / Procedure, Supply Cost, Consent Conversion.

Most KPIs count "completed"
→ scheduling lag
→ clearance & consent
Reporting window keys off this

Just added

Nothing added yet this session.

🩺 Post-Op Outcome

Recovery result linked to a case. Feeds → Complication Rate, SSI Rate, Readmission Rate.

Pick the case this belongs to

Just added

Nothing added yet this session.

📅 Follow-Up Visit

A scheduled post-op review. Feeds → Follow-Up Compliance.

Just added

Nothing added yet this session.

🧑‍🤝‍🧑 OPD Visit

One row per outpatient visit. Feeds → OPD Volume, Wait Time, Consult Time, Retention, Revenue / Visit, Collection Rate.

Arrival → seen by doctor
→ retention

Just added

Nothing added yet this session.

📅 Appointment

Booked appointment and its outcome. Feeds → No-Show Rate.

No-show rate counts attended + no_show

Just added

Nothing added yet this session.

🩺 Doctor Session

A doctor's rostered clinic block. Feeds → Doctor / Room Utilization.

Hours rostered (480 = 8 hrs)
Time actually consulting

Just added

Nothing added yet this session.

🧪 Lab Order

A diagnostic order and when it was reported. Feeds → Lab & Diagnostic Turnaround.

Leave blank if pending

Just added

Nothing added yet this session.

💊 Pharmacy Order

Items requested vs dispensed. Feeds → Pharmacy Fulfillment Rate.

Just added

Nothing added yet this session.

↗️ Referral

An onward referral and whether it converted. Feeds → Referral Conversion Rate.

Just added

Nothing added yet this session.

⭐ Patient Feedback

A patient satisfaction rating. Feeds → Patient Satisfaction (CSAT).

CSAT counts 4-5 as satisfied

Just added

Nothing added yet this session.

Database Browser

The raw records behind every KPI

📖 How to use this dashboard

A plain-language walkthrough for the clinic team. If you can use a web browser, you can use this — no technical knowledge needed.

📥 Download printable guide (Word)

🚦 What the colours mean

Every KPI gets a traffic-light status:

🟢 Green — meeting target, on track
🟡 Yellow — drifting, keep an eye on it
🔴 Red — off target, needs action now

Each card also shows a mini trend line, the change versus last period, and its target. Click any card to open its 30-day trend chart.

🗺️ The tabs at a glance

📊 Overview
Headline scoreboard — all 12 KPIs, trends and safety streaks.
💰 Financials
Profit per procedure, revenue per OR hour, idle-time cost, projection.
🧑‍⚕️ Performance
Scorecards by surgeon, procedure and OR room.
✅ Action Center
Your to-do list — follow-ups, upcoming surgeries, reviews.
🔎 Insights
The "why" — cancellation reasons and the consent funnel.
➕ Data Entry
Four simple forms to add your records.
🗄️ Database
Browse the raw records behind any KPI.

⏱️ Your 5-minute daily routine

  1. Open the Overview tab and note any 🔴 red or 🟡 yellow cards.
  2. Go to the Action Center and work the four lists — call overdue follow-ups, confirm upcoming surgeries, chase pending pre-op clearances, review flagged recovery cases.
  3. As surgeries and outcomes happen, record them in Data Entry.
  4. At day's end, click 🔄 Recompute KPIs so the dashboard reflects the day's work.

🔪 Adding a surgical case

  1. Open ➕ Data Entry → Surgical Case.
  2. Enter the patient ID and choose the status (usually completed).
  3. Fill in procedure, surgeon, and the key dates (decided, booked, cleared, surgery).
  4. Enter the amount collected and the supply/implant cost — this powers the money views.
  5. Press Save Surgical Case. A green ✓ confirms it.

🩺 Recording outcomes & follow-ups

  1. Open Post-Op Outcome and pick the case from the dropdown.
  2. Use the toggles to flag any complication, infection or readmission.
  3. For follow-ups, open Follow-Up Visit, pick the case, and mark whether the patient attended.
  4. Save — these feed your safety and follow-up KPIs.

❓ Common questions

The numbers all show zero — is it broken?
No. The KPIs look at the last 7 days. If there are no recent cases, there's nothing to count — add this week's data and click Recompute KPIs.
Do I need to press anything to update?
The Overview refreshes itself every minute. After entering new data, click 🔄 Recompute KPIs to fold it in.
Is the clinic's data private?
Yes — the site needs the username and password and runs over a secure (https) connection. Don't share the password outside the team.
Can I see the records behind a number?
Open the Database tab, pick the KPI from the dropdown, and you'll see the exact rows that built it.