Encounter slot utilisation by hospital
Compare encounter volumes with available encounter slots by hospital and month. Identify the highest utilisation, calculate unused slots, and explain why this does not measure bed occupancy. Resolve ties by earliest month then lowest HospitalID.
- Expected
- Hospital-month encounter count, available slots, utilisation, unused slots · Variance matrix
- Tables
-
FactHospitalEncounters, FactCapacityDaily, DimHospital, DimDate · columns
- Topics
- Capacity & Resources