🏥 Hospital Data Analysis Using PostgreSQL

📍 Project Overview

This project explores a Hospital Management Dataset using PostgreSQL, extracting key insights related to patient admissions, hospital expenses, and department performance.

📂 Dataset & Import Process

Tables Used:

1. Hospitals 🏥 (Hospital details, medical expenses, patients count)
2. Admissions 🏥📅 (Admission & discharge data)
3. Departments 🏥📊 (Department-specific statistics)

Key Objectives:

✅ Analyze total patients, doctors, and medical expenses across hospitals
✅ Identify busiest departments and hospitals with high expenses
✅ Calculate average length of stay per department
✅ Generate monthly medical expense reports