Healthcare Data Analysis Using SQL

Overview

This project demonstrates how SQL is used to analyze healthcare data — including patients, doctors, appointments, and billing details — to find valuable insights and improve hospital operations.

---

Database Structure

Table	Description
patients	Stores patient details like name, age, gender, city
doctors	Contains doctor details and their department
appointments	Tracks patient visits and assigned doctors
billing	Manages payments, bills, and pending statuses

---

Tools Used

• MySQL
• MySQL Workbench
• GitHub

---

Example SQL Queries

1. Total revenue per doctor — GROUP BY + SUM()
2. Patients with pending payments — JOIN + WHERE
3. Top 5 patients by billing — ORDER BY + LIMIT
4. City-wise revenue — GROUP BY city
5. Rank doctors by appointments — RANK()

---

Key Learnings

• Creating and joining multiple tables
• Using aggregate functions and subqueries
• Applying window functions (RANK, DENSE_RANK, ROW_NUMBER)
• Extracting business insights from real-world hospital data

---

Author

Thiyagesh R S
Aspiring Healthcare Data Analyst
SQL | Python | Power BI
🔗 [LinkedIn](https://www.linkedin.com/in/ thiyagesh26)