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

Rate and mix decomposition of collections allocated to encounters

Decompose the change in collections allocated to encounters 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
FactBilling, FactHospitalEncounters, DimDepartment, DimDate · columns
  • FactBilling
  • FactHospitalEncounters
  • DimDepartment
  • DimDate
  • CollectedSAR
  • EncounterID
  • DepartmentID
  • 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.