This project is a portfolio case study analyzing the relationship between medical, lifestyle, and behavioral factors influencing sleep disorders using MySQL. The study explores how elements like BMI, stress, activity level, smoking, and health checkups correlate with sleep disorders such as Sleep Apnea and Insomnia.
The dataset contains information on 374 patients, compiled from three linked CSV files:
- patients_medical_details.csv Columns: Person ID, Chronic Conditions, Sleep Duration, Stress Level, BMI Category, Systolic BP, Diastolic BP, Heart Rate, Sleep Disorder, Age Group, Sleep Quality, BP Status
- patients_record.csv Columns: Person ID, Gender, Age, Occupation, Last Checkup Date
- patients_lifestyle.csv Columns: Person ID, Smoking Status, Daily Steps, Steps Category, Activity Level
To identify key health and lifestyle factors contributing to sleep disorders and generate data-driven insights using SQL queries, leading to practical recommendations for improving sleep quality.
- Sleep Apnea patients showed Stage 2 Hypertension (138/93); Insomnia patients had Stage 1 (132/87).
- Middle-aged adults (63.6%) form the largest group with sleep disorders.
- Overweight individuals and those with chronic conditions show higher stress and heart rate.
- Non-smokers are more likely to have good sleep quality compared to smokers.
- Moderate activity (6,000–8,000 steps/day) is linked to longer sleep duration.
- Regular health checkups are associated with better sleep outcomes.
- MySQL — data querying and analysis
- Excel / Power BI (optional) — visualization of SQL outputs
- Markdown / Word — documentation and reporting
| Table Name | Description |
|---|---|
| patients_medical_details | Contains medical information and sleep parameters. |
| patients_record | Contains demographic and visit details. |
| patients_lifestyle | Contains lifestyle and activity metrics. |
- SQL Scripts for all analytical queries.
- Case Study Report summarizing insights and recommendations.
- Visual Dashboard (optional) for future Power BI integration.
[Ashirbad Routray]
14.10.2025
Data Analyst | Portfolio Project: Sleep Disorder Case Study