Massachusetts General Hospital KPI Dashboard

Project Goals:

The goal of this project is to create a high-level KPI report for the executive team at Massachusetts General Hospital (MGH). The report is designed to provide stakeholders with visibility into the hospital's recent performance and to answer key questions about the hospital's operations and performance.

Business Needs:

• Monitor the number of patients admitted or readmitted over time.
• Measure the average length of stay for patients in the hospital.
• Calculate the average cost per patient visit.
• Determine how many procedures are covered by insurance.

Dashboard Overview

1. KPI (Bar Charts per Month)

• Patient Visits: Shows the number of patient visits each month.
• Admission Rate: Displays the monthly admission rate percentage.
• Avg. Stay Duration (hours): Tracks the average duration of patient stays each month.
• Avg. Cost per Patient: Visualizes the average cost per patient visit each month.
• Covered by Insurance: Indicates the number of visits covered by insurance each month.

2. Encounters

• No. of Patients: Bar chart showing the number of patients by encounter type.
• Avg. Stay Duration: Bar chart depicting the average stay duration by encounter type.
• Avg. Cost per Patient: Bar chart illustrating the average cost per patient by encounter type.

3. Operational

• Daily Patients Flow: Bar chart displaying the daily patient flow across the week.

4. Patient Demographics

• Patients by Age (Bins): Bar chart showing patient distribution across different age groups.
• Patients by Gender: Pie chart illustrating the gender distribution of patients.

5. Insurance

• No. of Patients: Bar chart showing the number of patients by insurance provider.
• % Covered and Not Covered: Pie chart displaying the percentage of patients covered and not covered by insurance.