Skip to main content
Contact Center
Role: Senior BI Developer

Contact Center Performance & Queue Analytics Dashboard

Client: phData
4 weeks
5 Technologies

Key Measurable Results

3,599

Incoming calls tracked with week-over-week queue telemetry

250.7s

Average talk time monitored across all support agents

50%+

First Customer Resolution tracked per client account

1The Problem

Contact center leadership had limited visibility into intraday wait-time spikes, agent call-handling rankings, and customer-level resolution rates. Manual reports couldn't show which call types were causing queue bottlenecks or which agents needed targeted coaching.

2What We Built

Built an interactive Contact Center Overview dashboard tracking 3,599 incoming calls, wait-time trends, top call drivers (Technical Issues 37%, Internet Outage 29%, Billing 22%), agent performance rankings, and client-by-client First Contact Resolution (FCR) and CSAT scores.

How It Works — Step by Step

1

Designed the Executive Overview tracking Incoming Calls (3,599), Answered Calls (3,595), and Average Talk Time (250.7s) with week-over-week deltas

2

Built an intraday Wait Time Until Answer trend chart to pinpoint staffing bottlenecks

3

Categorized incoming volume by Top 5 Call Reasons to guide self-service deflection

4

Added an Agent Performance leaderboard and customer-level drill-down cards tracking FCR and CSAT per client account

✓The Result

3,599

Incoming calls tracked with week-over-week queue telemetry

250.7s

Average talk time monitored across all support agents

50%+

First Customer Resolution tracked per client account

Skills & Deliverables

LookerSQLCall Center AnalyticsQueue TelemetryAgent KPIs

Project Details

Our Role

Senior BI Developer

Client

phData

Industry

Contact Center

Delivery Timeline

4 weeks

Need a similar system built for your team?

Book a free discovery call and we'll map out how to build this for your exact data sources and tools.

Contact Center Performance & Queue Analytics Dashboard