Project 4 · Customer Support: Resolution Time, SLA and Backlog
This lesson is part of the course
In this lesson
You turn opened and resolved timestamps into resolution hours, check each ticket against its priority's SLA and report the SLA rate and the open backlog.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Project 1 · E-commerce Sales: Clean the Orders and Compute the KPIs Locked
- Project 1 · E-commerce Sales: Monthly Trend, Top Product and the Insight Locked
- Project 2 · HR Attrition: Clean the Leaver Flags and Compare Departments Locked
- Project 2 · HR Attrition: Find the Drivers and Chart Them Locked
- Project 3 · Marketing Campaigns: Fix the Spend Column, ROAS and CPA Locked
- Project 3 · Marketing Campaigns: Channel Summary, Best Channel and the Chart Locked
- Project 4 · Customer Support: Resolution Time, SLA and Backlog Locked
- Project 4 · Customer Support: Resolution-Time Histogram and the Insight Locked