Skip to main content
Data Dare healthcare L3 sticker: the findi360 mascot analysing Hospital Revenue Cycle and Service Profitability.

DD-HLT-003

Hospital Revenue Cycle and Service Profitability

Decide which service lines earn their keep, where collections leak between invoice and receipt, and which open cases need chasing.

  • Healthcare
  • L3 · PARQUET
  • ~500,000 rows
  • 12 tables
  • 50 questions

Get the data

v1.0 · 6 files

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

  • Question Book PDF DD-HLT-003_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-HLT-003_Data_Dictionary.xlsx 12.2 KB · v1.0
  • Business Introduction PDF DD-HLT-003_Business_Introduction.pdf 613.9 KB · v1.0
  • Relationship Diagram PDF DD-HLT-003_Relationship_Model.pdf 615.1 KB · v1.0
  • Raw fact data DD-HLT-003_FactHospitalEncounters.parquet 10.7 MB · v1.0
  • Dimension / supporting data DD-HLT-003_Dimensions.zip 13.7 MB · v1.0

Questions

Open one to discuss it
  1. Q031 Hard Departments driving change in encounter volume
  2. Q032 Hard Departments driving change in billed charges
  3. Q033 Hard Departments driving change in direct costs
  4. Q034 Hard Departments driving change in contribution before overhead
  5. Q035 Hard Departments driving change in collections allocated to encounters
  6. Q036 Hard Departments driving change in outstanding balances
  7. Q037 Hard Departments driving change in total waiting minutes
  8. Q038 Hard Departments driving change in completed encounters
  9. Q039 Hard Departments driving change in completed length-of-stay days
  10. Q040 Hard Departments explaining 80% of growth in encounter volume
  11. Q041 Hard Departments explaining 80% of growth in billed charges
  12. Q042 Hard Departments explaining 80% of growth in direct costs

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.