A data-driven exploration of Polycystic Ovary Syndrome (PCOS) built as a professional analytics dashboard. The project uncovers relationships between lifestyle, hormonal health, reproductive patterns, and wellness among 541 patients. It is designed for clinical insight and portfolio presentation.
- Excel (Pivot Tables, Charts, Dashboard Layout)
- Power Query (Data cleaning & preprocessing)
- Power Pivot (Data modeling)
- Slicers & Interactivity (Quarter / Month filters)
The dashboard summarizes patient demographics and overall PCOS distribution.
Highlights:
- Total Patients: 541
- PCOS Prevalence: 32.72%
- Average BMI: 24
- Most Affected Age Group: 25–29 years
- Most Common Symptom: Pimples
Insights:
- Majority of PCOS cases occur between ages 25–29.
- BMI is consistent across ages, with overweight and healthy categories dominating.
- Lifestyle factors such as no exercise and fast-food consumption show strong correlation with PCOS incidence.
This section focuses on the hormonal and metabolic indicators contributing to PCOS.
Key Findings:
- Average TSH: 3 mIU/L
- Average AMH: 6 ng/mL
- Glucose Risk: 98.71%
- Diabetes Prevalence: 98.34%
- Hormonal Imbalance: 57.67%
PCOS patients demonstrate higher AMH (7.84 ng/mL) and prolactin (24.43 ng/mL) levels than controls. Most patients are thyroid-normal (80%), with smaller shares of hypo- and hyperthyroid conditions. Metabolic risks highlight the importance of early lifestyle interventions.
Analysis of follicle count, menstrual cycles, and fertility indicators.
Observations:
- Average follicle count: 12.7 (PCOS) vs 8.6 (Control)
- Endometriosis prevalence: 4.9%
- Hormonal imbalance: 57.76%
Irregular or prolonged cycles affect up to 80% of women with PCOS. Fertility impact is evident with higher follicle counts and disrupted ovulation. Endometriosis overlap supports shared inflammatory mechanisms.
The diagnostic module examines visible symptoms, vital signs, and ultrasound patterns.
Metrics:
- Average Pulse: 73 BPM
- Blood Pressure: 73/53 mmHg
- Hypertension Risk: 40% higher
Insights:
- Acne and hair loss severity correlate with androgen excess.
- Ultrasound data show the characteristic string-of-pearls pattern.
- 50–70% of PCOS women are overweight, increasing metabolic risk.
Evaluates exercise habits, diet, and lifestyle correlations with PCOS.
Insights:
- Regular exercise improves insulin sensitivity and ovulation in 50–70% of cases.
- Fast food consumption aligns with increased PCOS and acne risk (60–80%).
- Average waist circumference: ~81 cm, indicating central obesity.
- O+ blood group shows higher association in some studies.
- Pregnancy success is lower naturally (20–40%) but IVF rates reach ~45%.
| Category | Key Insight |
|---|---|
| Demographics | PCOS peaks at 25–29 years; avg. BMI = 24 |
| Hormonal | Elevated AMH, prolactin, and glucose imbalance |
| Reproductive | High follicle counts, irregular cycles, infertility risk |
| Diagnostics | Acne, hair loss, obesity, and metabolic issues |
| Wellness | Exercise and diet majorly influence severity |
The PCOS Dashboard Project integrates data analytics, medical insight, and visualization design to provide a comprehensive view of PCOS factors. Results highlight that PCOS is influenced by metabolic, hormonal, and lifestyle interactions. Promoting consistent exercise and balanced nutrition can significantly reduce its impact.
Created By :- Ashirbad Routray
Completed On :- 25.10.2025