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. Q022 Hard Departments driving change in encounter volume
  2. Q023 Hard Departments driving change in billed charges
  3. Q024 Hard Departments driving change in direct costs
  4. Q025 Hard Departments driving change in contribution before overhead
  5. Q026 Hard Departments driving change in collections allocated to encounters
  6. Q027 Hard Departments driving change in outstanding balances
  7. Q028 Hard Departments driving change in total waiting minutes
  8. Q029 Hard Departments driving change in completed encounters
  9. Q030 Hard Departments driving change in completed length-of-stay days
  10. Q031 Hard Departments explaining 80% of growth in encounter volume
  11. Q032 Hard Departments explaining 80% of growth in billed charges
  12. Q033 Hard Departments explaining 80% of growth in direct costs
  13. Q034 Hard Departments explaining 80% of growth in contribution before overhead
  14. Q035 Hard Departments explaining 80% of growth in collections allocated to encounters
  15. Q036 Hard Departments explaining 80% of growth in outstanding balances
  16. Q037 Hard Departments explaining 80% of growth in total waiting minutes
  17. Q038 Hard Encounter slot utilisation by hospital
  18. 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.

Create a free account Sign in