
Customer Support Ticket Dashboard
An interactive dashboard analysing 160 mock support tickets to surface trends in resolution time, channel volume, and customer satisfaction. Pivot-style formulas and charts revealed that billing queries had the slowest resolution times — which informed a process-improvement recommendation.
- Microsoft Excel / Google Sheets
- SUMIFS / AVERAGEIF / COUNTIF
- Data visualisation


