Call Center Data Analysis

Introduction
I have been provided with data set of a call center for the month of October, 2020. I am tasked with finding the call trend over the month and generating insights from the given data set. Some questions that will be answered from the data will include;

• Total number of callers over the month.
• Number of callers through various channels.
• Customer sentiments.
• Reasons for customer calls.
• Total calls by response time.
• Call trend over the 31 days of the month.
• Average call duration.
• Average satisfaction score.

Data Preparation
The data came in a .csv format and formatted as shown in the diagram below;

In order to make the data look more presentable, the column headers were made to standout. Also, to find the Call Trend for the month, I had to extract the the Days from the Call timestamp column as shown below;

The diagrams below show the .csv file in Power Query and the modified data set respectively;

Data Modelling
So as to find the trend of calls for each day of the month, a Date table was created using the CALENDARAUTO function as shown below;

A relationship was then created between the Date table and the Call center data.

ANALYSIS
I had to first, find the Key Performance Indicators - Total number of callers over the month, Average satisfaction score, Average call duration - using DAX functions. The diagrams below show how I was able to find these KPIs using DAX and the Card visual of Power BI;

-Total Calls: The COUNT function was used to count the total calls, as opposed DISTINCTCOUNT that would count the distinct number of callers (i.e ignore if a person had called more than once)

-Average Satisfaction Score: The AVERAGE function was used to find the average.

-Average Call Duration

-Total calls by Channels: this analysis shows the number of customers that contacted the Call center over the month through various communication channels.

-Total Calls by Sentiment: this shows the number of callers by what they think about the services that were being rendered to them.

-Percentage of Total Callers by Reasons: this analysis shows the percentage of the total callers that contacted the call center based on their reasons for calling.

-Total Calls by Response time:

-Total call trend by Day: this chart shows the number of calls received each day of the month, from 1st to 31st of October.

INSIGHT
At "10,639", Call-Center had the highest Total Calls and was 61.79% higher than Web, which had the lowest Total Calls at 6,576. Customers preferred to call the Call center, rather than using the Web or E-mail. This could be because they can get INSTANT response to their queries instead of the waiting time it would take to get a response via the E-mail. Call-Center accounted for 32.30% of Total Calls. The Response Time "Within SLA" had 20,625 Total Calls, "Above SLA" had 4,168, and "Below SLA" had 8,148. 71% of the Total Calls were from customers who called to make inquiries on "Billing". Over 17,000 callers were negative/very negative about the service they got over the month, possibly due to the fact that they were over-charged. It is highly recommended that the organization looks into the rate at which customers are being charged for services.
Three (3) filters were also added to filter out the number of callers from;

• each call channels
• each states
• region

DASHBOARD

Thank you for your time. This report can be found here.
Images on the dashboard were gotten from Flaticon
Dashboard background was designed with Microsoft PowerPoint and be downloaded here
The Call Center dataset can be downloaded here