Power BI - Forage - PWC Virtual Internship Task 2 - Call centre Analysis
Автор: Snehveer Batham
Загружено: 28 февр. 2024 г.
Просмотров: 14 149 просмотров
Title: Power BI Tutorial: Creating KPIs for Call Centre Analysis | PwC Virtual Internship Task 2
Description:
In this tutorial, I walk you through how to create Key Performance Indicators (KPIs) using Power BI for call centre analysis, specifically focusing on Task 2 of the PwC Virtual Internship Program. Learn how to utilize DAX formulas to measure important metrics like answered calls, resolved issues, and day of the week analysis. Follow along as we explore the step-by-step process of setting up these KPIs to gain valuable insights into call centre performance.
DAX Formulas Used:
Answered = CALCULATE(COUNT(Sheet1[Call Id]),FILTER(Sheet1, Sheet1[Answered (Y/N)]="Y"))
DayOfWeek = FORMAT(Sheet1[Date],"dddd")
Resolved (Y) = CALCULATE(COUNT(Sheet1[Call Id]),FILTER(Sheet1,Sheet1[Resolved]="Y"))
Don't forget to like, share, and subscribe for more Power BI tutorials and tips!

Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: