Home
/
Provider Analytics
/
Mission 21
caseSQL
Provider Analytics Path · Mission 21 of 30
Expert
Readmission cohort deep dive
Use CTEs and self-joins for CMS-style readmission methodology
Unlock with Pro
→
Back to Provider Analytics
The Brief
You'll practice
CTE
Self-join
Date window
← Previous
Mission 20
Next →
Mission 22
All 30 missions in Provider Analytics Path
↓
1.
Meet the patients
2.
How many departments do we have?
3.
Total encounter volume
4.
Encounters by department
5.
Insurance mix
6.
Who's currently admitted?
7.
Top 10 diagnoses
8.
ED wait time overview
9.
Departments with no encounters
10.
Provider roster with red flags
11.
Average length of stay by department
12.
ED throughput — the real numbers
13.
Readmission rate by insurance type
14.
Duplicate patient audit
15.
Patient age at admission
16.
Rank specialties by encounter volume
17.
ED wait times by day of week
18.
Month-over-month encounter trend
19.
Department utilization rates
20.
Provider complication rates
21.
Readmission cohort deep dive
22.
Patient satisfaction trend with moving average
23.
Top diagnoses year-over-year
24.
Department scorecard
25.
The CMS Quality Dashboard
26.
Inpatient cohort returns matrix
27.
Length-of-stay quartiles by department
28.
HRRP-style readmission penalty exposure
29.
Patient satisfaction × readmission gap by department
30.
Hospital year-end capstone — board quality dashboard