New York Hospital Efficiency Analysis

🏆 1st Place in Best Data Analysis and Special Mention in Best Data Visualization

This project aims to analyze hospital discharge volumes, financial performance, illness severity impacts, and geographic trends to uncover patterns in patient care costs, hospital efficiency, and patient outcomes across New York State from 2009 to 2017, and 2021 🏥.

With over 1.19 million rows and 14 detailed columns, we evaluate key performance indicators across multiple dimensions to identify best practices and uncover the factors that contribute to hospital efficiency.

💡Our primary objective is to uncover actionable insights into hospital performance across New York State by:
1. Analyzing hospital discharge volume trends
2. Examining the relationship between illness severity and healthcare costs
3. Identifying hospitals with exceptional financial performance (both profitable and unprofitable)
4. Mapping geographic differences in patient care and financial metrics
5. Ranking hospitals based on custom metrics such as profitability and complexity handling

🛠 Tools Used:
1. Python for data preparation
2. Tableau for visualization and dashboard building
3. HTML for document analysis report

*This project was created as part of the 6th DubsTech Datathon 2025 (a 28-hour hackathon) at the University of Washington.