Skip to main content
DD-HLT-004 Hospital Network Performance and Capacity Planning Get the data →
DD-HLT-004-Q047 Very Hard Time series

Rate and mix decomposition of completed length-of-stay days

Decompose the change in completed length-of-stay days per encounter between the latest two years into within-department rate and department-mix effects. Retain departments with encounters in both years. Use prior-year shares for the rate effect and latest-year rates for the mix effect; reconcile both effects to the overall rate change.
Expected
Department rates and encounter shares for both years, rate effect, mix effect, reconciliation · Forecast comparison
Tables
FactHospitalEncounters, DimDepartment, DimDate · columns
  • FactHospitalEncounters
  • DimDepartment
  • DimDate
  • LengthOfStayDays
  • DepartmentID
  • EncounterID
  • AdmissionDateKey
  • YearMonth

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.