Skip to content

Dashboard templates

Healthcare · Data & analytics

A clinic or clinic chain whose data team loads data from the hospital information system (HIS), lab system (LIS), the health insurance claims portal, the booking app and the pharmacy inventory into the warehouse. A key KPI board (visits, no-shows, revenue per visit, wait time, insurance-covered share) plus pipeline reliability, data quality, analysis requests and dashboard usage.

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

For data teams at clinics and clinic chains loading data from clinic management software, lab systems, the insurance claims portal and booking apps. The "KPI board" dashboard covers visits, no-show rate, revenue per visit, wait time, insurance-paid share and the share of visits with a measured wait time. The "Data reliability" and "Requests and usage" dashboards show which pipelines failed, which tests did not pass and which teams actually look at dashboards. Needs location, doctor, visit, service fee and pipeline run log data.

Use this template to

  • Know whether wait time numbers can be trusted before taking them to each location's meeting.
  • Track how often the insurance portal pipeline fails each month and fix the root cause.
  • See which teams rarely use dashboards, so you can train them or drop unused reports.

3 ready-made dashboards

KPI board

Key clinic metrics next to the reliability of the HIS, LIS and health insurance portal data behind them.

  • Visits
  • No-show rate
  • Service revenue
  • Revenue per visit
  • Average wait time (minutes)
  • Insurance share
  • Visits per doctor day
  • Run success rate
  • Check pass rate
  • Freshness breaches

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did wait time capture rate change compared with last month?”
  • “What is driving departments viewing dashboards this quarter?”
  • “Show average request lead time (days) by month for the last six months.”
  • “Where is average run duration (minutes) highest this month, and why?”

25 defined metrics

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

MetricDefinitionUnit
Wait time capture rateCompleted visits with both check-in time and consultation start time divided by all completed visits. Measures the completeness of the HIS data behind the wait time metric.= hc_wait_measured_visits / VisitsRatio (%)
Departments viewing dashboardsNumber of distinct departments with at least one dashboard view in the period.Count
Average request lead time (days)Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
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
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 (%)
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
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, da_pipeline_run

Add if you have it (unlocks more metrics)

patient, service, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 3 dashboards and 25 metrics; ask Si anytime.

Related templates

Build Healthcare · Data & analytics with your own data

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