John Glenn College of Public Affairs
Ohio Education Research Center

Yaqi Zhang

My name is Yaqi Zhang, and I am a fourth-year Statistics major with a minor in Business Analytics. This summer, I interned with the Ohio Department of Education and Workforce Office of Research, Evaluation, and Advanced Analytics through the Public Sector Data Science Internship (PSDS) program. The reason why I chose this internship is to apply my statistical skills to real-world data and gain a deeper understanding of how data can inform public decision-making. My project focused on analyzing college-going patterns across Ohio counties using data from the National Student Clearinghouse. I used R for data cleaning and analysis, and Power BI to develop interactive dashboards that visualize trends by college type, cohort year, socioeconomic status, and test performance level. The most challenging part of the internship was learning Power BI for the first time and creating effective visualizations. My favorite part was collaborating with a supportive and knowledgeable team. I highly recommend this internship to anyone interested in data analysis and public sector work.

See Yaqi Zhang 's Poster