Pulse of Performance: A Comprehensive KPI Dashboard for Massachusetts General Hospital

Tools used in this project
Pulse of Performance: A Comprehensive KPI Dashboard for Massachusetts General Hospital

Power BI Dashboard

About this project

The primary goal was to create an interactive KPI dashboard that provides a high-level overview of Massachusetts General Hospital's recent performance. This dashboard aims to offer the executive team a quick and comprehensive understanding of key metrics such as patient admissions, readmissions, average length of stay, costs, and insurance coverage.

Business Needs

The business needs for this project included:

  1. Performance Monitoring: Track and visualize key performance indicators (KPIs) to monitor hospital efficiency and patient outcomes.
  2. Data-Driven Decisions: Provide insights that help executives make informed decisions to improve operational efficiency and patient care.
  3. Trend Analysis: Identify trends over time in patient admissions, readmissions, and costs to optimize resource allocation.
  4. Financial Oversight: Understand the financial impact of procedures and patient care to manage costs and enhance revenue streams.
  5. Insurance Coverage Analysis: Evaluate the extent of insurance coverage for procedures to ensure financial sustainability and patient affordability.

Discovering and Presenting Meaningful Insights

To discover and present meaningful insights, the following steps were taken:

  • Data Collection and Preparation: Collected synthetic data on approximately 1,000 patients from 2011-2022, including demographics, insurance coverage, and medical encounters & procedures.

  • Data Analysis:

    1. Admissions and Readmissions: Analyzed the number of patients admitted and readmitted over time to understand patient flow and identify potential issues in patient care.
    2. Average Length of Stay: Calculated the average length of hospital stays to assess efficiency and patient turnover.
    3. Cost Analysis: Determined the average cost per visit to manage and control hospital expenditures.
    4. Insurance Coverage: Evaluated how many procedures are covered by insurance to ensure financial viability and patient support.

Additional project images

Discussion and feedback(3 comments)
Osaid Hashmi
Osaid Hashmi
9 days ago
Hi Harshvardhan. Nice work! I agree that the Number of Admissions will be much less than Number of Encounters, however, could you please tell me the logic of knowing if a certain encounter is an admission? Are you looking at the word "Admission" in the description of the encounter or you are using some other criteria? Also, what is the criterion you are using for the Readmission, i.e., when do you consider a patient to be readmitted?
2000 characters remaining