The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Most dashboards fail before they are even built.
Not because of bad charts.
Not because of wrong formulas.
Because the data underneath is structurally broken.
Here’s what I see often in small businesses:
• Dates stored as text
• Multiple columns for the same metric
• Inconsistent naming (Revenue / Sales / Total Sales)
• Manual copy-paste every week
• No clear data flow
Then they ask:
“Why doesn’t this dashboard update properly?”
A dashboard is just a mirror.
If the data structure is messy, the reflection will be distorted.
Before I build any report, I focus on 3 things:
Standardized column logic
Single source of truth
Repeatable data flow (no manual dependency)
Clean structure → Reliable metrics → Better decisions.
If your reporting feels fragile, the issue usually isn’t Excel.
It’s the foundation.
Completely agree. Dashboards amplify whatever foundation they sit on — messy data → misleading clarity. Standardization and single source of truth are massively underrated.
A few months ago, I started working on a school management product in Kuwait — from zero.
The challenge was huge: everything was on paper. Teachers, students, and parents were used to manual workflows. No specs, no clear direction — just an idea.
Over 6 months, we worked closely with the client, teachers, students, and even parents to understand the real problems and design a system that actually works.
The result? A product with 3 main dashboards, over 200 unique screens, designed for students, teachers, parents, and school admins. A system that’s practical, scalable, and truly adopted by real users.
The hardest part wasn’t the design itself — it was earning the trust of teachers, making them leave their old, familiar paper processes and embrace a digital workflow.
Nice work
Skill Quest: A Secure Skill-Sharing Marketplace for Kids
The Problem: Kids lack a safe, dedicated space to share skills like coding or art without risking their data privacy.
The Solution: I built Skill Quest, a gamified marketplace where "Adventurers" book 10-minute sessions to learn and earn.
Key Features:
Secure Payments: Fully integrated Stripe for secure $10 session bookings.
Advanced Security: Implemented strict Bubble Privacy Rules to ensure kids' data is only accessible to authorized users.
Execution: A production-ready app featuring a functional explore page and seamless user experience.
Excellent problem-solution articulation. Designing marketplaces for younger users introduces entirely different trust and interaction challenges. Strong direction.
Trending
maxearnings
The next frontier of payments is live on Contra. How are you maximizing revenue?
micrographics
Micrographics started as utility - barcodes, packaging, instruction labels. How would you use them?
aidesignflow
AI tools are redefining how designer work. What does your workflow look like?
aivideo
AI video tools are moving at warp speed. What tools are you using?
whennotai
As AI accelerates, creative judgment matters more. What part of your work stays human?