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:
- Performance Monitoring: Track and visualize key performance indicators (KPIs) to monitor hospital efficiency and patient outcomes.
- Data-Driven Decisions: Provide insights that help executives make informed decisions to improve operational efficiency and patient care.
- Trend Analysis: Identify trends over time in patient admissions, readmissions, and costs to optimize resource allocation.
- Financial Oversight: Understand the financial impact of procedures and patient care to manage costs and enhance revenue streams.
- 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:
- Admissions and Readmissions: Analyzed the number of patients admitted and readmitted over time to understand patient flow and identify potential issues in patient care.
- Average Length of Stay: Calculated the average length of hospital stays to assess efficiency and patient turnover.
- Cost Analysis: Determined the average cost per visit to manage and control hospital expenditures.
- Insurance Coverage: Evaluated how many procedures are covered by insurance to ensure financial viability and patient support.