Vodafone call center dashboard

A call center consists of 6 departments, and the manager wants to know the average number of calls received by each department over three months to allocate staff members to each department based on the volume of calls and the needs of each department.

This is a KPI monitoring dashboard, designed to offer comprehensive insights into the call center manager and track vital metrics including:

1- Which day has the maximum number of calls?

2- What is the total number of calls per month?

3- Which department has the maximum number of call hits?

4- What is the total number of calls per day and hour?

I built this dashboard using Excel to track and monitor the total call patterns and trends and provided the manager with these helpful insights to make informed decision-making and better allocate the employees easily.

---

Data Source: Public dataset