DD-HLT-001
Outpatient Service Performance
Decide where waiting time is costing the hospital attendance and revenue, and which departments deserve attention first.
- Healthcare
- L1 · XLSX
- ~10,000 rows
- 5 tables
- 30 questions
Get the data
v1.0 · 4 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-HLT-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-HLT-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-HLT-001_Business_Introduction.pdf
- Raw fact data DD-HLT-001_Hospital.xlsx
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 Easy Top department by contribution before overhead
- Q014 Easy Top department by collections allocated to encounters
- Q015 Easy Top department by outstanding balances
- Q016 Easy Top department by total waiting minutes
- Q017 Easy Top department by completed encounters
- Q018 Easy Top department by completed length-of-stay days
- Q019 Medium Monthly trend of encounter volume
- Q020 Medium Monthly trend of billed charges
- Q021 Medium Monthly trend of direct costs
- Q022 Medium Monthly trend of contribution before overhead
- Q023 Medium Monthly trend of collections allocated to encounters
- Q024 Medium Monthly trend of outstanding balances
- Q025 Medium Monthly trend of total waiting minutes
- Q026 Medium Monthly trend of completed encounters
- Q027 Medium Monthly trend of completed length-of-stay days
- Q028 Hard Departments driving change in encounter volume
- Q029 Hard Departments driving change in billed charges
- Q030 Very Hard Forecast method selection for encounter volume
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.