HIM Dashboard – Data analysis and visualization

profilelynda3495
HIMDashboard.xlsx

Sheet1

Western Healthcare System HIM Dashboard - March 202x
Charts Received Scan days Index days Quality Review of Scanning/Indexing Process in Days Analysis Days Delinquency Rate
Community Region Inpatient (IP) Next Day Same day Surgery (SDS)2 days Emergency Department (ED) Next Day IP SDS ED Out-patient (OP) IP SDS ED OP IP SDS ED IP SDS ED
Hospital A 100% 96% 98% 2.0 2.0 2.0 1.0 2.0 1.0 1.0 2.0 11.0 11.0 3.0 3.0 3.0 2.0 5%
Hospital B 100% 100% 100% 1.0 0.0 1.0 2.0 2.0 1.0 2.0 2.0 1.0 1.0 1.0 1.0 2.0 1.0 0%
Hospital C 100% 100% 100% 0.0 1.0 2.0 1.0 3.0 0.0 2.0 0.0 0.0 0.0 0.0 1.0 3.0 1.0 8%
Urban Region
Hospital D 99% 99% 69% 2.0 3.0 1.0 1.0 0.0 1.0 0.0 1.0 55.0 45.0 0.0 4.0 1.0 0.0 12%
Hospital E 96% 97% 77% 0.0 1.0 2.0 3.0 1.0 2.0 1.0 2.0 130.0 130.0 120.0 2.0 32.0 30.0 23%
Hospital F 86% 95% 89% 1.0 2.0 3.0 1.0 2.0 0.0 2.0 2.0 145.0 45.0 32.0 3.0 7.0 4.0 18%
Corporate average 97% 98% 89% 1.0 1.58 1.83 1.5 1.67 0.83 1.33 1.5 57.0 38.67 26.0 2.33 8 6.33 9%
Best Practice Standard 100% 100% 100% 2.0 2.0 1.0 1.0 2.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 2.0 1.0 <15%