Please download Data from github

[ Ссылка ]

Here is a tutorial about how to create a Power BI KPI on the PWC Virtual Internship Program (Task 2).
Measure Used (DAX Formula)

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"))

Average Handling time = AVERAGE(Sheet1[AvgTalkDuration])*24*60*60

Hope this tutorial Helps. Sorry for the No Voice instructions, Mic is capturing too much Noise.





#powerbi #microsoft #businessintelligence #excel #dataanalytics #datascience #data #tableau #datavisualization #sql #dashboard #office #analytics #python #business #dynamics #bi #software #bigdata #digitaltransformation #azure #dataanalysis #powerapps #machinelearning #technology #dashboards #microsoftpowerbi #o #cloud #businessanalytics

свернуть