Case Study: University of St Andrews improves real-time student insights with Pythian Oracle Analytics

University of St Andrews improves student insights for 10K students with Pythian

The University of St Andrews faced significant data challenges as its legacy infrastructure, overwhelmed by rapid growth, created performance bottlenecks and obscured data lineage. This hindered the university's ability to track student journeys in real time. To modernize its system, the university engaged vendor Pythian for Oracle Analytics consulting services.

Pythian engineered a hybrid DataVault and Kimball star schema architecture on Oracle Database using Oracle Data Integrator (ODI). This solution integrated seamlessly with existing QlikView dashboards, delivering real-time, uninterrupted reporting. The project empowered staff to shift from manual data troubleshooting to proactive student support, enhancing services for over 10,000 students and 3,000 staff.

University of St Andrews