I recently engineered a real-time by Umar AurangzebI recently engineered a real-time by Umar Aurangzeb

I recently engineered a real-time

Portfolio project
Umar Aurangzeb
I recently engineered a real-time tracking system for a school to replace static reports with continuous feedback. Using a Google Sheets-to-Looker Studio pipeline, I automated the transition from raw teacher observations to parent-facing insights.
Key Deliverables:
Live Pipeline: Structured Sheets input for teachers to log 12+ data points per student daily.
Grit Scoring Engine: Built custom logic weighting effort over mastery using cohort benchmarks.
Dynamic URL Security: Implemented unique, filtered dashboard links for secure parent/student access.
Automated Insights: Built-in trend indicators (Improving/Stable/Declining) for instant intervention.
The Impact: The client now uses a live command center that eliminates manual reporting and provides real-time actionable intelligence.

0 likes · 0 views · Feb 25, 2026

I recently engineered a real-time tracking system for a school to replace static reports with continuous feedback. Using a Google Sheets-to-Looker Studio pip...

Timeline

Feb 9, 2026 - Feb 20, 2026

Tags