Floria Liu

My name is Floria Liu, and I am a fourth-year Marketing major with a minor in Business Analysis. This summer, I interned with the Ohio Department of Higher Education and worked on multiple projects to support data integrity and system improvement. One major project involved analyzing data quality for the Ohio Educator Preparation Annual Report, which is presented through a Tableau dashboard. The data came from internal systems, external partners, and a state-managed Oracle database. I used SQL, Tableau, and Excel to identify inconsistencies, detect missing values, and improve the accuracy of reporting. In another project, the Ohio Remediation Report, I used R and natural language processing techniques to clean and compare high school names across two datasets. I applied text normalization and string distance algorithms to identify potential matches. To validate these matches, I incorporated classification logic by evaluating true positives and false negatives, which helped refine the matching criteria and support accurate cross-agency data alignment. I applied to this internship because I wanted real-world experience applying data science skills in the public sector. The PSDS internship allowed me to work on meaningful projects that support transparency and decision-making in education. I really enjoyed working with real-world datasets that directly support education policy and accountability. It was rewarding to contribute to statewide reporting efforts, and I appreciated the opportunity to grow my technical skills while learning how different teams collaborate on public data projects. One of the biggest challenges was working with data from multiple sources without access to full documentation or backend systems. It required extra effort to interpret the data structure and ensure accuracy, especially when working with legacy systems or third-party contributions. While it was sometimes difficult, it also helped me strengthen my problem-solving and data validation skills. Overall, I would recommend this internship! You get to work on real projects that actually matter and use multiple tools. It’s not always easy and some parts take a lot of figuring out, but if you’re looking to learn and make an impact, it’s definitely worth it.

See Floria Liu 's Poster