Back to Projects

SharePoint Audit Tool at Dell

This SharePoint portal sent agents their audit score, the feedback behind it and an action plan when they needed one.

Dell · SharePoint

An audit checklist beside an envelope containing a feedback note.

What did the team need?

When a Dell support agent received an audit score, the percentage answered only one question. The agent also needed to know what they had done well, where they had lost points and what to do differently next time. If they thought a score was wrong, they needed a way to raise it with the auditor.

A manager looking at the team’s overall score had a different question. Was a finding specific to one agent, or were several people making the same mistake? To decide where coaching would help, managers needed to see the individual reviews behind the team score.

How did the audit work?

The auditor recorded the review on a SharePoint form and assigned an action plan when the findings called for one. As soon as the auditor submitted the form, the portal saved the audit and calculated the percentage score. It emailed the agent a breakdown of the score, the auditor’s comments, what went well, where they lost points and any action plan.

An agent who disagreed with the score could challenge it in the portal or by email. If the audit identified a major issue, the manager also received an email with the score, the finding, the auditor’s comments and any action plan.

What could each group see and do?

  • Auditors managed agents’ audit accounts and had to enter scheduled audit dates one to two weeks in advance. They could review records by agent and date, compare consecutive reports and action plans, and export scores to Excel to track the team’s progress.
  • Agents had access to their own records. They could search for a past audit, compare it with the next one and see whether the same issue came up after an action plan. They could also export their scores to Excel to track their progress over time.
  • Managers could look up an individual agent’s score or the overall score for their team. They could compare findings across reviews and see which action plans auditors were assigning most often.

What improved?

  • Submitting the form took care of both scoring and sending feedback. The agent received the explanation and next steps in the same email as the score.
  • Agents could use their own audit history to prepare for coaching. They could bring a specific finding or question to a conversation and check the next report for progress.
  • Auditors could use past reports in training to discuss how to score similar work consistently. Managers could use recurring findings to choose what to cover in team training.
View my Dell experience