Call Center Performance Analysis

Project Overview

This project presents an interactive Excel dashboard built to analyze and monitor a call center’s performance.
The dashboard provides a clear overview of call activity, sales performance, customer demographics, and representative efficiency.

It was designed to solve common challenges faced by management in tracking performance, identifying trends, and making data-driven decisions.

---

Tasks Performed

1. Task: Identify monthly call volume trends

   • Solution: Built monthly call volume charts to visualize how many calls were taken each month over a year, making patterns and fluctuations easy to understand.

2. Task: Track sales and KPIs at both overall and representative levels

   • Solution: Added KPIs for total sales, total call duration, and representative-wise sales performance, consolidating everything in one dashboard.

3. Task: Analyze caller demographics by gender

   • Solution: Designed gender breakdown visualizations to reveal insights into male vs. female caller distribution.

4. Task: Compare performance across representatives

   • Solution: Developed a rep-level performance tracker that highlights total calls, sales contribution, and average ratings for each representative.

---

Tools & Techniques Used

• Microsoft Excel
  • Data Cleaning & Preparation
  • Pivot Tables & Pivot Charts
  • Slicers & Filters for interactivity
  • Conditional Formatting for KPIs
  • Dashboard Design for usability

---

Repository Contents

• Call Center.xlsx → The interactive Excel dashboard file
• README.md → Project documentation (this file)
• screenshot 2025-08-25 174027.png → Preview of the dashboard

---

How to Use

1. Download or clone this repository.
2. Open the Call Center.xlsx file in Microsoft Excel.
3. Use the interactive slicers and filters to explore monthly call volumes, sales, demographics, and representative performance.

---

Key Insights from the Dashboard

• Monthly Trends: Clear visualization of total calls taken per month across the year.
• Sales KPIs: Easy tracking of total sales, call duration, and overall performance.
• Customer Demographics: Gender distribution analysis (male vs. female callers).
• Representative Performance: Detailed comparison of reps’ sales, total calls handled, and average ratings.

---

Learning Outcomes

Through this project, I strengthened my skills in:

• Data Cleaning & Structuring in Excel
• Building KPI-driven Dashboards
• Data Visualization for Business Insights
• Problem-Solving with Real-World Datasets

---

Preview