> While peers might now "Amy" is the real hero, non-technical people don't grasp that very well
This could be also a failing to communicate effectively. Us developers sometimes have a hard time translating:
"the join duplicates records because X table has duplicate values in Y field. We need to add a unique key constraint to it and catch the exception in module Z"
into
"your report has duplicated products because someone captured the serial number twice. I'm going to add the missing validation so this doesn't happen again".
This could be also a failing to communicate effectively. Us developers sometimes have a hard time translating:
"the join duplicates records because X table has duplicate values in Y field. We need to add a unique key constraint to it and catch the exception in module Z"
into
"your report has duplicated products because someone captured the serial number twice. I'm going to add the missing validation so this doesn't happen again".