I never ever saw before the best project of data analyst in youtube . sir after watching this video , i am depending on your youtube channel for learning and data analyst job. i consume your video every day for learning. thank you so much for giving us best content with free of cost.
Thank You Swapnjeet for this SQL+Power BI Project. This is really going to help beginners like me to understand the real world scenario of Data Analytics.
@riasingh11 can you tell me please what is the use of SQL and SQL queries to build the dashboard. I am so confused about this. Anyone who have answer this please tell me
@@shubhamjoshi2492 The purpose of this is to compare querying and calculating data when creating a dashboard in Power BI with data calculation using SQL. If the results from both methods match, then the accuracy of the data when building the dashboard can be fully trusted
Undoubtedly, One of the best Dashboard i came across on You Tube. Each and every single thing is explained meticulously. I'm sure it takes lot of time and efforts to build such amazing Dashboards and also recording it along with. Kudos to you! Thank you:)
Thank you so much Sir for such an amazing content. Since 11:30 PM to 12:00 PM(Midnight to Midday), this 4 hour video took more than 12 hours but it definitely boost my confidence in Power BI.
Thank you so much, i have been watching your Power BI videos and learned a great deal directly through hands-on experience through your video. Kudos.. Keep it up you are helping lots of individual learners like me
Great video! I see many comments why MTD is coming 1 instead of 4.3k, the reason is in our dataset we have only single loan application from December. so, better to shift mtd to novmber and pmtd to october.
the MTD value is showing 1 when I use month in formula, but its fine when I use Day instead of month in SQL, there is a issue with issue_date column! So I had to skip MTD and MOM in Power BI Dashboard.
I m in baking domain only..sometimes we need SQL query for suppose we are in Dec month ..so total sanction or disbursement amount for mtd or from April till December (ytd) and date in varchar so convert to date and disbursal amount to float i.e disbursal amount:: float
Thank you so much for this amazing video ❤..But, I have one question..if you have already created sql query for the same..why don't u use directly to power bi rather importing csv file?. Hoping for the reply plz.
SQL and Power BI go hand in hand. In real time you need to connect Power BI to a DB or a Cloud server. And all reports creates in Power BI are tested either using SQL queries or in Excel
I'm unble to track this Mesure Percentage, when give it to card it's showing Blank only. in my dataset everythoing is good Good Loan% = (Calculate([Total Loan Application], BankLo[Good V Bad] = " Good Loan" )) / [Total Loan Application]
I think in calculation total payment received MTD that is based on last payment date. But u told, select sum(total _payment) from bank_loantable where Month (issue_date)=12
All Date columns which are there in CSV file, the date type is text and we are able to change it to Date type, but MTD values are not matching with your MTD values. Please let us know what can we do ?
DateTable = CALENDAR(MIN(financial_loan[issue_date]),MAX(financial_loan[issue_date])) i write this dax but i get errer as A table of multiple values was supplied where a single value was expected.
i have the problem with MTD, only showing 1 instead of 4k. I already format the column with date and the issue date also contains more than 1 row for month 12. Can anyone explain?
The date(issue_date) provided in the link is not in date format.First convert this text into date format through powr quer editor.When click on 123 on the top of column then select locale ,then change text to date and change english US to english Indian or Pakistan. i hope you got it.
Thank You a lot for the tutorial and for sharing precious knowledge with us for free! It was really great help! Like, subscribe and I will follow your new tutorials!
Sir everything is working good but except map i tried to changed it with other maps to but maps are not changing according to application,fundes and received not with any of them what should i do?
SELECT COUNT(id) AS Total_Applications FROM financial_loan WHERE MONTH(issue_date) = 12; my output is showing 1, ur's is 4314 I changed the date format, and tried different things but still ita showing 1, could u please help me?.
Can I buy this project? I was working for this project from 3-4 days but it doesn't save yet My whole hard work 😔 gonna waste I have totally completed this project on time plz suggest me some idea by that I can recover this ????????? I have been preparing it for my 2 round interview the company demanded to me this type of project work plz help me
select count(id) as PMTD_total_loan_applications from financial_loan where month(issue_date) = 11 and year (issue_date) = 2021; while using this query the answer is loading as null
@@datatutorials1 financial loan and i rectified the query, thank you response over me and it is one of the best tutorial ever i have seen. Thank you for making this.
Hello Sir, Here we have calculated average interest rate as simple average of all interest rates. Shouldn't this be weighted average having loan amount as weights and then calculating average interest?
Trying to reach out through your whatsapp number but not getting any respond from your side though you told to ask on weekends i did the same an no response from your side
@datatutorials1 sirji I was completely unaware of it yes do understand your priorities and your commitment towards your family. Surely will msg.you again.
The most comprehensive Data Analysis Video ever found open source. Great Work!!!!
I never ever saw before the best project of data analyst in youtube . sir after watching this video , i am depending on your youtube channel for learning and data analyst job. i consume your video every day for learning.
thank you so much for giving us best content with free of cost.
Thanks and welcome
Thank You Swapnjeet for this SQL+Power BI Project. This is really going to help beginners like me to understand the real world scenario of Data Analytics.
Glad it was helpful!
One of the best and most comprehensive tutorials so far on this subject that I have ever seen 👌
Indeed best video to learn and build on power BI, Great work.
This project took me 12 hours to complete because there are so many data type issues.
But it was an awesome project
@@riasingh11what sort of data problems
@@brandyplays6134 I had date data type issues, idk if anyone else had it.
@riasingh11 can you tell me please what is the use of SQL and SQL queries to build the dashboard.
I am so confused about this.
Anyone who have answer this please tell me
@@shubhamjoshi2492 The purpose of this is to compare querying and calculating data when creating a dashboard in Power BI with data calculation using SQL. If the results from both methods match, then the accuracy of the data when building the dashboard can be fully trusted
Undoubtedly, One of the best Dashboard i came across on You Tube. Each and every single thing is explained meticulously. I'm sure it takes lot of time and efforts to build such amazing Dashboards and also recording it along with. Kudos to you! Thank you:)
Mate.. You are GOD of DATA
Thank you so much Sir for such an amazing content. Since 11:30 PM to 12:00 PM(Midnight to Midday), this 4 hour video took more than 12 hours but it definitely boost my confidence in Power BI.
Your learning method is best with all meaningful information
Have you done this project. I'm getting mismatch data while calculating MTD loan application
Thank you so much, i have been watching your Power BI videos and learned a great deal directly through hands-on experience through your video. Kudos.. Keep it up you are helping lots of individual learners like me
You deserve Millions of views for helping us
Best Video For a project can be made
Hats Off to u 👏👏
Thanks you for commenting
It was my first project 🙏🏼
Thanks for the video. Can you please share the Problem Statement document as well. 18:02
By this i can able to report for Banking Domain Thanks for sharing the document
Superb Explanation. Thank you Sir
Great video! I see many comments why MTD is coming 1 instead of 4.3k, the reason is in our dataset we have only single loan application from December. so, better to shift mtd to novmber and pmtd to october.
Hello sir ,You have all type of videos playlist except power bi service please make a detail video on power bi service on real time project work
Great effort as always, thanks Swapnjeet
This is great analysis. Please create another video on loan analysis
Sure
Thanks for sharing this awesome project.
the MTD value is showing 1 when I use month in formula, but its fine when I use Day instead of month in SQL, there is a issue with issue_date column! So I had to skip MTD and MOM in Power BI Dashboard.
Great video 👍 I have learnt a lot. Thank you so much for this tutorial 🙏. Waiting for more tutorials further.
More to come!
U r using mysql??
I m in baking domain only..sometimes we need SQL query for suppose we are in Dec month ..so total sanction or disbursement amount for mtd or from April till December (ytd) and date in varchar so convert to date and disbursal amount to float i.e disbursal amount:: float
please request you, make video on realtime dashboard on SQL+ power bi
This is a realtime data set
think he may mean using directquery?@@datatutorials1
Thanks a lot Sir
Hi Request to upload course from scratch powerbi and sql , or atleast dax please your teaching style is supergood
Tq bro to provide such a wonderful project
It's my pleasure
Will watch it from my desktop
what are the key insights and how to mention this in resume ?
Thank you so much for this project!
Yes great video. I have learnt a lot. I thought I knew power bi
Thankyou sooo much , it was very helpful. I learned a lot of things!
Great video ,got so much to learn
Thank you sir.🙏
Wow finally tha long waited Vedio is out .! Thanks a lot sir ..! Seriously ur doing an awesome job and helping so many ppl . Long live sir ❤
Sir why am I getting MTD loan applications 0 . Kindly reply
because of the issue_data type is text... you have to convert it into date type first.
Which databtype we need to give for that could you please explain its helpful @@sushantkanojia21
@@sushantkanojia21 but how to convert it . please help me ?
The data type for date should be date, you can convert it in power bi
@@knavneetraj3168 for sql or power Bi?
MTD values showing 1, how to FIX it?
great content
Super
The MTD is not showing any values in the card,.Its showing blank values.(2hr 15 min video time ) Please guide
@pratikjugantmohapatra18 where you able to fix it
Same problem for MOM is not showing values
Same as mine
Same problem with me
@@gkapadi9831 after some corrections i got it i have done mistake in measures.
Hii.. Thank you for this tutorial. Can you please suggest me some charts to visualise target vs actuals in sales data
Bro! Honestly You doing really a good amount of hard work for us.
Your Videos are really best for learning
Really Big thanks for the effort 🙏
Glad you liked!
Thank you so much for this amazing video ❤..But, I have one question..if you have already created sql query for the same..why don't u use directly to power bi rather importing csv file?. Hoping for the reply plz.
SQL and Power BI go hand in hand. In real time you need to connect Power BI to a DB or a Cloud server. And all reports creates in Power BI are tested either using SQL queries or in Excel
thanku for amazing concept , Please make CRM Dashboard in power BI
I'm unble to track this Mesure Percentage, when give it to card it's showing Blank only. in my dataset everythoing is good
Good Loan% = (Calculate([Total Loan Application], BankLo[Good V Bad] = " Good Loan" )) / [Total Loan Application]
I think in calculation total payment received MTD that is based on last payment date. But u told,
select sum(total _payment) from bank_loantable where Month (issue_date)=12
good
Sir plz make end to end project on power bi +postgreSQL
Ok aure
All Date columns which are there in CSV file, the date type is text and we are able to change it to Date type, but MTD values are not matching with your MTD values. Please let us know what can we do ?
I am also face this problem . If you found out this solution. Please let us know ...
DateTable = CALENDAR(MIN(financial_loan[issue_date]),MAX(financial_loan[issue_date])) i write this dax but i get errer as A table of multiple values was supplied where a single value was expected.
Have you validated your data?
I experienced same from the beginning, then I validated my data as well.
i have the problem with MTD, only showing 1 instead of 4k. I already format the column with date and the issue date also contains more than 1 row for month 12. Can anyone explain?
The date(issue_date) provided in the link is not in date format.First convert this text into date format through powr quer editor.When click on 123 on the top of column then select locale ,then change text to date and change english US to english Indian or Pakistan. i hope you got it.
@@PaiseWalaBanda924 this is not working . Error showing in issue date coloumn
I'm doin it in mysql i'm having a lot problems in getting the right output after writing the correct query also
Thank You a lot for the tutorial and for sharing precious knowledge with us for free! It was really great help! Like, subscribe and I will follow your new tutorials!
Sir everything is working good but except map i tried to changed it with other maps to but maps are not changing according to application,fundes and received not with any of them what should i do?
Check in preview features option if all the map related check boxes are enabled
Could you please do this on healthcare organization dataset too
Very nice...
What is the source of the dataset please?
@SWAPNJEET Thanks for the amazing content.
Welcome!
Make sure you change the date format from DD-MM-YYYY to MM-DD-YYYY.
Where is the excel file uploaded plz let me know
SELECT COUNT(id) AS Total_Applications FROM financial_loan
WHERE MONTH(issue_date) = 12; my output is showing 1, ur's is 4314 I changed the date format, and tried different things but still ita showing 1, could u please help me?.
Which database u r using and what are number of records imported in db
I am having same issue, I think the problem is that all the dates are not in the same format.
@@datatutorials1 I have the same number of record imported with yours but MTD = 12 is returning 1
@Data_Spec. Please convert all date to date format and retry
@@datatutorials1 I have converted but still the same thing. I really appreciate if you can help check the filed you uploaded to google drive.
Brother some off the queries are not working on MySQL work bench
On the Dataset some loans are said to be "fully paid" where in fact there was a significant amount of loan was left unpaid. why is that?
In Avg Dti KPI ...it is showing error - the function average cannot work with values of type string
How to get the data for practice
Hey, do you think I can use this project in my resume? I will not get any copyright issues. plz reply
37:41 use VARCHAR(MAX) in emp title
shape map is not available how to get it?
Can anyone explain why am I getting MTD and PMTD loan applications as 0
you have solution for this?
MTD values showing 1, how to find it?
Can i do in sql server
in my power bi shape map is not showing
Turn it on from preview feature
Can I buy this project?
I was working for this project from 3-4 days but it doesn't save yet
My whole hard work 😔 gonna waste I have totally completed this project on time plz suggest me some idea by that I can recover this ?????????
I have been preparing it for my 2 round interview the company demanded to me this type of project work plz help me
Mail me i can help you
hi swapnjeet . i cant fine data set the link you provided
Check description again
So what is the point of using SQL? Just to confirm the made calculations in Power BI?
Asking the same question
Sql queries are executed to cross verify the results that we get by creating measures in power bi
select count(id) as PMTD_total_loan_applications from financial_loan where month(issue_date) = 11 and
year (issue_date) = 2021; while using this query the answer is loading as null
What db you are using
@@datatutorials1 financial loan and i rectified the query, thank you response over me and it is one of the best tutorial ever i have seen. Thank you for making this.
How you resolve this query actually iam facing the same issue over here can you explain@@user-vf6vj9hw6u
Kindly cpu or laptop recommend kr dy mera laptop buhat slow hy change karna chahta hum
I am learning Data Analytics and I hope that everyone who is watching this video is also learning. Would anyone like to share their LinkedIn IDs?
Bhai excel sql and power bi learning chal raha hai
Excel ka content hai kya?
Sir for the 2nd query that is for total loan applications by MTD, for 12th month its only 1 application, even in excel also its giving one only
Which data base are you using to fire queries
@@datatutorials1 MS SQL only, the one that you are using
The problem is with the date column in excel sheet, for december month its showing only 1 row
I can't find the dataset in the data download folder.
Can anyone help me with the dataset?
Its available please check again
29:32 Where I can get this MS Word to gain some knowledge on Banking Domain
Link available in description box, all material at one place, you can download it from there
sir mere power bi mein upar woh signs show hi nahi hote format mein kaise enable kru pata hi nahi chal raha
bhai file upload hone me kitna time le raha hai koyi fast tarika nahi hai kya jisse file jaldi upload ho jaye?
Where I can get the data set
Available in description of video
bro when i calculate MTD it takes TOTAL COUNT , please give the solution for it.
Follow steps in video
can you share free power bi course ?
I think this project you already covered .
No I didn’t, was uploaded for SQL, tableau and excel
too many ads🤧🤧🤧🤧
Hello Sir,
Here we have calculated average interest rate as simple average of all interest rates.
Shouldn't this be weighted average having loan amount as weights and then calculating average interest?
Nice one. Can you do this for Tableau?
For Tableau already uploaded on my channel 😎
Thankyou for reply. You're awesome@@datatutorials1
Trying to reach out through your whatsapp number but not getting any respond from your side though you told to ask on weekends i did the same an no response from your side
Message me again, i had three weddings to attend bro, please understand I have personal life too.
@datatutorials1 sirji I was completely unaware of it yes do understand your priorities and your commitment towards your family. Surely will msg.you again.
Thank you so much ...