Massachusetts General Hospital KPI Dashboard

Project Goals:

This project aims to make a high-level KPI report for the Massachusetts General Hospital (MGH) leadership team. The report aims to address important queries regarding the hospital's performance and operations while giving stakeholders insight into the hospital's recent performance.

Potential Stakeholders:

• Hospital Administration: CEO, CFO, COO, Directors of various departments (e.g., Surgery, Emergency, Outpatient)
• Healthcare Providers: Insurance Companies, Partner Clinics, and specialist providers.
• Regulatory Bodies: Healthcare Regulatory Bodies, Government Health Departments.

Insights:

1. Overview Page: Shows the Overall Insights found through the analysis at a Glance.

• Total Revenue: $101.52M.
• Average Cost Per Visit: $3.64K.
• Total Insurance: $31.10M.
• Total Patients: 974.
• Readmitted Patients: 854.
• Readmittance Rate: 87.68%.
• Total Procedures: 47,701.
• Claimed Procedures: 24,791.
• Covered Procedures: 73.
• Average Length of Stay: 7.28 hours.
• Average Patient Visits: 28.64.
• Encounters by Location: Boston has the highest number of encounters (15,817), followed by Weymouth (2,000).

2. Admissions Page: Shows the insights through different visuals about the Admissions and Readmissions done over the period.

• Monthly Admissions and Readmissions: Admissions and readmissions peak in February.
• Admissions and Readmissions Over Time: The highest admissions were in 2014, with a significant decline afterward and then again peaked in 2021.
• Admissions by Encounter Class: Most admissions are ambulatory (13K), followed by outpatient (6K).
• Encounters by Gender: 53.51% female, 46.49% male.
• Hourly Trends of Encounters: Encounters peak around noon to early afternoon.

3. Stay Duration Page: Different useful visuals show insights into the Length Of Stay (LOS) of the patients.

• Monthly Average LOS (Hours): December has the highest LOS (22.03 hours).
• Average LOS by Health Reasons: Sepsis (203.25 hours) and COVID-19 (183.35 hours) have the highest LOS.
• Patients with Highest LOS by Health Reasons: Abraham Ruecker has the highest LOS (1272.0 hours) suffering from Primary Small Cell malignant neoplasm of Lung TNM stage 1 (disorder).
• Average LOS by Age Groups and Gender: Middle Age (34.02 hours) has the highest LOS. Males have a higher LOS (8.66 hours) compared to females (6.07 hours).
• Average Length of Stay Over Time: A peak in LOS in 2014 (38.07 hours).

4. Cost Analysis Page: Shows the insights of Claim Cost through useful visuals.

• Monthly Average Claim Cost: The highest claim costs are in August ($4.2K) followed by January, July, and December ($4K each).
• Patients by Cost Range: The majority of patients (15.3K) have claim costs in the $0-$500 range.
• Total Claim Cost by Health Reasons - Top 10: The highest total claim cost is for normal pregnancy ($20.9M) followed by COVID-19 ($12.3M), malignant neoplasm of breast ($11.6M), and chronic congestive heart failure ($9.3M).
• Total Claim Cost over Time: The peak total claim cost occurred in 2014 ($12.0M) compared to that of in 2011 ($4.4M).

5. Insurance Analysis Page: Shows insights regarding the Insurance trend through useful visuals.

• Hospital Claims by Payer Name: Medicare and Medicaid are the largest payers with $25M and $9M in total claim costs, respectively. Medicare also has the highest payer coverage payment at $19M.
• Top 10 Patients by Insurance Coverage: Out of the Top 10 patients with Insurance Coverage, Eugene Abernathy ($845K) has the highest total claim cost ($63.6M) and patient responsibility payment ($55.1M) too.
• Distribution of Total Hospital Claims: There are notable peaks in claim costs, such as in around 2014 and 2020, which could be due to specific health crises or policy changes. Patient payments remain relatively low compared to the total claim costs and payer coverage.

Notable Insights:

• Apart from the insights stated above, There are significant disparities in the Claim Cost and Payer coverage based on Race and Gender.
• With the Readmittance rate at 87.68%, it can be observed that there is a potential lack of treatment quality and a need for better post-discharge care and follow-up.