DD-HLT-004
Hospital Network Performance and Capacity Planning
Decide where the network is short of capacity, which hospitals run over budget and why, and what next year's demand looks like from the evidence.
- Healthcare
- L4 · PARQUET
- ~6,000,000 rows
- 18 tables
- 60 questions
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-HLT-004_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-HLT-004_Data_Dictionary.xlsx
- Business Introduction PDF DD-HLT-004_Business_Introduction.pdf
- Relationship Diagram PDF DD-HLT-004_Relationship_Model.pdf
- Raw fact data DD-HLT-004_FactHospitalEncounters.parquet
- Dimension / supporting data DD-HLT-004_Supporting_Tables.zip
Questions
Open one to discuss it- Q022 Hard Departments driving change in encounter volume
- Q023 Hard Departments driving change in billed charges
- Q024 Hard Departments driving change in direct costs
- Q025 Hard Departments driving change in contribution before overhead
- Q026 Hard Departments driving change in collections allocated to encounters
- Q027 Hard Departments driving change in outstanding balances
- Q028 Hard Departments driving change in total waiting minutes
- Q029 Hard Departments driving change in completed encounters
- Q030 Hard Departments driving change in completed length-of-stay days
- Q031 Hard Departments explaining 80% of growth in encounter volume
- Q032 Hard Departments explaining 80% of growth in billed charges
- Q033 Hard Departments explaining 80% of growth in direct costs
- Q034 Hard Departments explaining 80% of growth in contribution before overhead
- Q035 Hard Departments explaining 80% of growth in collections allocated to encounters
- Q036 Hard Departments explaining 80% of growth in outstanding balances
- Q037 Hard Departments explaining 80% of growth in total waiting minutes
- Q038 Hard Encounter slot utilisation by hospital
- Q039 Hard Billed charges against budget
General discussion
Anything about this dataset that is not one question — loading the files, which tool, how you set it up.
A free account takes a minute. Your draft is kept while you sign in.