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
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-HLT-004_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-HLT-004_Data_Dictionary.xlsx
- Business Introduction PDF DD-HLT-004_Business_Introduction.pdf
- Relationship Diagram PDF DD-HLT-004_Relationship_Model.pdf
- Raw fact data DD-HLT-004_FactHospitalEncounters.parquet
- Dimension / supporting data DD-HLT-004_Supporting_Tables.zip
Questions
Open one to discuss it- Q007 Medium Monthly trend of encounter volume
- Q008 Medium Monthly trend of billed charges
- Q009 Medium Monthly trend of direct costs
- Q010 Medium Monthly trend of contribution before overhead
- Q011 Medium Monthly trend of collections allocated to encounters
- Q012 Medium Monthly trend of outstanding balances
- Q013 Medium Monthly trend of total waiting minutes
- Q014 Medium Monthly trend of completed encounters
- Q015 Medium Monthly trend of completed length-of-stay days
- Q016 Medium Year-on-year change in encounter volume
- Q017 Medium Year-on-year change in billed charges
- Q018 Medium Year-on-year change in direct costs
- Q019 Medium Year-on-year change in contribution before overhead
- Q020 Medium Year-on-year change in collections allocated to encounters
- Q021 Medium Year-on-year change in outstanding balances
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.