Provider Analytics Path · Mission 14 of 30Medium

Duplicate patient audit

Use a self-join to find duplicate records sharing the same natural key

Unlock with Pro→Back to Provider Analytics

The Brief

You'll practice

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