End to End Power BI Call Center Analysis

preview_player
Показать описание
This is Call Center Analysis Reports.

In this report, I have created the following KPIs.
1.Overall Calls/Overall Clients.
2.Overall Answered Calls
3.Overall Abandoned Calls
4.Issue Resolved Calls
5.Agent Performance Quadrant
6.Avg Speed of Answer
7.Not Issue Resolved Calls
8.Satisfied Calls
9.Call Answer %
10.Call Abandoned %
11.Not Satisfied Calls
12.Resolved Issue %
13.Not Resolved Issue %
14.Avg Call Duration Time.

In which I have created following Pages.
1.Call Analysis.
2.Agent Analysis.
3.Customer satisfaction analysis.
4.Summary

Here is the link to download this file.
Рекомендации по теме
Комментарии
Автор

How can we replace null values in dataset to blank??...not zero just i want to keep it blank bcz its creating difference in value while calculating avg call diration if null values are replace with zero

swagatikapatel
Автор

Hi bro, superb dashboard with full of insights.
I just wanted to ask you one thing how did you put that "sec" in 'Avg Call Duration Time' column in agent analysis report.
Thanks for sharing.

aamirmansuri