Massachusetts General Hospital (MGH) - Our Strength Is Yours...

Project Name : - Massachusetts General Hospital (MGH) - Our Strength Is Yours...

Dashboard Key Requirements :-

1. How many patients have been admitted or readmitted over time?

• Admitted - 1817 , Readmitted - 251

2. How long are patients staying in the hospital, on average?

• 7.25 Hrs.

3. How much is the average cost per visit?

• $3.76K

4. How many procedures are covered by insurance?

• 47

KPI Analysis :-

1. 27891 Patients visited Hospital in the past 11 years.

2. Average duration of stay in Hospital is 7.25 Hrs.

3. Total Cost of medical treatment is $104.75M including Base Cost & Claim Cost.

4. Insurance covered cost was $31.10M.

5. Average cost per visit in hospital is $3.76K including Base Cost & Claim Cost.

6. 3885 (13.93%) is the highest no. of patients visited to Hospital in Year 2014.

7. The Max. Cost (Base Cost & Claim Cost) generated is in Year 2014 i.e. $12.48M.

8. The Max. no. of Patients reported Chronic Congestive Heart Failure as the reason of visiting Hospital which is 1738 (23.91%) & cost (Base Cost & Claim Cost) generated from disease treatment that was $1.17M.

9. The Max. Cost (Base Cost & Claim Cost) generated is from Normal Pregnancy which is $21.11M.

10. 1817 is the No. of Patients Admitted in Hospital.

11. 251 is the No. of Patients Readmitted in Hospital.

12. Max. No. of patients reported Chronic Congestive Heart Failure in Year 2021 which is 352 (43.51%).

13. Max. Cost is generated from the treatment of Normal Pregnancy which is $2668.53K in Year 2014.

14. Max. 44.95% (12,537) patients visited to Hospital under the Ambulatory Encounter Class.

15. Max. Cost(Base Cost & Claim Cost) generated by Ambulatory Encounter Class which is $37.61 M.

16. Max. 2341 (60.41%) patients visited Hospital under the Ambulatory Class in Year 2014.

17. Total Cost (Base Cost & Claim Cost) generated is $6.29M.

18. Only 47 Procedures are covered by Insurance.

19. 294 is the count of Birth Place Town from where the patient belongs.

20. Only 79 persons Birth Place Town is Boston which is max.

21. 974 is the No. of unique Patients visiting to Hospital.

22. 541 Patients are lived in Boston City which is max.

23. 50.719% (494) Patients are Male & 49.28% (480) Patients are Female.

24. 80.39% (793) Patients belongs to Non Hispanic Ethnicity & 19.61% (191) belongs to Hispanic Ethnicity.

25. 80.58% (784) Patients are Married & 19.42% (189) Patients are Unmarried.

26. 69.82% (680) belongs to White Race.

27. 16.74% (163) belongs to Black Race.

28. Max. Patients are belongs to Suffolk County which is 644.

29. No. of Alive Patients are 820.

30. No. of Died Patients are 154.

31. Average Age of Patients is 71.

32. 21.36% (208) are belongs to 81 - 90 Years age group.

33. Average Procedures Duration of Stay of Patients is 0.5558 Hrs.

34. Max. 17.63% (4596) Patients are diagnosed under the Description Procedure Assessment of Health & Social Care & Needs (Procedure).

35. Total Cost (Base Cost & Claim Cost) generated was $1.98M Patients are diagnosed under the Description Procedure Assessment of Health & Social Care & Needs (Procedure).

36. Total 11.38% (2965) Patients are visited in Year 2014 for Procedure Description which is max.

37. Average time spent was 0.4145 Hrs in Year 2011 which is max.