Hospital Analysis

As an Analytics Consultant for Massachusetts General Hospital (MGH), I've built a high-level KPI report for the executive team, based on a subset of patient records. The purpose of the report is to give stakeholders visibility into the hospital’s recent performance, and answers the following questions:

• How many patients have been admitted or readmitted over time?
• How long are patients staying in the hospital, on average?
• How much is the average cost per visit?
• How many procedures are covered by insurance?