TTD CCC: Inspection Management Dashboard
Replacing a weekly spreadsheet review with a live, drill-down dashboard for TTD’s inspection teams.
PROBLEM
Inspection performance lived in a weekly, hand-made spreadsheet.
SOLUTION
A live CCC dashboard: unit coverage, performance, a ranked report and drill-down to photos.
IMPACT
Weekly → live · 100% of units accounted for · 4 clicks from number to photo.
Watching thousands of inspections, live.
KEY TAKEAWAYA live monitoring tab for inspections, built beside the helpdesk dashboard.
TTD’s health and facility teams inspect hundreds of toilet units across zones and wards every day with the Nandakam app. CCC is where the Command & Control Centre admins and TTD officials watch that work. This project added an Inspection Management tab next to the existing Defect Management dashboard.
MY RESPONSIBILITIES
- →Turned the functional spec’s data rules into clear widgets
- →Designed the dashboard, report, drill-down and inspection detail
- →Designed Department Setup, the department picker and exports
- →Handed off with edge cases and colour rules; ran design QA
Inspection performance was reviewed once a week, from a hand-compiled spreadsheet read out zone by zone.
KEY TAKEAWAYThe data existed in ERP. The review still happened in a spreadsheet.
Allotment, Target, Achieved, %: typed up by hand and discussed in a weekly review meeting. Even after inspections moved into ERP and the app, there was still no single place to see target vs completed vs pending, find units nobody had inspected, or check the photos behind a number.
By the time a gap showed up in the weekly meeting, it was already a week old, and the evidence was sitting on someone else’s phone.
Five gaps from the spec.
KEY TAKEAWAYFive gaps: visibility, coverage, evidence, access and scale.
P1No centralised dashboardNo single screen for Target vs Completed vs Pending across zones, wards or people, in real time.
P2No view of coverage gapsNo way to see which toilet units were never inspected in a period.
P3No drill-downA person’s Achievement % couldn’t be traced back to inspections, checklist answers or photos.
P4No standard access controlNo consistent rule for who on the TTD / CCC side may view this operational data.
P5Stuck at one departmentNo way to scope data as more TTD departments beyond Health join the platform.
What success looks like.
KEY TAKEAWAYSuccess = live numbers you can trust and open up.
USER GOALS
- →See target, completed and pending at a glance
- →Spot units that were never inspected
- →Trace any number back to the photos behind it
BUSINESS GOALS
- →Replace the weekly manual performance review
- →One access-control model shared with Defect Management
- →Onboard new TTD departments without new builds
Live
instead of a once-a-week spreadsheet
5 bands
of inspection recency, incl. “never inspected”
4 clicks
from a summary number to the photo
Written from the CCC desk.
KEY TAKEAWAYStraight from the functional spec, one per decision.
STORY 01
As a CCC Admin, I want to view Target / Completed / Pending / Achievement for the selected department, so that I can centrally monitor operational workload.
STORY 02
As a CCC Admin, I want to analyse inspection performance zone-wise and ward-wise, so that I can find areas needing attention.
STORY 03
As a CCC Admin, I want to see a ranked performance report by person, so that I can identify under-performing personnel.
STORY 04
As a CCC Admin, I want to drill into a person’s inspections and open the checklist with photos, so that I can verify field work without visiting the site or borrowing a phone.
STORY 05
As a CCC Admin, I want to see unit-level inspections, including units never inspected, so that I ensure full coverage, not just averages.
STORY 06
As the Support team, I want to set up departments and map communities to each, so that new TTD departments can join the shared dashboard.
Three users, three jobs.
KEY TAKEAWAYAdmins monitor, officials review, Support configures.
ACCC Admin
Command & Control Centre
Command & Control Centre
Monitors every zone, ward and inspector; grants access.
- →Needs exceptions first
- →Verifies evidence remotely
OTTD Official
MC Member
MC Member
Reviews performance once access is granted.
- →Needs a clear weekly picture
- →Shares PDFs with management
SADDA Support
Support login
Support login
Sets up departments and maps communities.
- →Needs safe, reversible setup
- →No double-mapped communities
What we learned.
KEY TAKEAWAYThe weekly meeting told us what to sort by.
Review-meeting audit
The Allotment / Target / Achieved / % spreadsheet
Functional spec workshops
Data rules for every card, with PM
Defect Management parity
Same access control, tabs and patterns
ERP config mapping
Zones, checklists, targets and shifts already in ERP
INSIGHT 1
The meeting really asks “who’s behind?”
So the report sorts lowest achievers first, not alphabetically.
INSIGHT 2
Averages hide unvisited units
A 90% average can still leave units nobody has inspected for months.
INSIGHT 3
Trust needs evidence
A percentage only matters if you can open the checklist and photos behind it.
INSIGHT 4
Departments define scope
Officials think “Health” or “FMS”, not a list of ADDA communities.
Where it fits in CCC.
KEY TAKEAWAYIt sits where CCC users already work.
WHERE IT LIVES
ERP › CCC › TTD Service Management Dashboard
› Inspection Management tab (next to Defect Management)
› Inspection Performance Report › person › inspection
Support Login › Department Setup
BUSINESS RULES
- →Default date range: last 90 days
- →Status uses each unit’s latest inspection on or before the To date
- →Achievement: ≥ 100% green · 75–99.99% amber · < 75% red
- →Report sorted lowest achievement first; ties A–Z
- →Department picker shown only with access to 2+ departments
- →A community belongs to only one department
The hard parts.
KEY TAKEAWAYMake dense, time-based data calm and correct.
01
Dense data, calm screen
Five recency bands, three zones, many wards, readable in seconds.
02
Getting time right
“Latest inspection on or before the To date”, never later ones.
03
Privacy in exports
Share a high-level PDF without listing individual scores.
04
Scope that scales
Departments group communities so every widget scopes correctly.
05
Feel like one product
Sit beside Defect Management with the same patterns and access rules.
How I got there.
KEY TAKEAWAYFormulas first, charts second.
01
Audit
The weekly spreadsheet
02
Map
ERP config → metrics
03
Define
Formulas per card
04
Explore
Zone bars, ward bars, donuts
05
Wireframe
Dashboard & drill-down
06
Design
Hi-fi CCC UI
07
Validate
Walkthroughs with CCC
08
Ship
Handoff & QA
EXPLORED, THEN SIMPLIFIEDEarly ward bars with target markers were rich but slow to read; the shipped version uses donuts plus the ranked report.
Ward Wise Performance■ Completed ■ Pending | Target
Ward 2200
Ward 3150
Ward 4200
Ward 5120
Six decisions, mapped to the pains.
KEY TAKEAWAYSix decisions, each traceable to a pain point.
FEATURE 01Unit Inspection StatusEvery unit placed in one of five recency bands (≤30, 31–60, 61–90, >90 days, or never) with a block-wise breakdown. Each band opens the unit list, oldest first.fixes P2
FEATURE 02Inspection Performance at a glanceTarget, Completed, Pending and Achievement, then donut charts by zone and by block.fixes P1
FEATURE 03A ranked performance reportLowest achievers first, colour-banded progress bars and a pinned total row, the weekly meeting, live.fixes P1fixes P3
FEATURE 04Drill down to the evidenceFrom a person’s row to every inspection they did, then the full checklist with geo-tagged photos and comments synced with the app.fixes P3
Achievement 72.8%, but who’s behind?
Lowest achievers first. Lakshmi is at 59%.
Every inspection Ramesh did in the range.
The checklist answers, geo-tagged photos and comments.
FEATURE 05Departments that scaleSupport groups communities into departments; users with 2+ departments get a picker that scopes every widget and export.fixes P5
FEATURE 06Safe exports and shared accessA PDF export with a choice to leave out personnel scores, and the same Access Control as Defect Management.fixes P4
Download report✕
Leave it unticked to share a high-level PDF without individual personnel scores.
CancelDownload
TTD_Inspection_Dashboard_Report_20062026.pdf · A4Edge cases, handled.
KEY TAKEAWAYTime, scope and access edge cases all handled.
✓Inspections after the To date
Ignored when working out a unit’s status.
Ignored when working out a unit’s status.
✓Never-inspected units
Sorted Zone → Ward → Unit so gaps are easy to walk.
Sorted Zone → Ward → Unit so gaps are easy to walk.
✓Department with users
Can’t be deleted until those users are reassigned or revoked.
Can’t be deleted until those users are reassigned or revoked.
✓Community already mapped
Hidden from other departments, never double-counted.
Hidden from other departments, never double-counted.
✓Single-department user
No picker, their department applies automatically.
No picker, their department applies automatically.
✓Zones not set up
The zone widget hides itself.
The zone widget hides itself.
✓Equal achievement
Tie broken alphabetically by name.
Tie broken alphabetically by name.
✓Photos
Open in an in-browser viewer, no download.
Open in an in-browser viewer, no download.
Impact and what’s next.
KEY TAKEAWAYFrom a weekly read-out to a live, drill-down view.
Weekly → live
performance review
100%
of units accounted for, incl. never inspected
4 clicks
from a summary number to the photo
WHAT I LEARNED
- →Sort by what the meeting is really asking
- →Averages need a coverage view beside them
- →A number is only trusted when it opens up
NEXT STEPS
- →Alerts when a unit crosses 60 days
- →Ward targets on the chart as reference lines
- →Shift-wise performance views
