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.com/spreadsheets/...
🔍 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! 📲

[@drv10_]

Thank you. Great help!

[@snehveerbatham]

Thank you so much for your kind words! I'm glad the video was helpful to you.❣️

[@hiteshigarg1411]

Hi bro , excellent video seriously i had seen someone else long video and your video is short, smart tricks very nice keep uploading such informative videos as i am looking for job in field of data analytics and doing projects makes good learning and have a good resume

[@snehveerbatham]

Thanks for the kind words! Good luck with your data analytics job search. Keep up the project work-it'll strengthen your resume. Let me know if you have any questions or suggestions for future videos! ❣️

[@kallojimeghana]

Hi, I am getting the error as "column 'Answered (Y/N)= "Y" ' in table 'Sheet1' cannot be found or may not be used in this expression.".Could you please help me out.

[@snehveerbatham]

'Sheet 1' is the file name. Please verify your file name and replace it

[@abhangkarode10]

🔥🔥🔥

[@snehveerbatham]

❣️❣️

[@Moniisshhaa]

Excellent!!....where did you learn this tool?

[@snehveerbatham]

Books and KZbin If you think I've helped, please share the link with others. Thanks!❣️

[@P_Devang]

Hii i'm getting the error of "Class not registered". Due to this error data is not loading on the data pane.

[@snehveerbatham]

Greetings The "Class not registered" error in Power BI is often related to issues with the COM (Component Object Model) components that Power BI relies on, or it might be due to missing or corrupt system files. To resolve this issue, you can uninstall Power BI and download it again from the Microsoft Download Center. After reinstalling Power BI Desktop, the "Class not registered" error should be resolved, and data should load correctly on the data pane

[@user-ut8do6fk3q]

what is target and why did you set target as 4.5?

[@snehveerbatham]

I assumed that the "Target" value is based on hard-coded values. So, if you prefer to skip that, it's totally fine; it's not present in the dataset, it's just an assumed value.

[@yuan123]

I don’t understand the language 😢thank you for the sharing, the tutorial is very helpful

[@snehveerbatham]

Thank you so much for watching despite the language barrier! I'm glad you found the tutorial helpful. If you ever need clarification or assistance, feel free to ask here in the comments or connect with me on LinkedIn. I'm more than happy to help however I can. 😊 Linkedin Id: www.linkedin.com/in/snehveerb/

[@ramakrishnag6764]

Can you share the PowerBI dashboard files which you have uploaded in the task...

[@snehveerbatham]

Definitely Brother drive.google.com/file/d/1kdWX_79Wlq8D1VRmru_xcT5ZdyoZ026Z/view?usp=sharing If you think I've helped, please share the link with others. Thanks!❣️

[@ramakrishnag6764]

@@snehveerbatham Thanks bro, Is this single file is enough for completing Task 2, 3 & 4.

[@snehveerbatham]

No, bro. Task 3 file: drive.google.com/file/d/1oGVqToXRVhAMSHgimRMvpfInzHX4rd6p/view?usp=sharing You can download it from this link, and Task 4 will be uploaded soon. Right now, I'm not feeling well, so it's delayed from my side. sorry for inconvenience You can also watch Task 3 videos: part 1: kzbin.info/www/bejne/bKinZYuJa7mpacU part 2: kzbin.info/www/bejne/d5ezg5eOf9eiaJI

[@SandeepDevkatte0]

Hello bro my small suggestion Avoid background tone because your talking with low voice 😊

[@snehveerbatham]

Thank you for your valuable feedback bro! At that time, I was learning editing, so I made many mistakes. But now, I will try to give my 100% to deliver better editing and content. Thank you so much for loving my content. I hope you watch all my videos and continue to give valuable feedback. Your feedback helps me improve and deliver better content.❣

[@aryanrajnit-agartala6889]

3:32 pe kpi use karne par value show nhi kar raha hai Trend axis and target maang raha hai. Kaise karu . Please help bhaiya

[@snehveerbatham]

Hello Bhai, Bhai, ek baar na ap speed of answer wala formula check karo. Shayad waha kuch error aa raha hoga. Agar phir bhi nahi hota hai toh mujhe batana, mai karwa dunga.

[@salini8140]

Use row card instead

[@ayeshasyedKhan]

what about null values?please reply

[@snehveerbatham]

In this scenario, I handle null values by treating them as zero. For example, when using the gauge chart, null values are interpreted as zero. You can replace null values with zero across the dataset. For columns containing characters, you can use 'NA' to denote cells with no value. The approach depends on the specific data and organizational needs. If the organization opts to remove null values, we follow that approach. Alternatively, if they prefer to convert nulls to zero or mark them as 'Not Available,' we adjust our method accordingly.

[@beautyworld8398]

Ok thanks.... thanks for explanation

[@snehveerbatham]

@@beautyworld8398 Welcome🙌🙌

[@NehaKourCSE__]

share csv file

[@snehveerbatham]

docs.google.com/spreadsheets/d/1TDjMMGt4_K0SvGBnrhYdxIfHxdL9MSRF/edit?usp=sharing&ouid=112992323959192473929&rtpof=true&sd=true

[@manaschaurasia2554]

Hi Joy , are you working somewhere?

[@snehveerbatham]

Greetings sir Actually right now I'm looking for it.

[@ramakrishnag6764]

@@snehveerbatham Can you share the PowerBI dashboard files which you have uploaded in the task...