Hospital Patient Insights – Data Analysis Using Python & SQL

Project Overview

This project focuses on analyzing hospital patient records to extract meaningful insights regarding patient demographics, department workloads, and doctor performance. The goal is to improve hospital management efficiency using data-driven decision-making.

Tools & Technologies Used:

Python (Pandas, Matplotlib, Seaborn) for data cleaning & visualization

SQL for querying and analyzing hospital records

Excel for preprocessing patient data

Power BI for interactive hospital dashboards

Key Insights & Achievements:

Identified most common diagnoses and patient age distribution

Analyzed department workloads to optimize resource allocation

Evaluated doctor performance and suggested workload balancing

Provided recommendations for hospital management improvements