Case Study Healthcare Economics

Unmet Mental Health Needs

A healthcare analytics case study examining whether failing to treat mental health needs is associated with measurable workforce detachment.

This project shows the full arc hiring managers care about: question framing, data preparation, testing approach, validation logic, and clearly communicated findings.

Project Summary

Focus: unmet need and employment status

Stack: PostgreSQL, SQL, statistical testing

Value: turns public-health data into workforce-relevant evidence

Hiring Relevance
  • Strong example of question-to-conclusion analytical discipline.
  • Directly relevant to healthcare quality, utilization, and reporting work.
  • Shows ability to translate complex methods into stakeholder-readable output.
Research Pipeline

Conception To Conclusion

1
The Question

Does failing to treat mental health needs cause measurable workforce detachment?

2
The Data

2019 NSDUH / SAMHSA dataset with adult cohort and standardized variables.

3
The Test

PostgreSQL ETL pipeline plus Chi-Square independence testing.

4
The Result

Statistically significant employment drop when unmet need is present.

Primary Visualization

Main Evidence

The primary chart makes the relationship legible quickly: unmet mental health need is associated with lower employment rates, with the difference remaining meaningful enough to support the broader conclusion.

Unmet mental health need by sex and employment status
The Problem
The Data
The Question
The Hypothesis
The Test - Engineering
The Validation
Results

What The Data Shows

1
Statistical Significance

The null hypothesis is rejected under a materially significant result.

2
Employment Effect

Employment drops meaningfully when unmet mental health need is present.

3
Analytical Value

Demonstrates ETL, schema normalization, testing, and communication in one workflow.

4
Healthcare Relevance

Connects directly to questions healthcare analytics teams solve around access, quality, and outcomes.

Next Step

Discuss The Work