How Real-Time Dashboards Replaced 10 Hours of Weekly Spreadsheet Work
The Situation
A regional equipment dealer with multiple locations was running their service department off paper tickets and their parts tracking through a dealer management system that required too many clicks to get simple answers. Managers had no real-time visibility into what was happening in their shops.
End-of-month reporting meant someone spent hours pulling numbers from the DMS into spreadsheets. "How many hours did we bill this week?" required digging through multiple screens. "Where's that customer's parts order?" meant putting someone on hold while a parts counter rep clicked through five pages.
The information existed in their system. Getting to it was the problem.
What We Built
Service Department Dashboard
A live view of every bay in the shop, updated in real-time. Managers open one screen and see:
- Which technicians are on which jobs
- Time elapsed vs. estimated completion
- Jobs waiting on parts (flagged automatically)
- Scheduled appointments for the rest of the day
- Bay utilization percentage
Technicians get a simplified mobile-friendly view showing only their assigned work orders. They update status with a tap instead of walking to the service desk.
Parts Order Tracker
A single screen showing every open order with color-coded aging. Orders open longer than 7 days go yellow. Over 14 goes red. Filters by customer, salesperson, date range, and shipping method let the parts team answer any customer question in seconds.
KPI Dashboards
The dashboards that management actually wanted. Billed hours vs. clock hours per tech. Revenue per bay. Parts invoicing by salesperson with daily, monthly, and yearly rollups. All generated automatically from data already in the DMS.
DMS Integration
The critical decision was integration, not replacement. Everything reads from and writes back to the existing dealer management system. No duplicate data entry. No learning a new way to do the job. Just better visibility into work they were already doing.
The Technical Approach
The backend is a C# REST API that talks directly to the DMS database. Read access for pulling work orders, parts status, and performance metrics. Write-back through API callbacks when technicians update job status from the dashboard.
The frontend is vanilla JavaScript with automatic refresh. Dashboards update every few seconds without page reloads. Each location sees their own data by default; managers with proper permissions can compare across all sites.
DMS queries are optimized to minimize load on the production system. Frequently accessed data is cached locally with smart invalidation when source records change.
Results
Time savings: Monthly KPI reports that took 8-10 hours of spreadsheet work now generate in seconds.
Parts visibility: "Where's my order?" calls dropped significantly once the team could answer instantly instead of hunting through the DMS.
Service flow: Managers stopped interrupting technicians to ask status questions. The board tells them everything.
Cross-location insight: For the first time, leadership could compare performance metrics across all their locations side by side.
The biggest win was adoption. Nobody had to change how they worked. They just got a better window into what was already happening.
Need better visibility into your operations? Let's talk about what's possible.