Forage PWC Virtual Internship Task 2 | Call centre Analysis | Power BI
ฝัง
- เผยแพร่เมื่อ 16 ก.ย. 2024
- 🚀📊 "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! 📲
![Forage PWC Virtual Internship Task 4 | Diversity & Inclusion | Power BI [HINDI] | Part 1](http://i.ytimg.com/vi/N0UyuY2dRm8/mqdefault.jpg)
Unlock Your Data Science Success: Insider Tips from Expert Yash Singh!
th-cam.com/video/JblhDzMt2Uc/w-d-xo.htmlsi=TEsCDfXFk39XOvLi
Thank you. Great help!
Thank you so much for your kind words! I'm glad the video was helpful to you.❣️
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
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! ❣️
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.
'Sheet 1' is the file name. Please verify your file name and replace it
I don’t understand the language 😢thank you for the sharing, the tutorial is very helpful
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/
yeh sab kaise pta chala ki kab kahan kya use krna hai (info as values) and fonse form mein present krna hai like table chart etc
Bro, time ke saath sab aa jayega. Jab tum dheere-dheere projects karoge, to tumhe samajh aane lagega ki kaunsa chart kahaan lagta hai aur kyun lagta hai. Sabse pehle, question ko achhe se samjho-samajhne ki koshish karo ki usko kya chahiye. Aur haan, basics ko achhe se strong kar lo, kyunki basic strong hoga toh hi tum advance level ka analysis kar paoge.
Hello bro my small suggestion Avoid background tone because your talking with low voice 😊
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.❣
Excellent!!....where did you learn this tool?
Books and TH-cam
If you think I've helped, please share the link with others. Thanks!❣️
Hii i'm getting the error of "Class not registered". Due to this error data is not loading on the data pane.
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
what is target and why did you set target as 4.5?
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.
Can I apply for this internship. Now. ?
Yes
Can you share the PowerBI dashboard files which you have uploaded in the task...
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!❣️
@@snehveerbatham Thanks bro, Is this single file is enough for completing Task 2, 3 & 4.
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: th-cam.com/video/6wD4XS6Tv3c/w-d-xo.html
part 2: th-cam.com/video/AfPRdXJro20/w-d-xo.html
🔥🔥🔥
❣️❣️
Why I don't have drop-down option in slicer settings
Hey there! If you're not seeing the drop-down option in your Power BI slicer settings, there are a few things you might want to check:
Slicer Type: Double-check that your slicer is set to the correct type. The default is usually a list, so you might need to change it to 'Drop-down.' Just click the little down arrow at the top-right corner of the slicer and select 'Drop-down.'
Power BI Version: Are you running the latest version of Power BI? Sometimes, older versions don’t have all the features or options might be in a different place.
Data Type: The kind of data you're working with can affect what options are available. If the data isn’t suitable for a drop-down, you might not see that option.
Custom Visuals: If you're using a custom slicer visual, it might not support drop-downs. Try switching to the default slicer visual and see if that helps.
Visual Settings: Sometimes, the drop-down option can be hidden in the visual settings. It’s worth checking out the format settings for your visual to make sure everything's configured correctly.
Technical Glitch: If all else fails, it could be a browser or app bug. Try refreshing your browser, clearing the cache, or restarting Power BI Desktop.
Hope that helps! Let me know if you're still having trouble. 😊
@@snehveerbatham Still not solved "the drop down option invisible"...I am running the latest version of power bi
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
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.
Use row card instead
what about null values?please reply
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.
Ok thanks.... thanks for explanation
@@beautyworld8398 Welcome🙌🙌
Hi Joy , are you working somewhere?
Greetings sir
Actually right now I'm looking for it.
@@snehveerbatham Can you share the PowerBI dashboard files which you have uploaded in the task...
share csv file
docs.google.com/spreadsheets/d/1TDjMMGt4_K0SvGBnrhYdxIfHxdL9MSRF/edit?usp=sharing&ouid=112992323959192473929&rtpof=true&sd=true