🏥 Healthcare Management SQL Project

An end-to-end SQL project demonstrating database setup, data cleaning, exploratory data analysis (EDA), business analysis, and advanced SQL concepts using MySQL.

---

📌 Project Overview

This project analyzes a healthcare dataset to extract meaningful business insights using SQL. It covers the complete SQL workflow from database creation to advanced querying techniques.

---

🛠️ Technologies Used

• MySQL 8.0
• MySQL Workbench
• SQL
• Git & GitHub

---

📂 Project Structure

Healthcare-Management-SQL-Project/
│
├── README.md
├── 01_Dataset/
│   └── healthcare_dataset.csv
│
├── 02_SQL_Scripts/
│   ├── 01_database_setup.sql
│   ├── 02_data_cleaning.sql
│   ├── 03_exploratory_data_analysis.sql
│   ├── 04_business_analysis.sql
│   └── 05_advanced_sql.sql
│
└── 03_Images/
    ├── 00_database_table_preview.png
    ├── 01_total_patients.png
    ├── 02_gender_distribution.png
    ├── 03_top_hospitals_revenue.png
    ├── 04_highest_billing_patients.png
    ├── 05_revenue_by_medical_condition.png
    ├── 06_highest_billing_patients_per_hospital.png
    ├── 07_billing_category_case_statement.png
    └── 08_hospital_revenue_view.png

---

📊 Dataset Information

The dataset contains healthcare-related records including:

• Patient Information
• Age & Gender
• Blood Type
• Medical Condition
• Hospital
• Doctor
• Insurance Provider
• Billing Amount
• Admission Type
• Room Number
• Medication
• Test Results

---

🔍 SQL Concepts Covered

Database Setup

• CREATE DATABASE
• CREATE TABLE
• Import CSV Data

Data Cleaning

• Duplicate Detection
• NULL Value Checking
• Data Validation

Exploratory Data Analysis

• Total Patients
• Gender Distribution
• Age Analysis
• Medical Condition Distribution

Business Analysis

• Top Hospitals by Revenue
• Highest Billing Patients
• Revenue by Medical Condition
• Insurance Provider Analysis

Advanced SQL

• CASE Statements
• Common Table Expressions (CTE)
• Window Functions
• ROW_NUMBER()
• Views
• Aggregations

---

📈 Key Insights

• Total number of patients in the dataset
• Gender distribution analysis
• Top revenue-generating hospitals
• Highest billing patients
• Revenue generated by each medical condition
• Highest billing patient from every hospital using CTE
• Patient billing categorization using CASE statement
• Hospital revenue summarized using SQL Views

---

📸 Project Screenshots

Database Table Preview

---

Total Patients

---

Gender Distribution

---

Top Hospitals by Revenue

---

Highest Billing Patients

---

Revenue by Medical Condition

---

Highest Billing Patient per Hospital (CTE)

---

Billing Category using CASE Statement

---

Hospital Revenue View

---

🚀 How to Run

1. Clone this repository.
2. Open MySQL Workbench.
3. Create the database.
4. Import the dataset from the 01_Dataset folder.
5. Execute the SQL scripts in the following order:
   • 01_database_setup.sql
   • 02_data_cleaning.sql
   • 03_exploratory_data_analysis.sql
   • 04_business_analysis.sql
   • 05_advanced_sql.sql

---

🎯 Skills Demonstrated

• SQL
• Data Cleaning
• Data Analysis
• Business Analysis
• Window Functions
• CTEs
• Views
• CASE Statements
• Aggregate Functions
• Git & GitHub

---

👨‍💻 Author

Sai Teja

GitHub: https://github.com/SaiTeja13-max

---

⭐ If you found this project useful, consider giving it a star!