Maurya
Patel
Work
GTU Result Analysis, Data Analytics Platform

Case Study

GTU Result Analysis

RoleFull Stack Developer
CategoryData Analytics Platform

A result-intelligence platform that turns Gujarat Technological University's bulk exam CSVs into instant, actionable analytics for faculty. It replaced hours of manual spreadsheet work with reports that surface subject weak spots and at-risk students in seconds.

The Challenge

GTU publishes semester results as large, unwieldy CSV files. Faculty and heads of department were spending hours per exam cycle pulling those files into spreadsheets by hand, building pass-rate tables, and hunting for patterns. By the time a report was ready, the window to actually help a struggling student or fix a weak subject had often closed. The data existed; the insight did not.

The Solution

I built a result-intelligence platform where faculty upload a GTU result CSV and get a full analytical picture back in seconds. The app parses the file in under five seconds, then generates the reports decision-makers actually need: pass-rate breakdowns, subject-level failure heatmaps, class rankings, and automatic detection of at-risk students with an export ready for counseling. It is built for HODs and faculty, not students, so every view answers a question an educator is trying to make a decision about.

Key Features

01CSV Upload & ParsingHandles GTU's bulk result files and parses them in under five seconds
02Pass-Rate AnalyticsInstant breakdowns by class, subject, and cohort
03Subject Failure HeatmapsVisually surfaces exactly which subjects are dragging performance down
04At-Risk Student DetectionFlags students who need intervention and exports a counseling-ready list
05Student RankingsAutomatic class and department rankings from raw result data
06Multiple Report TypesSix-plus report formats built around real academic decisions

Results

Cut the time faculty spend on semester reporting by over 60%
Replaced manual spreadsheet work with instant, repeatable analytics
Surfaces at-risk students early enough for the intervention to matter
Institution-grade handling of sensitive result data

Tech Stack

Next.jsNode.jsGraphQLPrismaNextAuthshadcn/ui