End to End Power BI Project - Customer Churn Analysis | Power BI Mastery
Vložit
- čas přidán 5. 08. 2024
- In this video, you can follow-along, to create and publish a complete Power BI Report for Customer Churn Analysis. The is a completely hands Power BI Report tutorial, for beginners, to go from raw data to a finished report.
In this video, we take Bank Customer Churn dataset and go through the end-to-end process of developing and publishing the Customer Churn Analysis report in Power BI, including the following steps:
1. Data Connection
2. Data Preparation
3. Data Modeling and Analysis
4. Data Visualisation
5. Report Sharing and distribution
Chapter links:
00:00 Introduction to the Power BI Project
00:54 What is Customer Churn Analysis?
01:48 Understanding the source data
04:01 Using GET DATA for Data Collection
05:45 Data Preparation - Cleaning, formatting and reshaping the data
23:00 Data Modeling - Create Queries to model your data for Analysis and Visualisation
33:05 Model View - Review and edit relationships
34:45 Data Analysis - Create measures using DAX
39:13 Data Visualisation - Choosing & formatting the visual elements
55:05 Enhance the report - using & customising Themes
1:11:43 Save & Publish report to Power BI Service
1:13:37 Recap of the key-learnings
Exercise Files:
Download Bank Customer Churn Data:
tinyurl.com/z4r3mv34
Subscribe and hit the bell icon to get notified of the next video: @biwithgurpreet - Věda a technologie
Hi Gurpreet, have just come across your channel. Thank you for taking the time to construct interesting and insightful content which is delivered with such clarity. I particularly appreciated the quality of your recording. I quickly disengage with channels that offer poor visual and audio quality. You delivered excellence in both these areas. I hope you have great success in growing your channel. Have subscribed and I look forward to expanding my Power BI skills with your help.
@cazvon4346 Hi Caz, thanks for the appreciation. Best wishes
Fantastic tutorial. Super clear and easy to follow. You are an excellent teacher!
This video is under rated. It ought to have gotten over a million views. I am thrilled by the simplicity of your teaching. Take your flowers please💐💐💐💐💐
Thank you Paji. I have gone through your project video. I am very much thankful to you for uploading this. It has helped me a lot. It will be greatful if add more difficult project video for practice.
Again thank you PAJI....🙏
Amazing, the way you did the complete process from scratch and explained each topic. Thank you!, Please upload a video on another POWER BI project in the FMCG Domain. Today I learned so many basic things and concepts that we need to follow during the analysis. Thank you once again, the way you teach is simply awesome! 👌👌💐💐
Sir, please upload more project.I am a new subscriber .Really liked your portfolio projects,Expecting more video.Thank you so much
Really,Appreciated your work❤
Thank you from Kenya
Amazing content and the way you teach is flawless .Thank you Sir for sharing with us 🤩👍
Glad you liked the tutorial. Thanks for sharing your feedback
Thank you so much. I have benefited so much from this lecture. I have created mine exactly yours. Once again, thank you thank you.
I am glad that it was beneficial for you. Thanks for the appreciation
It's really helpful
Thank you Sir 🙏🙏 Learnt A Lot From This Video.
Glad you found it useful. Thanks
Thank you very much paaji. It's making my learning journey easier and more understandable.
Glad to hear that
I have seen so many videos but this one is really nice as it is not just about creating visuals but also about ho to handle or manage the data properly!! Please sir make video on cleany messy data as well. Thank you!!
That’s great! Thanks for sharing your feedback
Brilliant class Sir, really learned alot and how you explained is really worth more then gold, looking forward to other videos of you
Thanks Vivian
Thank U soo Much Paaji ....very Helpful
Hi Yogesh - Thanks for sharing the appreciation
Really enjoyed the project.
That’s great. Thanks
thanks
Got lot of learnings sir Thankyou soo much ❤️
Glad it was useful. Thanks Vishal
Good project
Thank you a lot sir ji for ur explation bring me understand full power BI in a single lecture you taught more than my tutor taught
I am so glad that my content helped you on your Power BI journey. Best wishes
@@biwithgurpreet sir please upload more projects 😃
It was really helpful and thanks for your guidance
Your positive feedback is greatly appreciated
Subscribed
Thank you for a fantastic tutorial. It's really helpful practising along. Much appreciated.
I have a question about the groupings created for the Account Balance category at the beginning. Could you help me understand how the groupings were decided?
In the 'Add conditional column' window, I noticed that there is an overlap between the upper bound of a clause and the lower bound of the clause after it, for example, 1-1k and then 1k-10k. If we were to have someone with an account balance of 1k, it seems uncertain which grouping they would be in.
Great job 👍
Thanks
thanks for this good video. please do examples with large datasets. challenges are different
Acknowledged
Fantastic brother 👏👏👏
Thanks brother
in the data set activity status of the customer is active and churn status of the customer is churned ,is it possible?
Hi,
I want to write Dax to give rank from asc to desc and should not give the same rank if the value is same, it should give the next number to it.
can anyone help?
Hi , when I add the conditional formatting for the credit scores column exactly like how you have done, I'm getting 7 null values. How do I rectify this. Kindly help me solve this
Thank You Sir for such useful videos. Please post videos on DAX
I am glad that you find the videos useful. Will be covering DAX as well in future videos
@@biwithgurpreet thanks 🙏
That's a great video.
Thanks Sunny
@@biwithgurpreet I think you are from U.K, can you suggest some university for master in data analytics/ data science in U.K.
when you are creating reference table from balance what happen to the index 2 which was assigned to 1-1k. how do you resolve it?
Amazing video sir. If you have finished power BI file, pls provide the link.
sir, In the relationship model, the age relationship is missing with customer data, how to solve that?
wonderful video
i am getting values for the Age Group ID col as null except > 71 = 7 how to fixx this please
Punjabis rock🤩🤩🤩Sat shri akal from punjab😁😁😁
sat Sri akal ji 🙏🏽😊
In the Age Groups ID section at 26:32, even after putting the conditional column exactly as shown, I am getting null values in
Me too
I really appreciate your efforts for the project, it's actually what I was searching for but your division of categories is very confusing. It's showing null in the age and credit score columns.
👍
Please also do RFM and LRFM analysis on customer Sir.
Thanks for the suggestion. Will do that in near future
@18.00 in the age group I'm getting Null before 21 - 30 age group sir.
Hello Gurpreet, I'm trying to find solution with this project. But my data source has more columns than yours such as: Card Type (Diamond, Platinum, Gold, Silver), Complain (1, 0). My goal is Analysis of Customer Churn Relationships is my goal. I hope that you will give me some recommendation. Thank you so much
How can download the dataset???
Sir what is the formula of customer lost... Please tell me sir
Sardar G chass kraa diti es tutorial ny
Thanks
Plz explain logistics and finance proj in bi
I will do that in due course.
Great informative video but can you also guide how to upload the video to LinkedIn without having a Power BI service
Secondly create a video with DAX function and focusing on Relationship model between 2 tables
Thanks Varun. Regarding your query, could you please clarify what is it that you want to upload to LinkedIn?
@@biwithgurpreet The same Power BI projects.
If one does not have a Power Bi service how and what is the process or way that one can upload on Websites where the recruiters of Companies wanting to recruit Power Bi people at entry level or any level can see the projects and then can communicate for further Interview calls etc
can i add this as a project done on my resume?
Definitely. I hope it helps. Best wishes
Also when I’m creating the Gauge Visual after creating the Min, Max and Target %Values, when I’m putting the same in the Visual, the Gauge Visual is showing incorrect.. Is there a way wherein you can help me in knowing what is going wrong if possible?
You can connect with me on Instagram (@biwithgurpreet) and DM with the details of the issue, including screenshot
@@biwithgurpreet Please reply to my query I sent to you on your Instagram with screenshot attached 5 days ago
Double checked again. Haven’t received your query. Are you following @biwithgurpreet? What’s your IG id?
@@biwithgurpreet Yes I am following you on CZcams as well as Instagram
@@biwithgurpreet Please check I sent it along with 3 screenshot 6 days ago
Encontre ORO
Load
Customer Data
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
Age Groups
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
Account Balance Groups
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
Credit Score Groups
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
Close
STILL FACING THE ISSUE