Healthcare Analytics | PostgreSQL

Project Overview

SQL-based data analysis project on a relational hospital database of 100+ records spanning 10 hospitals and multiple departments across Indian cities.

Tools Used

• PostgreSQL 18
• pgAdmin / pgSQL query editor

Key Analysis Performed

• Total patients treated across all hospitals
• Top 3 highest-demand departments: Urology (1766), Neurology (1229), ENT (1064)
• Daily average medical expenses per hospital (Fortis Care highest at ₹4,385/day)
• Monthly medical expense trend report (Jan–Dec 2023)
• Patient flow analysis across 10 cities (Jaipur leading at 1,505 patients)
• Longest hospital stay analysis
• Department-level average length of stay

Key Insights

• Urology was the most in-demand department with 1,766 patients
• Fortis Care had the highest daily average expense at ₹4,385.42/day
• Jaipur treated the most patients (1,505) among all cities
• September and November saw the highest monthly medical expenses

File Structure

• hospital_project.sql — all SQL queries (10 analytical questions)
• Screenshots — query results from pgAdmin