📌 Project Overview

This project provides a comprehensive analysis of Obsessive-Compulsive Disorder (OCD) patient data, leveraging SQL, Excel, and Tableau to extract meaningful insights. The goal is to assist mental health professionals, researchers, and policymakers in understanding OCD trends, demographics, and symptom severity across different populations.

🔍 Key Objectives

✅ Clean, preprocess, and analyze OCD patient data using SQL
✅ Perform feature engineering to extract valuable insights
✅ Develop an interactive Tableau dashboard for stakeholders
✅ Identify *key trends

📌 Explore the interactive dashboard?
🔗 View it on Tableau Public

---

📂 Dataset Overview

The dataset, OCD Patient Dataset: Demographics & Clinical Data, contains 1,500 records and includes:

🔹 Demographic Data: Age, gender, ethnicity, marital status, education level
🔹 Clinical Information: OCD diagnosis date, duration of symptoms, psychiatric history
🔹 OCD Symptoms: Categorized into obsession and compulsion types
🔹 Severity Scoring: Measured via Yale-Brown Obsessive-Compulsive Scale (Y-BOCS)
🔹 Mental Health Comorbidities: Depression, anxiety, other diagnoses
🔹 Treatment & Medications: Prescription history and family medical background

📌 Dataset Source:
🔗 OCD Patient Dataset on Kaggle

---

🛠 Technical Implementation

1️⃣ Data Cleaning & Preprocessing (SQL & Excel)

✔ Removed missing values & handled inconsistencies
✔ Standardized date formats and categorical data
✔ Created new features for in-depth analysis

2️⃣ Data Analysis (SQL)

✔ Segmented patients based on age, gender, and ethnicity
✔ Examined OCD severity levels across different groups
✔ Identified correlations between medication use and symptom severity

3️⃣ Visualization (Tableau)

✔ Developed an interactive dashboard with key insights
✔ Created filters for demographic trends, diagnosis history, and OCD symptom types
✔ Enabled dynamic insights for mental health professionals & researchers

---

🔥 Key Insights & Findings

📌 Gender Distribution: OCD prevalence is almost equally distributed between males (753) and females (747)
📌 Ethnicity Breakdown: Caucasians have the highest diagnosis rate, followed by Hispanic, Asian, and African groups
📌 Most Common OCD Symptoms: Checking, washing, and ordering are the most reported compulsions
📌 Comorbid Mental Health Conditions: Depression and anxiety frequently co-occur with OCD
📌 Medication Impact: Patients on SSRI medications show lower symptom severity over time

---