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
Field Service Live Command Center — Power BI
Live ops dashboard I built for MSP / print service clients to replace WhatsApp "where are you?" checks.Managers see in one glance at 3pm:6 techs signed in, 2 not signed in — staffing gap visible23 calls completed, 7 still in progress, 520 KMs travelled today — cost + productivityLogon Time table — who logged at 07:29 vs who never loggedLast Activity — Travel / Start Work / On Site / End Work with timestampIn Progress Calls — Call Type + Reference live (Delivery Call39762, Service Call39765)Work Assignment — Accepted vs New Calls stacked bar — shows overload (Luke: 8 accepted) vs idleCalls Completed — ranking per techTravel per Tech — John 201 KM vs Sam 15 KM — instant route / fuel insightBuilt in Power BI dark-mode for ops room TV, fed by SQL job data. DAX for KPIs, RLS so techs see only theirs.Outcome: dispatcher saved 1.5 hrs/day, stopped over-assigning same tech, KM cost down.Includes: .pbix file + data model + SOP for "Not Signed In" action.Screenshot uses anonymized demo data.
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
Power BI dashboard providing visibility into billing performance, revenue trends, customer activity, and operational KPIs. Built using SQL and ERP data to support proactive business decisions.
Meet Leo and his business, Leon Mobile Detailing (Austin, TX).
He was losing 30-40% of leads simply because he couldn't answer calls mid-job. By 8 PM, those clients had already booked a competitor.
To fix this, he upgraded his entire booking flow.
Here’s how the new platform handles it:
1️⃣ Faster Booking via Chat & Dynamic Content shown relevant to chat
2️⃣ Smart Dashboard and Chat Support
3️⃣ Track your Booking Easily without Signing in.
Zero apps. Zero account creation.
Built end-to-end in Lovable. Demo video below!
Book here: https://leon-mobile-detailing.lovable.app
Note: Project First Published on Lovable: Sep 26, 2026 (10:40 AM UTC)
Entry Submitted: September 26, 2026
Built a booking app for Kang Dedi, a one-man AC technician in Bandung (fictional client, very real problem).
Every booking used to be a WhatsApp marathon: "how much?", "which day?", "what time?", "send your location". Around 10 messages per job, answered at night after work. Then his days zig-zag across the city, and sometimes he shows up to an empty house because the customer forgot.
So I turned the whole chat into one link:
✅ Pick your neighborhood, you only see days he's already around (mornings in your area, afternoons in the center)
✅ Price and time on site show up instantly, only slots where the whole job actually fits
✅ Booked in about a minute, with a ticket and the exact WhatsApp confirmation
✅ Reminder the evening before: still on, or reschedule? No reply gets flagged for him
✅ Someone cancels? The slot goes straight to the next person on that area's waitlist
✅ Review request goes out after the job, on its own
✅ His whole day on one map, plus the week, the waitlist and every message sent
Ngl the fun part was the scheduling rule. My first version literally put him in two places at once, took a couple of rounds to get it right (the process video shows the whole thing, bugs included).
Try it: ademservice.lovable.app
Owner view, no login: ademservice.lovable.app/demo
(Messages are simulat:ed in the demo, production would go through the WhatsApp Business API.)