Skip to main content
Data Dare healthcare L2 sticker: the findi360 mascot analysing Inpatient Efficiency and Billing.

DD-HLT-002

Inpatient Efficiency and Billing

Decide whether beds are being used well, which admissions return within a month, and how much of what was billed was actually collected.

  • Healthcare
  • L2 · CSV
  • ~30,000 rows
  • 8 tables
  • 40 questions
Get the data 40 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-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-HLT-002_Data_Dictionary.xlsx 11.3 KB · v1.0
  • Business Introduction PDF DD-HLT-002_Business_Introduction.pdf 613.8 KB · v1.0
  • Relationship Diagram PDF DD-HLT-002_Relationship_Model.pdf 614.2 KB · v1.0
  • Raw fact data DD-HLT-002_FactAdmissions.csv 2 MB · v1.0
  • Dimension / supporting data DD-HLT-002_Dimensions.zip 565.2 KB · 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 Easy Total waiting minutes
  8. Q008 Easy Total completed encounters
  9. Q009 Easy Total completed length-of-stay days
  10. Q010 Easy Top department by encounter volume
  11. Q011 Easy Top department by billed charges
  12. Q012 Easy Top department by direct costs
  13. Q013 Easy Top department by contribution before overhead
  14. Q014 Easy Top department by collections allocated to encounters
  15. Q015 Easy Top department by outstanding balances
  16. Q016 Easy Top department by total waiting minutes
  17. Q017 Medium Monthly trend of encounter volume
  18. Q018 Medium Monthly trend of billed charges
  19. Q019 Medium Monthly trend of direct costs
  20. Q020 Medium Monthly trend of contribution before overhead
  21. Q021 Medium Monthly trend of collections allocated to encounters
  22. Q022 Medium Monthly trend of outstanding balances
  23. Q023 Medium Monthly trend of total waiting minutes
  24. Q024 Medium Monthly trend of completed encounters
  25. Q025 Medium Monthly trend of completed length-of-stay days
  26. Q026 Medium Year-on-year change in encounter volume
  27. Q027 Medium Year-on-year change in billed charges
  28. Q028 Medium Year-on-year change in direct costs
  29. Q029 Medium Year-on-year change in contribution before overhead
  30. Q030 Medium Year-on-year change in collections allocated to encounters
  31. Q031 Medium Year-on-year change in outstanding balances
  32. Q032 Medium Year-on-year change in total waiting minutes
  33. Q033 Medium Year-on-year change in completed encounters
  34. Q034 Medium Year-on-year change in completed length-of-stay days
  35. Q035 Medium Collection rate by month
  36. Q036 Medium Direct cost per encounter by month
  37. Q037 Hard Departments driving change in encounter volume
  38. Q038 Hard Departments driving change in billed charges
  39. Q039 Very Hard Forecast method selection for encounter volume
  40. Q040 Very Hard Forecast method selection for billed charges

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