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.