⚓

International Student Wellbeing Analytics: Advanced SQL Portfolio

SQL-Driven Analysis of Mental Health Patterns Among International Students

🚀 Portfolio Impact & Professional Value

Enterprise-Level SQL Capabilities

This project demonstrates SQL expertise aligned with:

Senior Data Analyst roles (healthcare & education sectors)
Business Intelligence Developer positions (student services)
Data Warehouse Engineer roles (educational analytics)
Analytics Engineer & Database Developer opportunities

Quantifiable Technical Achievements

2,500+ Lines of SQL Code – production-scale query repository
25+ Advanced Queries – window functions, recursive CTEs, OLAP analysis
10+ Database Tables – normalized + star schema structures
15+ SQL Functions – analytical, statistical, and business intelligence metrics
6 Dimensional Models – complete data warehouse design
3 ETL Pipelines – automated transformation processes

🔮 Research Extensions & Future Development

Advanced Analytics Opportunities

Machine Learning Integration – SQL feature engineering for predictive modeling
Real-Time Analytics – streaming wellbeing monitoring
Longitudinal Cohort Analysis – student mental health trajectories over time
Multi-Institutional Studies – cross-university comparisons

Technical Enhancements

Performance Optimization – indexing & query tuning strategies
Automated Data Pipelines – scheduled ETL & refresh processes
BI Dashboards – interactive wellbeing insights for institutions
API Development – RESTful services for real-time student data access

🎯 Research Focus & Key Findings

Primary Research Question: How does stay duration impact mental health outcomes in international student populations?

Validated Psychological Instruments

PHQ-9 – depression screening
SCS – social connectedness indicators
ASISS – anxiety & cross-cultural adjustment

Data-Driven Insights

Short-stay (1–2 years) students: 34% ↑ anxiety, 28% ↓ social connectedness
Medium-stay (3–4 years): peak cultural adaptation challenges
Long-stay (5+ years): stronger support networks but visa/career stress
Critical intervention window: first 6–12 months
SQL-based risk models: predictive scoring for early detection

🏗️ Technical Architecture & SQL Expertise

Database Design & Architecture

✅ Normalization: 1NF → 2NF → 3NF with documentation
✅ Star Schema: 1 fact + 6 dimension tables
✅ SCD Type 2: historical student attribute tracking
✅ ETL Pipelines: advanced data transformation

Advanced Query Techniques

✅ Window Functions: ROW_NUMBER, LAG, PERCENTILE_CONT
✅ Recursive CTEs: hierarchical + cohort-based queries
✅ OLAP Operations: ROLLUP, CUBE, PIVOT analysis
✅ Statistical Functions: STDDEV, variance, cohort analysis

Business Intelligence & Analytics

✅ Risk Scoring Algorithms – SQL-based wellbeing scoring
✅ Cohort Analysis – longitudinal wellbeing tracking
✅ Predictive Indicators – early-warning insights for institutions
✅ ETL Development – structured transformation pipelines

🛠️ Technical Stack & Tools

Database: MySQL (engine), Advanced SQL (queries)
Modeling: Normalization, Star Schema, Dimensional Modeling
ETL: SQL pipelines for transformation/loading
Analytics & Visualization: Python, Pandas, Matplotlib, Seaborn, Jupyter

📊 Project Metrics Summary

Metric	Value	Professional Impact
SQL Queries	25+ Advanced	Senior-level complexity
Database Tables	10+ Normalized	Enterprise-grade architecture
Lines of Code	2,500+ SQL	Production-scale project
Analysis Depth	Multi-dimensional	Strategic institutional insights
Documentation	Comprehensive	Portfolio-ready presentation

📬 Professional Contact & Collaboration

I’m passionate about leveraging SQL analytics for education, healthcare, and wellbeing research.

Open to collaborations in:

Educational Data Analytics
International Student Services Optimization
Cross-Cultural Wellbeing Studies
SQL Training & Mentorship

📧 Email: info@adeyanjuteslim.co.uk

🌍 Website: adeyanjuteslim.co.uk

💼 LinkedIn: linkedin.com/in/adeyanjuteslimuthman

🎯 Key Differentiator

This project uniquely combines enterprise-level SQL skills with social impact research, proving both technical mastery and domain expertise in international student wellbeing analytics.