←Work
Data & Analytics
Production Reporting Dashboard
Leadership at multiple market centers were tracking coaching ROI through a tangle of Google Sheets, copy-pasted MLS exports, and gut feel. This dashboard wired the same data into Looker Studio with automated pulls from the source systems. Year-over-year trajectory, per-agent scorecards, and leadership rollups update without anyone touching a spreadsheet.
- Role
- Designer and engineer.
- Year
- 2024–2025
- Stack
- Looker Studio·Google Sheets·Apps Script·Automation
Outcomes.
- Eliminated 4+ hours of weekly manual spreadsheet work for leadership.
- Year-over-year coaching ROI visible at a glance.
- Per-agent scorecards refresh nightly with no human input.
Want something like this?
Send a message