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. Q001 Easy Total encounter volume
  2. Q002 Easy Total billed charges
  3. Q003 Easy Total direct costs
  4. Q004 Easy Total contribution before overhead
  5. Q005 Easy Total collections allocated to encounters
  6. Q006 Easy Total outstanding balances
  7. Q007 Medium Monthly trend of encounter volume
  8. Q008 Medium Monthly trend of billed charges
  9. Q009 Medium Monthly trend of direct costs
  10. Q010 Medium Monthly trend of contribution before overhead
  11. Q011 Medium Monthly trend of collections allocated to encounters
  12. Q012 Medium Monthly trend of outstanding balances
  13. Q013 Medium Monthly trend of total waiting minutes
  14. Q014 Medium Monthly trend of completed encounters
  15. Q015 Medium Monthly trend of completed length-of-stay days
  16. Q016 Medium Year-on-year change in encounter volume
  17. Q017 Medium Year-on-year change in billed charges
  18. Q018 Medium Year-on-year change in direct costs
  19. Q019 Medium Year-on-year change in contribution before overhead
  20. Q020 Medium Year-on-year change in collections allocated to encounters
  21. Q021 Medium Year-on-year change in outstanding balances
  22. Q022 Hard Departments driving change in encounter volume
  23. Q023 Hard Departments driving change in billed charges
  24. Q024 Hard Departments driving change in direct costs
  25. Q025 Hard Departments driving change in contribution before overhead
  26. Q026 Hard Departments driving change in collections allocated to encounters
  27. Q027 Hard Departments driving change in outstanding balances
  28. Q028 Hard Departments driving change in total waiting minutes
  29. Q029 Hard Departments driving change in completed encounters
  30. Q030 Hard Departments driving change in completed length-of-stay days
  31. Q031 Hard Departments explaining 80% of growth in encounter volume
  32. Q032 Hard Departments explaining 80% of growth in billed charges
  33. Q033 Hard Departments explaining 80% of growth in direct costs
  34. Q034 Hard Departments explaining 80% of growth in contribution before overhead
  35. Q035 Hard Departments explaining 80% of growth in collections allocated to encounters
  36. Q036 Hard Departments explaining 80% of growth in outstanding balances
  37. Q037 Hard Departments explaining 80% of growth in total waiting minutes
  38. Q038 Hard Encounter slot utilisation by hospital
  39. Q039 Hard Billed charges against budget
  40. Q040 Very Hard Forecast method selection for encounter volume
  41. Q041 Very Hard Forecast method selection for billed charges
  42. Q042 Very Hard Forecast method selection for direct costs
  43. Q043 Very Hard Forecast method selection for contribution before overhead
  44. Q044 Very Hard Forecast method selection for collections allocated to encounters
  45. Q045 Very Hard Forecast method selection for outstanding balances
  46. Q046 Very Hard Forecast method selection for total waiting minutes
  47. Q047 Very Hard Rate and mix decomposition of completed length-of-stay days
  48. Q048 Very Hard Rate and mix decomposition of billed charges
  49. Q049 Very Hard Rate and mix decomposition of direct costs
  50. Q050 Very Hard Rate and mix decomposition of contribution before overhead
  51. Q051 Very Hard Rate and mix decomposition of collections allocated to encounters
  52. Q052 Very Hard Rate and mix decomposition of outstanding balances
  53. Q053 Very Hard Rate and mix decomposition of total waiting minutes
  54. Q054 Very Hard Outlier months in encounter volume
  55. Q055 Very Hard Outlier months in billed charges
  56. Q056 Very Hard Outlier months in direct costs
  57. Q057 Very Hard Outlier months in contribution before overhead
  58. Q058 Very Hard Contribution gap and cost-reduction target
  59. Q059 Very Hard Planned doctor allocation by hospital
  60. 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