Massachusetts General Hospital - Performance Overview

:Objective

As part of the Maven Hospital Challenge, the goal was to develop a comprehensive KPI dashboard for Massachusetts General Hospital (MGH). The executive team required a high-level report to provide insights into recent hospital performance based on a sample of patient records

:Business Needs

Visibility into Patient Admissions

Analysis of Stay Duration

Cost Management

Insurance Coverage Insight

:Key Insights Provided

- The dashboard highlights patient admission trends over time, helping to identify seasonal patterns or shifts in patient volumes

- A map displays where patients are coming from, revealing the hospital's reach and the regions it most frequently serves

- Distribution of costs by encounter class helps to understand which types of visits or treatments are most financially significant

- A treemap shows the top reasons for hospital visits, providing insights into prevalent health issues and operational focus areas

- A bar chart outlines the age and gender distribution of patients, offering a demographic perspective on hospital services