I never ever saw before the best project of data analyst in youtube . after watching this video.This is the best video. Thank you so much for giving us best content with free of cost.
@mdalimourtazasourav1845
6 күн бұрын
Best data analytics project I have ever seen.
@sparshkapoor8517
5 ай бұрын
The most comprehensive Data Analysis Video ever found open source. Great Work!!!!
@b_umakant
5 ай бұрын
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.
@datatutorials1
5 ай бұрын
Glad it was helpful!
@AnalyticalDeveloper
6 ай бұрын
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.
@datatutorials1
6 ай бұрын
Thanks and welcome
@subashlingden9883
3 күн бұрын
Thank you very much for the end to end project
@adusri
23 күн бұрын
Indeed best video to learn and build on power BI, Great work.
@alexrosen8762
6 ай бұрын
One of the best and most comprehensive tutorials so far on this subject that I have ever seen 👌
@sunee6774
2 ай бұрын
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:)
@RajeshManepalli-o8b
Ай бұрын
By this i can able to report for Banking Domain Thanks for sharing the document
@riasingh11
4 ай бұрын
This project took me 12 hours to complete because there are so many data type issues.
@riasingh11
4 ай бұрын
But it was an awesome project
@brandyplays6134
2 ай бұрын
@@riasingh11what sort of data problems
@iamkanwalashfaq
Ай бұрын
@@brandyplays6134 I had date data type issues, idk if anyone else had it.
@shubhamjoshi2492
20 күн бұрын
@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
@thinhnguyenphuc8624
20 күн бұрын
@@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
@mayankjain9482
3 ай бұрын
Mate.. You are GOD of DATA
@PallaviSatpute-i6s
Ай бұрын
Superb Explanation. Thank you Sir
@kdatar8
28 күн бұрын
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
@smileuntilyoudie5127
Ай бұрын
You deserve Millions of views for helping us
@Yafatttah-sn5nk
3 ай бұрын
It was my first project 🙏🏼
@sam02109
3 ай бұрын
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.
@pareenharsora3303
6 ай бұрын
Your learning method is best with all meaningful information
@NickJohns-q8c
6 ай бұрын
Have you done this project. I'm getting mismatch data while calculating MTD loan application
@abhishekmishra8236
7 ай бұрын
Thanks for the video. Can you please share the Problem Statement document as well. 18:02
@rectifytech
2 ай бұрын
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.
@bealugirma4971
Ай бұрын
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.
@ayanpaliwal6085
4 ай бұрын
Best Video For a project can be made Hats Off to u 👏👏
@datatutorials1
4 ай бұрын
Thanks you for commenting
@aks3722
2 ай бұрын
Thankyou sooo much , it was very helpful. I learned a lot of things!
@akashmahakulkar7218
6 ай бұрын
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
@atchyutarao1990
5 ай бұрын
Tq bro to provide such a wonderful project
@datatutorials1
5 ай бұрын
It's my pleasure
@anthonymary1cyril5
2 ай бұрын
Thanks a lot Sir
@manjumankoji1448
4 ай бұрын
Thanks for sharing this awesome project.
@jaitiwari241
7 ай бұрын
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
@rectifytech
2 ай бұрын
Thank you so much for this project!
@AfroAgeMusic
2 ай бұрын
Will watch it from my desktop
@miracleatimangovictoria7529
2 ай бұрын
Yes great video. I have learnt a lot. I thought I knew power bi
@ambroseaboge7262
Ай бұрын
Thank you sir.🙏
@harikrishnamba
7 ай бұрын
Great effort as always, thanks Swapnjeet
@prajjwalgurjar3887
2 ай бұрын
Great video ,got so much to learn
@khushbu3025
7 ай бұрын
what are the key insights and how to mention this in resume ?
@user-gq6cg3ls7f
6 ай бұрын
This is great analysis. Please create another video on loan analysis
@datatutorials1
6 ай бұрын
Sure
@shwetamishra1497
6 ай бұрын
Great video 👍 I have learnt a lot. Thank you so much for this tutorial 🙏. Waiting for more tutorials further.
@datatutorials1
6 ай бұрын
More to come!
@Ian15278
6 ай бұрын
U r using mysql??
@karthikamuniswamy3132
3 ай бұрын
MTD values showing 1, how to FIX it?
@anasahmad5415
7 ай бұрын
Hi Request to upload course from scratch powerbi and sql , or atleast dax please your teaching style is supergood
@gunathangam6344
5 ай бұрын
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
@Vishalk-h5b
7 ай бұрын
please request you, make video on realtime dashboard on SQL+ power bi
@datatutorials1
7 ай бұрын
This is a realtime data set
@BradleyAidanJohnson
6 ай бұрын
think he may mean using directquery?@@datatutorials1
@Thanu-c1l
Ай бұрын
Hii.. Thank you for this tutorial. Can you please suggest me some charts to visualise target vs actuals in sales data
@bunnyblanko703
28 күн бұрын
I'm doin it in mysql i'm having a lot problems in getting the right output after writing the correct query also
@9096003215
Ай бұрын
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?
@bandiashokyadav3312
6 ай бұрын
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]
@ShaRaj-t2c
7 ай бұрын
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 ❤
@DhruvDaware-ir3jl
6 ай бұрын
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.
@sofiuakibu1592
5 ай бұрын
Have you validated your data? I experienced same from the beginning, then I validated my data as well.
@SanjaySahu-e2i
6 ай бұрын
thanku for amazing concept , Please make CRM Dashboard in power BI
@pratikjugantmohapatra18
6 ай бұрын
The MTD is not showing any values in the card,.Its showing blank values.(2hr 15 min video time ) Please guide
@riasingh11
4 ай бұрын
@pratikjugantmohapatra18 where you able to fix it
@raghav.r9705
3 ай бұрын
Same problem for MOM is not showing values
@shedizon5978
2 ай бұрын
Same as mine
@tanishkphore6509
2 ай бұрын
Same problem with me
@raghav.r9705
2 ай бұрын
@@gkapadi9831 after some corrections i got it i have done mistake in measures.
@adityabhandari9259
6 ай бұрын
great content
@LearnXane
4 ай бұрын
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?
@rishabhraj2274
7 ай бұрын
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 ?
@manaskumarsahu3272
7 ай бұрын
I am also face this problem . If you found out this solution. Please let us know ...
@vineetkhairwal
Ай бұрын
In Avg Dti KPI ...it is showing error - the function average cannot work with values of type string
@Ranganadhamkrishnachaitanya27
7 ай бұрын
Super
@santoshkalia86
6 ай бұрын
Sir why am I getting MTD loan applications 0 . Kindly reply
@sushantkanojia21
5 ай бұрын
because of the issue_data type is text... you have to convert it into date type first.
@pawaniredde5574
5 ай бұрын
Which databtype we need to give for that could you please explain its helpful @@sushantkanojia21
@knavneetraj3168
3 ай бұрын
@@sushantkanojia21 but how to convert it . please help me ?
@datatutorials1
3 ай бұрын
The data type for date should be date, you can convert it in power bi
@sushantkanojia21
3 ай бұрын
@@knavneetraj3168 for sql or power Bi?
@raushanpandey4553
6 ай бұрын
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.
@datatutorials1
6 ай бұрын
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
@Ranjit-K9
Ай бұрын
Brother some off the queries are not working on MySQL work bench
@S.A-dm1nl
Ай бұрын
Hey, do you think I can use this project in my resume? I will not get any copyright issues. plz reply
@jyotshnamayeeberiha4748
10 күн бұрын
i am doing this in mysql but in mysql all the data in the table are not showing plz help...
@fadlaill8955
4 ай бұрын
good
@demoments6210
16 күн бұрын
Make sure you change the date format from DD-MM-YYYY to MM-DD-YYYY.
@Vishal-xv4mt
6 ай бұрын
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?
@datatutorials1
6 ай бұрын
Check in preview features option if all the map related check boxes are enabled
@vishnuekilwale4186
7 ай бұрын
@SWAPNJEET Thanks for the amazing content.
@datatutorials1
7 ай бұрын
Welcome!
@koreanchinese5677
2 ай бұрын
Where is the excel file uploaded plz let me know
@praphulshresth
Ай бұрын
How to get the data for practice
@sonalinidhi6744
4 ай бұрын
Sir plz make end to end project on power bi +postgreSQL
@datatutorials1
4 ай бұрын
Ok aure
@sudheerp8806
3 ай бұрын
MTD values showing 1, how to find it?
@srilakshmikarumuri9458
7 ай бұрын
Could you please do this on healthcare organization dataset too
@user-re8pu7fe2x
2 күн бұрын
I have a concern. The data model you have designed for bank loan project in power bi has only fact table bank_loan. I know there is Date dimension table created but why haven't you created Star schema or Snowflake schema from this bank_loan fact table that would connect dimension table like Employee and Location? Note: Employee and Location dimension table can be derived from bank_loan table that is fact table in your project. Please answer this question as its important for interview. Follow up 1: Do you have answer? Follow up 2: Answer please! Looks like he doesn't have an answer to this question as he is not responding after followups. Guys, if anyone can answer this, it will be most useful for anyone. Please comment the answer.
@Muhammadwaseemkha9003
6 ай бұрын
Kindly cpu or laptop recommend kr dy mera laptop buhat slow hy change karna chahta hum
@talhashahzad2314
Ай бұрын
shape map is not available how to get it?
@gamingelgato
4 ай бұрын
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?
@PaiseWalaBanda924
3 ай бұрын
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.
@Muhammad-io1lx
Ай бұрын
@@PaiseWalaBanda924 this is not working . Error showing in issue date coloumn
@renukashinde3810
Күн бұрын
i am geeting blank for good loan % hench all calculations are getting blank values, someone please help
@pranjalrastogi6387
Ай бұрын
Can i do in sql server
@spsaiteja7654
9 күн бұрын
Can anyone help me to get the link of the Problem Statement Document?
@АлександрКоваленко-р6р
4 ай бұрын
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!
@jeankenjio9716
6 ай бұрын
Very nice... What is the source of the dataset please?
@ArjunJothi-v5x
4 ай бұрын
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
4 ай бұрын
What db you are using
@ArjunJothi-v5x
4 ай бұрын
@@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.
@rohitahmed6014
4 ай бұрын
How you resolve this query actually iam facing the same issue over here can you explain@@ArjunJothi-v5x
@swastikjainsj
7 ай бұрын
Bhai excel sql and power bi learning chal raha hai Excel ka content hai kya?
@Ian15278
6 ай бұрын
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?.
@datatutorials1
6 ай бұрын
Which database u r using and what are number of records imported in db
@Data_Spec.
6 ай бұрын
I am having same issue, I think the problem is that all the dates are not in the same format.
@Data_Spec.
6 ай бұрын
@@datatutorials1 I have the same number of record imported with yours but MTD = 12 is returning 1
@datatutorials1
6 ай бұрын
@Data_Spec. Please convert all date to date format and retry
@Data_Spec.
6 ай бұрын
@@datatutorials1 I have converted but still the same thing. I really appreciate if you can help check the filed you uploaded to google drive.
@bhavyajain4302
4 ай бұрын
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
@datatutorials1
4 ай бұрын
Which data base are you using to fire queries
@bhavyajain4302
4 ай бұрын
@@datatutorials1 MS SQL only, the one that you are using
@bhavyajain4302
4 ай бұрын
The problem is with the date column in excel sheet, for december month its showing only 1 row
@mrbartuss1
6 ай бұрын
So what is the point of using SQL? Just to confirm the made calculations in Power BI?
@joseO12326
6 ай бұрын
Asking the same question
@saniya_thousif
6 ай бұрын
Sql queries are executed to cross verify the results that we get by creating measures in power bi
@jyotimishra4214
2 ай бұрын
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
@datatutorials1
2 ай бұрын
Mail me i can help you
@shwetamishra1497
6 ай бұрын
bhai file upload hone me kitna time le raha hai koyi fast tarika nahi hai kya jisse file jaldi upload ho jaye?
@hi10may
7 ай бұрын
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 🙏
@datatutorials1
7 ай бұрын
Glad you liked!
@santoshkalia86
6 ай бұрын
Can anyone explain why am I getting MTD and PMTD loan applications as 0
@sushantkanojia21
5 ай бұрын
you have solution for this?
@vishalsehgal6454
7 ай бұрын
sir mere power bi mein upar woh signs show hi nahi hote format mein kaise enable kru pata hi nahi chal raha
@aniket4627
3 ай бұрын
37:41 use VARCHAR(MAX) in emp title
@tusharkadu8026
6 ай бұрын
in my power bi shape map is not showing
@datatutorials1
6 ай бұрын
Turn it on from preview feature
@ssankar4655
6 ай бұрын
bro when i calculate MTD it takes TOTAL COUNT , please give the solution for it.
@datatutorials1
6 ай бұрын
Follow steps in video
@tanujarana6979
5 ай бұрын
hi swapnjeet . i cant fine data set the link you provided
@datatutorials1
4 ай бұрын
Check description again
@Irfankhan_56
5 ай бұрын
I can't find the dataset in the data download folder.
@Irfankhan_56
5 ай бұрын
Can anyone help me with the dataset?
@datatutorials1
4 ай бұрын
Its available please check again
@debasishbhowmick3018
5 ай бұрын
Where I can get the data set
@datatutorials1
5 ай бұрын
Available in description of video
@ShivamDhuri-l2q
2 ай бұрын
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?
@beingrishi6450
4 ай бұрын
29:32 Where I can get this MS Word to gain some knowledge on Banking Domain
@datatutorials1
4 ай бұрын
Link available in description box, all material at one place, you can download it from there
@47sandesh
Ай бұрын
can you share free power bi course ?
@nikhil09090
7 ай бұрын
I think this project you already covered .
@datatutorials1
7 ай бұрын
No I didn’t, was uploaded for SQL, tableau and excel
@prashanthk-pe9md
5 ай бұрын
too many ads🤧🤧🤧🤧
@DataAnalyst251
7 ай бұрын
Nice one. Can you do this for Tableau?
@datatutorials1
7 ай бұрын
For Tableau already uploaded on my channel 😎
@DataAnalyst251
7 ай бұрын
Thankyou for reply. You're awesome@@datatutorials1
@yogeshbibve184
2 ай бұрын
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
2 ай бұрын
Message me again, i had three weddings to attend bro, please understand I have personal life too.
@yogeshbibve184
2 ай бұрын
@datatutorials1 sirji I was completely unaware of it yes do understand your priorities and your commitment towards your family. Surely will msg.you again.
Пікірлер: 170