Data warehouse to identify at-risk students across hundreds of colleges

Situation

A Twin Cities non-profit focused on student success needed to consolidate data from hundreds of colleges and institutions to identify students most at risk of dropping out — in time to intervene. Each institution ran its own ERP and college management systems with no shared data model. Without a unified platform, advisors had no way to see patterns across the network or trigger timely coaching conversations. The solution required ingesting disparate data at scale, enforcing consistent definitions, and surfacing risk signals through integrated dashboards.

Impact