Forage PWC Virtual Internship Task 2 | Call centre Analysis | Power BI

🚀📊 "Unlock Call Centre Insights with Power BI! Learn to Build KPIs | PwC Internship Task 2" 📊🚀
Dive into the world of data analysis with this viral Power BI tutorial! 📈 Join me as I unveil the secrets of creating Key Performance Indicators (KPIs) for call centre analysis, specifically tailored for Task 2 of the PwC Virtual Internship Program. 💼 Master the art of leveraging DAX formulas to measure critical metrics such as answered calls, resolved issues, and even day-of-the-week analysis. 📅 Follow along as we unravel the step-by-step process of setting up these KPIs to unlock invaluable insights into call centre performance. 💡
💡 Don't Miss Out! Learn these Essential DAX Formulas: Answered ✔️, DayOfWeek 📅, Resolved (Y) ✔️
Dataset :
docs.google.co...
🔍 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! 📲