← Back to selected work
CASE 01 / HEALTHCARE OPERATIONS

Healthcare operations & access intelligence

A portfolio-safe view of how demand, specialty capacity, geography and provider-network behavior can be combined into a decision framework for access and network planning.

Problem spaceAccess · Capacity · Network
RoleClinical + analytical bridge
MethodsOperational analytics
ToolsSQL · BigQuery · Visualization

From fragmented operational signals to a coherent access model.

Access problems are rarely contained in one table or one operational team. Demand may be visible in appointment data, capacity in schedules, geographic friction in provider location, and leakage in external-network behavior. Looking at each signal independently can lead to the wrong intervention.

Problem

Build a view that distinguishes true capacity constraints from distribution, scheduling, geographic or network-design problems — without treating utilization as a single undifferentiated metric.

Approach

Create a shared analytical frame around demand, specialty, unit, geography and owned-versus-external provider behavior. Validate definitions first, preserve comparable time windows, and make uncertainty explicit when the operational sources do not align.

Outputs

Portfolio-safe outputs include access/capacity views, network comparison logic, geographic segmentation, operational bottleneck mapping and executive summaries designed to support prioritization rather than simply describe activity.

Decision principle

The goal is not to prove that owned care is always better. The goal is to identify where the system is constrained, why, and which intervention has a defensible operational rationale.

Limits & governance

This public case intentionally omits patient-level information, proprietary provider details, commercial prices and internal operational thresholds. The portfolio describes the method and decision structure, not confidential company data.

Selected workNext case → Utilization & cost