Skip to main content
Data Dare healthcare L4 sticker: the findi360 mascot analysing Hospital Network Performance and Capacity Planning.

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 60 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-HLT-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-HLT-004_Data_Dictionary.xlsx 13.8 KB · v1.0
  • Business Introduction PDF DD-HLT-004_Business_Introduction.pdf 614.1 KB · v1.0
  • Relationship Diagram PDF DD-HLT-004_Relationship_Model.pdf 617.5 KB · v1.0
  • Raw fact data DD-HLT-004_FactHospitalEncounters.parquet 148.3 MB · v1.0
  • Dimension / supporting data DD-HLT-004_Supporting_Tables.zip 156.9 MB · v1.0

Questions

Open one to discuss it
  1. Q040 Very Hard Forecast method selection for encounter volume
  2. Q041 Very Hard Forecast method selection for billed charges
  3. Q042 Very Hard Forecast method selection for direct costs
  4. Q043 Very Hard Forecast method selection for contribution before overhead
  5. Q044 Very Hard Forecast method selection for collections allocated to encounters
  6. Q045 Very Hard Forecast method selection for outstanding balances
  7. Q046 Very Hard Forecast method selection for total waiting minutes
  8. Q047 Very Hard Rate and mix decomposition of completed length-of-stay days
  9. Q048 Very Hard Rate and mix decomposition of billed charges
  10. Q049 Very Hard Rate and mix decomposition of direct costs
  11. Q050 Very Hard Rate and mix decomposition of contribution before overhead
  12. Q051 Very Hard Rate and mix decomposition of collections allocated to encounters
  13. Q052 Very Hard Rate and mix decomposition of outstanding balances
  14. Q053 Very Hard Rate and mix decomposition of total waiting minutes
  15. Q054 Very Hard Outlier months in encounter volume
  16. Q055 Very Hard Outlier months in billed charges
  17. Q056 Very Hard Outlier months in direct costs
  18. Q057 Very Hard Outlier months in contribution before overhead
  19. Q058 Very Hard Contribution gap and cost-reduction target
  20. Q059 Very Hard Planned doctor allocation by hospital
  21. Q060 Very Hard Cost-support pool allocation

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.

Create a free account Sign in