Power BI End to End Churn Analysis Portfolio Project | Power BI + SQL + Machine Learning | 2024
Vložit
- čas přidán 26. 07. 2024
- #powerbi #dataanalytics #powerbitutorial #machinelearning #randomforest #sqlserver #sqlservermanagementstudio #python
In this complete CHURN ANALYSIS project using SQL Server, Power BI & Python, we will cover a wide range of topics which includes
1. ETL process in SQL Server
2. Data Cleaning in SQL Server
3. Power BI Transformations
4. Power BI Visualization & Enhancing Visuals
5. Build Machine Learning Model - Random Forest in Jupyter Notebook
6. Visualize Predicted Data in Power BI - Predicted Churner Profile
Dataset & Other Resources:
www.pivotalstats.com/post/end...
Below are the Timestamps:
0:00 - Intro
1:03 - Dataset Explained
2:13 - Project Goals & Metrics Required
3:03 - SQL Server ETL & Data Cleaning
19:13 - Power BI Data Load, Transformation, Blueprint & Measures
27:48 - Power BI Visualization - Summary Page
1:07:09 - Building Machine Learning Model - Random Forest
1:29:29 - Power BI Visualization - Churn Prediction Page
SSMS Installation Link:
learn.microsoft.com/en-us/sql...
Anaconda Installation Link (Jupyter Notebook + Python):
docs.anaconda.com/anaconda/in...
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.io/k0OkNv
Cool tech that I use for these videos :
1. Blue Yeti Microphone - amzn.to/43FEYdT
2. LG Ultrawide Curved Monitor - amzn.to/3rEMsR7
power bi dashboard,power bi,power bi dashboard tutorial,power bi tutorial,power bi dashboard design,power bi tutorial for beginners,power bi for beginners,microsoft power bi,learn power bi,sales dashboard in power bi,power bi training,power bi desktop,how to create dashboard in power bi,power bi reports,power bi project,power bi dashboards,power bi report,power bi kpi dashboard,dashboard in power bi,how to power bi,power bi dashboard examples
Hi Sir, It's a really good video. I have a suggestion: instead of loading data into Excel and then using it in Jupyter Notebook, we can directly connect to the database and use that view for our ML algorithms.
Hi, Thanks for a great suggestion. I did consider this earlier and used the pyodbc library to fetch data from server. However this method sometimes gives errors due to accessibility or drivers. So I didn't want the new learners to get discouraged by this, hence decided to keep it simple. Let me know if you have used any other library which makes the process simpler. Will be really happy to learn & use it in my next project. Thank you so much for watching! :)
@pivotalstats Sir, I have used 'from sqlalchemy import create_engine', but you are right; initially, during connection, it gives a really hard time due to drivers.
It is a great end to end project from and getting a understanding about how data is converted from a raw data to visually appealing dashboard.
Thanks alot.👍🏻
Really loved the video. Good way to bring everything under on roof. Looking forward to more such content.
Thanks a ton!
This is awesome!
Thanks 🙂
Bro ure a legend!
Thanks for watching buddy 👍
Wow... Just Wow
Thank you soo much for this wonderful project.....this means a lot
Thanks for watching, cheers!
kia baat ha sir g, you are amazing. thanks for this all. I believe you are the only one on CZcams who provides detailed lectures with full access to data and lecture notes. You did this very professionally. can't be better than this. Just waiting for more and more.
Could you also please make a video on how to develop websites and how to upload all the projects onto it, as you did for yourself. thanks for this amazing work.
Thank you so much :) Reading such nice comments really motivates me to bring more quality content. I don't know if web development related content will be correct for this channel, but I will surely plan a video on creating your portfolio page on github. Cheers!
Respect to the world of India
Cheers!
Thank you sir ❤❤❤
Most welcome 🙂
Hello sir, how are you? We don't talk or chat, but we've learned a lot from your videos. We're very grateful for teaching us, sir. Hope you're doing well and staying healthy
Hello, I'm doing very well. Thanks for asking 🙂. Really glad that my videos are helping. Cheers!
Loved it like a adventure movie ❤
Thanks for watching :)
New to it great work 👍👍
Thanks !
Thanks Bro. one question, why did we create new reference table for Age group instead of creating new column in existing table?
Hi, The main reason is to improve performance because in a reference table we can remove duplicates and reduce the row count. Also in future if I decide to add more mapping columns then its easier to manage in a separate table.
@@pivotalstats great, thanks for the explanation
Hi, Thanks for the wonderful learning video. I'm able to follow and re-create all the charts, I'm just encountering one error in the Churn Reason sheet is showing "The Total Churn" against each of the rows (1732) and also the total is showing as (1732). Please guide.
Hi, Check the table from which you are dragging the Churn Reason column into the visual. Most probably you are using the Prod_Services table. Instead fetch it from Prod_Churn, that will solve the issue. Hope this helps!
Yes, that worked. Also when I changed the relationship between the tables to "both" it worked as well. Thanks for you quick response.
can we use mysql also? as ms sql is not there for mac
hi, check out below link. It should help!
community.fabric.microsoft.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060#:~:text=Before%20you%20can%20connect%20to,MySQL%20in%20Power%20BI%20Desktop.
when i am trying to Train Random Forest Model getting error-ValueError: Input y contains NaN.
,how do i resolve this
The error suggests that the Customer_Status column which is our Y variable (target variable), contains missing values. But in the original data there were no missing values in this column. Could you check if your vw_ChurnData contains null values? If it does then check the ETL process & Original Excel raw data file once more. Hope this helps!
Awesome sir but i don't know much about SQL
Thanks. I have kept it very light in this video but still since sql is an essential skill for anyone working with data, you can watch below sql bootcamp video
czcams.com/video/QDz8be0L2PQ/video.html
you could have easily created age group column in Calculations table rather than creating refrence table
Hi, Yes you are absolutely correct, we can create a calculated table as well using DAX here. Thanks for the feedback!
Sir , provide data file not working on SQL server , error coming. When 1 error is solved, then another error is coming. It is better for us if you provide all 4 data files link.
Hi, May be I did not understand the question, but the data link I provided contains only 1 data file (not 4) i.e. Customer_Data. If you are facing errors even after following all the import process I showed in the video. May I suggest you to import that data directly to Power BI and do the transformations like null removal in the Power Query editor, so that you dont have to waste time on SQL server troubleshooting. Hope this helps!
@@pivotalstats
Sir, the data you provide ,i find multiple errors,
1. Data not loading in SQL server
2. I changed the data structure ,then it loaded same things happened.so i loaded it in my SQL.
3.But multiple things can't be done in my SQL, due data structure.
So , sir if you provide
Main data file , with working data file , 2 view files , then it will be good for me .
Thank you for replying & Understanding the issue
@@SSMB-dw2zr Here you go, this link contains a excel file which has stg_Churn, prod_Churn, vw_Churn & vw_Join data. Cheers!
e3da6ab4-ff6e-4f55-bfa1-a8fb6979d99b.usrfiles.com/archives/e3da6a_ab9ca4f21efb4e6a9c16a94583f064d9.zip
@@pivotalstats thankyou sir
Sir that project is awesome mainly the machine learning portion could you boost yourself to make a more advanced project right now I am finding jobs and they want the best projects because I don't have any work experience. and also sir could you provide me your LinkedIn profile I will tag you with this project.
Hi, Sure I will definitely try to bring another project soon. And my linkedin profile is sajit-simon.
Sir your project is very awesome