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

Planned doctor allocation by hospital

Validate that every doctor allocation sums to 100%, then calculate planned doctor equivalents by hospital from the bridge weights. Reconcile the network total to distinct doctors rather than bridge-row count. Explain why these planned allocations cannot be treated as observed workload shares.
Expected
Doctor allocation checks, hospital equivalents, network reconciliation; lowest ID on ties · Allocation matrix
Tables
FactHospitalEncounters, BridgeDoctorHospital, DimDoctor, DimHospital · columns
  • FactHospitalEncounters
  • BridgeDoctorHospital
  • DimDoctor
  • DimHospital
  • DoctorID
  • HospitalID
  • AllocationWeight

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