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 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-HLT-003_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-HLT-003_Data_Dictionary.xlsx
- Business Introduction PDF DD-HLT-003_Business_Introduction.pdf
- Relationship Diagram PDF DD-HLT-003_Relationship_Model.pdf
- Raw fact data DD-HLT-003_FactHospitalEncounters.parquet
- Dimension / supporting data DD-HLT-003_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Total encounter volume
- Q002 Easy Total billed charges
- Q003 Easy Total direct costs
- Q004 Easy Total contribution before overhead
- Q005 Easy Total collections allocated to encounters
- Q006 Easy Total outstanding balances
- Q007 Easy Total waiting minutes
- Q008 Easy Total completed encounters
- Q009 Easy Total completed length-of-stay days
- Q010 Easy Top department by encounter volume
- Q011 Easy Top department by billed charges
- Q012 Easy Top department by direct costs
- Q013 Medium Monthly trend of encounter volume
- Q014 Medium Monthly trend of billed charges
- Q015 Medium Monthly trend of direct costs
- Q016 Medium Monthly trend of contribution before overhead
- Q017 Medium Monthly trend of collections allocated to encounters
- Q018 Medium Monthly trend of outstanding balances
- Q019 Medium Monthly trend of total waiting minutes
- Q020 Medium Monthly trend of completed encounters
- Q021 Medium Monthly trend of completed length-of-stay days
- Q022 Medium Year-on-year change in encounter volume
- Q023 Medium Year-on-year change in billed charges
- Q024 Medium Year-on-year change in direct costs
- Q025 Medium Year-on-year change in contribution before overhead
- Q026 Medium Year-on-year change in collections allocated to encounters
- Q027 Medium Year-on-year change in outstanding balances
- Q028 Medium Year-on-year change in total waiting minutes
- Q029 Medium Year-on-year change in completed encounters
- Q030 Medium Year-on-year change in completed length-of-stay days
- Q031 Hard Departments driving change in encounter volume
- Q032 Hard Departments driving change in billed charges
- Q033 Hard Departments driving change in direct costs
- Q034 Hard Departments driving change in contribution before overhead
- Q035 Hard Departments driving change in collections allocated to encounters
- Q036 Hard Departments driving change in outstanding balances
- Q037 Hard Departments driving change in total waiting minutes
- Q038 Hard Departments driving change in completed encounters
- Q039 Hard Departments driving change in completed length-of-stay days
- Q040 Hard Departments explaining 80% of growth in encounter volume
- Q041 Hard Departments explaining 80% of growth in billed charges
- Q042 Hard Departments explaining 80% of growth in direct costs
- Q043 Very Hard Forecast method selection for encounter volume
- Q044 Very Hard Forecast method selection for billed charges
- Q045 Very Hard Forecast method selection for direct costs
- Q046 Very Hard Forecast method selection for contribution before overhead
- Q047 Very Hard Forecast method selection for collections allocated to encounters
- Q048 Very Hard Forecast method selection for outstanding balances
- Q049 Very Hard Forecast method selection for total waiting minutes
- Q050 Very Hard Rate and mix decomposition of completed length-of-stay days
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.