Forage PWC Virtual Internship Task 3| Churn Analysis | Part 1 | Data Analysis Project | Power BI

🚀📊 "Unlock Forage PWC Virtual Internship Task 3| Churn Analysis | Part 1 | Data Analysis Project | Power BI" 📊🚀
Dataset:
docs.google.com/spreadsheets/...
Ready to dive into the dynamic world of data analysis? Join me in this viral Power BI tutorial as we uncover the secrets behind creating Key Performance Indicators (KPIs) for call centre analysis, specifically tailored for Task 3 of the PwC Virtual Internship Program. Master the art of harnessing 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.

[@sde143]

Thank you so much for sharing and guiding.

[@snehveerbatham]

You're welcome! I'm glad you found the video helpful. If you have any questions or need further guidance, feel free to ask!

[@advaithegde]

Thank you for sharing this informative video.

[@snehveerbatham]

You're welcome! I'm glad you found the video informative. If you have any questions or need further assistance, feel free to ask!

[@diyagangar3943]

Hello I have a question .The values of the KPI is not displaying they are asking for to enter some target axis despite of the values displaying exactly the same as it is in the table format .Thank you

[@snehveerbatham]

Greetings Is this problem happening with all KPIs or with a particular KPI?

[@diyagangar3943]

@@snehveerbatham All the KPIs

[@snehveerbatham]

Can you share the file with me so I can easily identify the problem and provide you with a solution? [e-mail]

[@ramakrishnag6764]

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

[@snehveerbatham]

drive.google.com/file/d/1oGVqToXRVhAMSHgimRMvpfInzHX4rd6p/view?pli=1

[@RohitSharma-rv7cr]

could you explain this % counts of subscription measure

[@snehveerbatham]

If I understand correctly, you're referring to the %count of subscriptions. If you're discussing another calculation, please specify the timeframe so that I can identify which calculation you're referring to. First, I navigate to the Home ribbon and click on 'Transform Data,' which opens Power Query. Then, in the Power Query ribbon, I select 'Add Column' and choose 'Conditional Column.' Here, I calculate the tenure of subscriptions. For instance, if the tenure is less than 12 months, I label it as '< 1 year,' and if it's less than 24 months, I label it as '< 2 years,' and so on. This process gives me the tenure of each subscription. Next, I name this new column 'Subscription' and use a horizontal bar chart. I place 'Subscription' on the y-axis and 'Churn' on the x-axis. I modify the churn values to display them as percentages. This allows me to visualize the %count of churn by subscription

[@yolandazhu4978]

Great video!!👍 I have a question. You created several measures for Service Customers Signed up, then you only used four of these measures, why did you choose those four, which are Online Backup, Online Security, Phone Service, and Streaming Movies? Thank you.😀

[@snehveerbatham]

Thank you for your feedback. And I have only used those four measures for the explanation, its totally upto you, you can use all the measures of your choice or even you can add all the measures. Also, I would like to introduce you to our job portal (hjobs.in) which have launched recently. You can visit the website hjobs.in if you are looking for data field jobs like data science, data analyst, data engineering, etc. with day-to-day updates.

[@usuis8541]

Thank you so much but i think the music was unncessary your explanation is good.

[@snehveerbatham]

Thank you for your feedback and support. I appreciate your honesty and will focus more on the details. I'll work harder to create content that you enjoy. Your encouragement means a lot to me!❣❣

[@usuis8541]

@@snehveerbatham if the DAX expression was in the description/comment section it would help! thanks a lot you did great guiding!!!

[@snehveerbatham]

Thank you so much for your feedback! I'll make sure to include DAX expressions in the description/comment sections moving forward. ❣❣❣

[@Saumyaa441]

how do you understand which section to add and which one should be left and how do you choose the perfect chart for the same?

[@snehveerbatham]

When you open the Forage PwC project page, you'll discover the assignment detailing what stakeholders expect from you. In the next section, you'll find the types of charts and cards they prefer, along with instructions on how to utilize these elements. External links are provided to help you understand how we intend to use charts and cards within the canvas. Additionally, other insights come from experience, so be sure to utilize a variety of charts accordingly.

[@Saumyaa441]

@@snehveerbatham From where did you learn Power BI? have you purchased any courses?

[@snehveerbatham]

Through KZbin videos and books, you can refer these books.. Microsoft Power BI Cookbook Learn Power BI Beginning DAX with Power BI.

[@Saumyaa441]

Thank you

[@Saumyaa441]

Can you please also suggest some KZbin channels.

[@gurukiran4376]

Bhai apne background music ke badle me bol kar explain kiya hotha tho accha rehtha yaar

[@snehveerbatham]

Thank you for your valuable feedback bhai! At that time, I was learning editing, toh maine bht mistakes ki hai. But ab try kar raha hoon ki 100% better editing and content dene ka. Thank you so much for loving my content bhai. I hope you watch all my videos and continue to give valuable feedback. Your feedback helps me improve and deliver better content.❣