Csaba Müller
Data Analyst | BI Developer
About Me
I am a results-oriented professional more than 10 years experiences in multinational environments (automotive and medical technology), now dedicated to advancing my career in data analysis, data engineering and business intelligence.I’m focused on creating business insights that drive decision making, and I help companies automate reports that connect to all their data.
Skills
Excel | Tableau | Power BI | SQL | Python
Projects
SQL
Analyzing Students' Mental Health
Analyzed a dataset from a Japanese international university to investigate the impact of studying abroad on students' mental health. The goal was to validate findings from a 2018 study regarding the risks of depression among international students.
Professional Certifications
Contact
© Csaba Müller. All rights reserved.
Analyzing Students' Mental Health (SQL Project)
Project Overview
In this project, I analyzed a dataset from a Japanese international university to understand how the length of stay impacts the mental health of international students. The study focused on depression (PHQ-9), social connectedness (SCS), and acculturative stress (ASISS).This project was completed as part of a DataCamp certification.
Project Goal
To analyze whether the length of stay in a foreign country impacts the mental health of international students. The study focused on depression (PHQ-9), social connectedness (SCS), and acculturative stress (ASISS).
Files in this Repository
notebook.ipynb: The SQL code containing the analysis
result_image.png: A snapshot of the query results
Students.csv : Raw data source
mentalhealth.jpg: Cover picture of the project
Description of the columns of "students.csv" you may find helpful
Tools & Skills
Language: SQL (PostgreSQL)
Techniques: Data Filtering (WHERE), Aggregation (AVG, COUNT), Grouping (GROUP BY), Ordering (ORDER BY), Data rounding (ROUND).
Query "all" results in students table
Key Findings
After filtering for international students (inter_dom = 'Inter') and grouping by the length of stay, the analysis revealed:1.) Depression Score (PHQ-9): The average depression score varies depending on how long the student has been in the country.
2.) Stress Levels (ASISS): Acculturative stress shows distinct patterns across different lengths of stay.
The Main Query
The following SQL query was used to aggregate the data:
Results
The analysis reveals how mental health metrics fluctuate for international students depending on their duration of stay. The SQL query returned the following aggregated data:
Conclusions
Confirmed that international students face higher risks of mental health difficulties linked to social connectedness.
Crucial Insight
Upon analyzing the "stay", I identified a sample size issue with durations exceeding 5 years. I concluded that only the 1-4 year range provides statistically significant data, as the low sample count for other durations would distort the correlation analysis regarding depression scores.