Skip to content

Dashboard templates

Healthcare · IT

Clinic or clinic chain whose IT team runs the HIS, booking software, the health insurance (BHYT) gateway connection, network and workstations. Visits, wait times and service revenue, plus incidents, SLA, failed changes, service availability and the estimated visits affected when systems go down.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For clinic IT teams running clinic management software, booking, the insurance portal connection and the network. The "IT and patient reception" dashboard estimates visits affected by IT outages per 1,000 visits, and IT tickets per 1,000 visits. The "IT incidents and support" and "Availability and changes" dashboards cover service availability, MTTR, SLA breaches and change failure rate. Needs location, doctor, visit, service fee, IT service catalog and IT ticket data.

Use this template to

  • Know roughly how many visits one clinic software outage affects.
  • Track insurance portal availability by month.
  • Cut tickets past SLA by work type.

5 ready-made dashboards

IT and patient reception

Estimated visits affected by outages of the HIS, booking software or health insurance gateway, and IT workload relative to visits.

  • Estimated visits affected by IT outages
  • IT-affected visits per 1,000 visits
  • IT tickets per 1,000 visits
  • Visits
  • Affected visits by service
  • Weekly affected visits
  • Weekly IT tickets per 1,000 visits

IT incidents and support

Tickets, P1 incidents, response and resolution times, and SLA breach rate by service and resolver team.

  • Incidents
  • P1 incidents
  • Mean time to resolve (MTTR, hours)
  • SLA breach rate
  • By service
  • SLA breach rate by work type
  • Response time by resolver team
  • Weekly tickets

Availability and changes

Availability, outage time and change failure rate for each IT service.

  • Service availability
  • Outage minutes
  • Changes deployed
  • Change failure rate
  • Availability by service
  • Outage minutes by criticality
  • Weekly outage minutes

Clinic overview

Visits, patients, service revenue and insurance-covered share by facility and specialty.

  • Visits
  • Unique patients
  • Service revenue
  • Revenue per visit
  • Weekly visits by facility
  • Monthly visits by specialty
  • Results by facility
  • Revenue by service group
  • Insurance-covered share by patient type

Appointment operations

No-show rate, cancellations, wait time and doctor productivity by facility, specialty and doctor.

  • Appointments
  • No-show rate
  • Average wait time (minutes)
  • Visits per doctor day
  • No-show rate by facility
  • Average wait time by facility
  • Weekly wait time by facility
  • Productivity by doctor
  • Follow-up visit share by specialty

Ask Si as soon as the build finishes

  • “How did IT-affected visits per 1,000 visits change compared with last month?”
  • “What is driving estimated visits affected by IT outages this quarter?”
  • “Show IT tickets per 1,000 visits by month for the last six months.”
  • “Where is service availability highest this month, and why?”

31 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
IT-affected visits per 1,000 visitsEstimated visits affected by IT outages times 1,000 divided by completed visits in the period.= Estimated visits affected by IT outages * 1000 / VisitsNumber
Estimated visits affected by IT outagesFor each outage: outage minutes (capped at 540, one working day) divided by 540, times completed visits on the day the outage started, times the share of patient check-ins that depend on that service. Summed over all outages in the period.Number
IT tickets per 1,000 visitsIT support tickets opened in the period times 1,000 divided by completed visits; measures IT load relative to patient volume.= IT support tickets * 1000 / VisitsNumber
Service availabilityOne minus outage minutes divided by the service's planned operating minutes in the period.= 1 - Outage minutes / it_planned_minutesRatio (%)
Change failure rateFailed changes (failed or rolled back) divided by changes deployed in the period.= Failed changes / Changes deployedRatio (%)
Changes deployedNumber of IT changes deployed in the period, by deployment date.Count
Failed changesNumber of changes deployed in the period with a failed or rolled-back outcome.Count
Average first response time (hours)Average hours from ticket creation to first response, across all tickets opened in the period.= it_response_hours_total / IT support ticketsNumber
IncidentsNumber of incident-type tickets opened in the period, by open date.Count
Mean time to resolve (MTTR, hours)Average hours from open to resolution for incidents resolved in the period.= it_incident_hours_total / Resolved incidentsNumber
Outage minutesTotal minutes a service was down or disrupted, counted on the day the outage started.Number
P1 incidentsNumber of highest-priority incidents (P1, critical) opened in the period.Count
Resolved incidentsNumber of incidents resolved in the period, by resolution date.Count
SLA breach rateTickets breaching SLA divided by tickets opened in the period.= SLA breaches / IT support ticketsRatio (%)
SLA breachesTickets opened in the period that were resolved after the SLA deadline (resolution hours greater than the SLA target).Count
IT support ticketsNumber of IT support tickets (incidents and requests) opened in the period, by open date.Count
AppointmentsTotal appointments by appointment date, in every status (completed, no-show, cancelled).Count
Average wait time (minutes)Average minutes from check-in to the start of the consultation, over completed visits that have both timestamps.= hc_wait_minutes_total / hc_wait_measured_visitsNumber
Cancellation rateCancelled appointments divided by total appointments.= hc_cancellations / AppointmentsRatio (%)
Insurance-paid amountTotal amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits.Currency
Insurance shareInsurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenueRatio (%)
New patientsDistinct patients with a completed visit of type new (not a follow-up) in the period.Count
No-show rateNo-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows)Ratio (%)
No-showsAppointments with the standard status no_show (the patient did not attend).Count
Patient-paid amountTotal service charges minus the insurance-paid amount, for completed visits.Currency
Follow-up visit shareFollow-up visits divided by completed visits.= hc_return_visits / VisitsRatio (%)
Service revenueTotal service charges of completed visits (insurance portion plus patient portion), by visit date.Currency
Revenue per visitService revenue divided by completed visits.= Service revenue / VisitsCurrency
Unique patientsDistinct patients with at least one completed visit in the period.Count
VisitsAppointments with the standard status completed, by visit date.Count
Visits per doctor dayCompleted visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_daysNumber

Data you need

Required

clinic, doctor, visit, visit_charge, it_service, it_ticket

Add if you have it (unlocks more metrics)

patient, service, it_change, it_outage

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: clinic, doctor, visit, visit_charge, it_service, it_ticket.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 5 dashboards and 31 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Healthcare · IT with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes