School Harbor (Spring & Fall 2025)
Fall 2025Colorado school data API
Building a queryable database and public API for Colorado school data
Impact
Gives School Harbor a clean, queryable Colorado school database and public API, backed by documentation and an annual update pipeline, so the data stays current and others can build on it.
What we delivered
- Normalized relational database for school, address and ID records
- Python ETL pipeline to clean, load and annually update Colorado Department of Education data
- REST API with endpoints to query by school name, address, year and ID
- Documentation, setup guide and a version-controlled GitHub repository
Skills used
- Python
- SQL
- REST API design
- ETL pipelines
- Git and GitHub
- Technical documentation
Spring 2025
Rebuilding a student test-score dashboard on a cloud SQL database and Looker Studio.
Impact
Moves School Harbor's student test-score dashboard onto a cloud SQL database and Looker Studio, giving the team a rebuilt dashboard it can maintain and extend; School Harbor later returned for the Colorado school data API.
What we delivered
- Dashboard replication in Looker Studio
- Google SQL database configuration
Skills used
- SQL
- Google Cloud SQL
- Looker Studio
- Data visualization
- Dashboard design
- Python
Good fit if you study (suggested)
- Computer Science
- Information Systems
- Data Science
- Statistics
- Education interest