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

Departments driving change in contribution before overhead

Which three departments contributed most to the year-over-year change in contribution before overhead in the latest year? Reconcile all department changes to the hospital total, using absolute changes rather than averaging growth rates.
Expected
DepartmentID, prior, latest, absolute change; descending change then ID; reconciliation total · Variance bridge
Tables
FactHospitalEncounters, FactBilling, DimDepartment, DimDate · columns
  • FactHospitalEncounters
  • FactBilling
  • DimDepartment
  • DimDate
  • BilledSAR
  • DirectCostSAR
  • 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.

Create a free account Sign in