OCAD University Student Analytics Dashboard
Centralized, real-time insight across enrolment, funding, and equity to support faster decisions for students and staff.
53 fragmented legacy student data reports across SAP and Slate were slowing decision‑making and duplicating effort.
Create a centralized, usable analytics platform that turns data into action for university staff.
Research and discovery
Conducted 15+ interviews and contextual inquiries with admin staff across departments to understand needs and constraints.
Mapped reporting flows to surface redundancies and friction points that blocked timely insight.
Identified gaps in data usability, refresh cadence, and cross‑system integration.
Design strategy
Enrolment, Funding, and Equity to match mental models and ownership.
Blended SQL datasets from multiple sources in Power BI for consistency and scale.
Focused layouts, readable typography, and AODA considerations with responsive filtering.
Implementation
Deployed dashboards across departments through Microsoft Fabric.
Added views for demographics such as immigration status, gender, and religion.
Helped move the organisation to a modern analytics stack replacing static reports.
Impact
Reflection and next steps
Contextual inquiry in an institutional environment was essential to align the product with real workflows and governance.
Next, add predictive analytics for enrolment and retention, and offer self‑serve customization so teams can tailor views without rebuilding reports.