Medical Program Capacity and Student Performance Analysis
This is a project in Snowflake to simulate medical student assessment and clerkship/faculty capacity evaluation. I built multiple relational tables (students, faculty, clerkship sites, clerkships, and exams). The table structures are summarized in Appendix 1, and I loaded CSV data into Snowflake. I then wrote SQL queries to analyze site capacity utilization, faculty capacity utilization and to evaluate student outcomes by tracking pass rates across specialties.
Lucy Hu 