Case Study
ONETU: TU Student Lifecycle Analytics Platform
A governed GCP data platform and 6-page Power BI dashboard that follows Thammasat students from admission to graduation. Academic team project.
- Role
- Data pipeline, governance & BI (team project)
- Timeline
- 2026
- Stack
- GCPCloud StorageBigQueryCloud RunDataformPower BIPythonSQLCKAN
- Power BI dashboard pages
- 6Power BI dashboard pages
- source systems unified (TCAS + SIS)
- 2source systems unified (TCAS + SIS)


01 / Problem
Thammasat's student data is split across systems: admissions data (TCAS) and the student information system (SIS) each hold part of the same student journey, with no shared data model, catalog, or governance. That makes university-level questions, such as which programs attract strong applicants or where students drop out, hard to answer consistently.
02 / Approach
Co-designed a centralized Student Lifecycle data model on a governed Bronze-Silver-Gold architecture. Built an automated cloud pipeline with Google Cloud Storage, BigQuery, Cloud Run, and Dataform that transforms raw TCAS and SIS data into standardized analytical models and Gold-layer data marts. Implemented data governance: data quality rules, metadata, master data, a data dictionary, access control, and CKAN-based data cataloging for consistency, lineage, and traceability.
03 / Outcome
A 6-page Power BI strategic dashboard with custom DAX measures covering admission performance, demand trends, program competitiveness, the student lifecycle, retention, dropout, and graduation patterns, built to support university-level decision-making.
See the project slides for the data model, architecture, and dashboard walkthrough.