College Scorecard and IPEDS Data Pipeline and Dashboard

I completed this project alongside four classmates from my graduate program cohort. We built an end-to-end data pipeline and interactive dashboard to process and visualize large-scale public higher education datasets from the U.S. Department of Education’s College Scorecard and IPEDS.

We designed a custom PostgreSQL schema and ETL upsert pipeline to handle multi-year institutional metrics, financial aid data, and enrollment figures. Ultimately, we integrated this database into a dashboard that updates given the data (must be run locally).

Together, we developed the data pipeline code and built the dashboard application showcasing our results.