Integrated Delivery Network Process Improvement Simulation ("IDN PI Simulation")

My objective for this AI/demo portfolio is to build a simulated portfolio of performance reports that serves as a small executive analytics suite in which each report answers an actual management question and supports drill-down into the underlying operational problem. Together the reports tell leadership: Are we delivering good care? Are patients moving through the system efficiently? Where is capacity constrained? Are our major service lines performing? And are those operations translating into acceptable financial performance? Jump right to Executive Summary to review how I simulated answering these questions.

Note that this is not simply a dashboard suite, but an integrated IDN performance-management demonstration showing how quality, patient flow, capacity, service-line performance, and financial results interact. I used 36 months of realistic synthetic data and directed AI to build a portfolio to quickly assess whether patients are receiving good care and meeting acceptable operational performance metrics. I manipulated the data to create a degradation story in which orthopedic growth contributes to longer LOS, higher Med/Surg occupancy and ED boarding, greater labor and supply costs, modestly higher readmissions, and margin compression. Data-driven targeted interventions in discharge management, staffing, therapy, capacity management, scheduling, post-acute coordination, and supply costs then produce measurable but gradual recovery. Trends, benchmarks, and drill-downs help distinguish symptoms from likely underlying drivers and demonstrate how leadership can move from identifying a problem to understanding it, intervening, and measuring results.

The underlying data is synthetic and the analytical models intentionally simplify the complexity of real-world IDN operations and regulatory quality measurement; the suite is therefore a management analytics demonstration, not a substitute for validated clinical, financial, or regulatory reporting. The portfolio was built using a synthetic EHR dataset; see the Data Dictionary for what's Synthea-derived vs. synthetically augmented vs. calculated. As we in healthcare often face, data gaps required me pivot and recalibrate - I try to call out those challenges in the resulting reports and analysis.

No doubt your healthcare system has far more sophisticated tools, processes and metrics specifically designed to support performance and financial improvement. My personal objective was to simply understand how AI might be used to accelerate the development of applications which supplement or enhance the data and insight available to leaders tasked to manage improvement. This analytics suite just "scratches the surface" - see Future Enhancements for just a few ideas related to how to enhance this simulation.

Development notes

Built with Python/Flask, server-rendered Jinja2 templates, and SQLite - no ORM, no client-side framework; Chart.js (via CDN) for charts. The synthetic EHR population is generated with Synthea (an open-source patient simulator), then run through a custom Python pipeline that synthesizes the operational and financial layers Synthea doesn't model - bed capacity, staffing, financial transactions, ED events (see the Data Dictionary for exactly what's Synthea-derived vs. synthetically augmented vs. calculated). Three design decisions carry through the whole suite: the Management Analysis page's engine is deterministic and rule-based, never a live AI/LLM call, so every finding traces to a specific threshold and number, reproducibly; the underlying story is built bottom-up from individual encounter-level changes that aggregate into system trends, not top-down KPI manipulation; and findings below a minimum sample-size bar are explicitly labeled and excluded from conclusions rather than shown with false precision. The committed population (~1,700 patients) was deliberately sized to keep the database file small enough to commit to a public code repository - see Management Analysis's Future Enhancements section for what a larger dataset would unlock.

Operating Margin
8.2%
Target: 4.0% Prior yr: 1.7% Variance: +4.2% ▲
Med/Surg Occupancy
42.0%
Target: 85.0% Prior yr: 56.3% Variance: -43.0% ▼
Median ED Boarding Time
51 min
Target: 90 min Prior yr: 60 min Variance: -39 min ▼
30-Day Readmission Rate
0.0%
Target: 12.0% Prior yr: 0.0% Variance: -12.0% –
LOS Index (observed / expected)
0.85
Target: 1.00 Prior yr: 0.90 Variance: -0.15 ▼
Agency Labor % of Total Labor
3.4%
Target: 3.0% Prior yr: 6.1% Variance: +0.4% ▼

System Operating Margin

Med/Surg Occupancy by Hospital

Trailing 3-month average.