HIM Dashboard – Data analysis and visualization

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%
	Charts Received			Scan days				Index days				Quality Review of Scanning/Indexing process n			Analysis Days			Delinquency Rate
	IP	SDS	ED	IP	SDS	ED	OP	IP	SDS	ED	OP	IP	SDS	ED	IP	SDS	ED
Hospital D	99%	99%	69%	2.00	3.0	1.00	1.00	0.00	1.00	0.00	1.00	55.00	45.00	0.00	4.00	1.00	0.00	12%
Corporate average	97%	98%	89%	1.00	1.58	1.83	1.50	1.67	0.83	1.33	1.50	57.00	38.67	26.00	2.33	8.00	6.33	9%
Best Practice Standard	100%	100%	100%	2.00	2.00	1.00	1.00	2.00	1.00	1.00	1.00	1.00	1.00	1.00	2.00	2.00	1.00	<15%
								Scan days
									IP	SDS	ED	OP
								Hospital D	2.00	3.0	1.00	1.00
								Corporate average	1.00	1.58	1.83	1.50
								Best Practice Standard	2.00	2.00	1.00	1.00
								Index days
									IP	SDS	ED	OP
								Hospital D	0.00	1.00	0.00	1.00
								Corporate average	1.67	0.83	1.33	1.50
								Best Practice Standard	2.00	1.00	1.00	1.00
								Review of scanning/Indexing process in
									IP	SDS	ED
								Hospital D	55.00	45.00	0.00
								Corporate average	57.00	38.67	26.00
								Best Practice Standard	1.00	1.00	1.00
								Analysis Days
									IP	SDS	ED
								Hospital D	4.00	1.00	0.00
								Corporate average	2.33	8.00	6.33
								Best Practice Standard	2.00	2.00	1.00
								Delinquency Rate
								Hospital D	12%
								Corporate average	9%
								Best Practice Standard	<15%

Charts Received Charts Received IP Hospital D Corporate average Best Practice Standard 0.99 0.97 1 Charts Received SDS Hospital D Corporate average Best Practice Standard 0.99 0.98 1 Charts Received ED Hospital D Corporate average Best Practice Standard 0.69 0.89 1 Scan days Hospital D IP SDS ED OP 2 3 1 1 Corporate average IP SDS ED OP 1 1.58 1.83 1.5 Best Practice Standard IP SDS ED OP 2 2 1 1 Index days Hospital D IP SDS ED OP 0 1 0 1 Corporate average IP SDS ED OP 1.67 0.83 1.33 1.5 Best Practice Standard IP SDS ED OP 2 1 1 1

Review of scanning/Indexing process

Hospital D IP SDS ED 55 45 0 Corporate average IP SDS ED 57 38.67 26 Best Practice Standard IP SDS ED 1 1 1 Analysis Days Hospital D IP SDS ED 4 1 0 Corporate average IP SDS ED 2.33 8 6.33 Best Practice Standard IP SDS ED 2 2 1