What I love about this video is that it shows how data analyst can encounter errors in SQL Server when importing data and how it can be troubleshooted.
we as your viewers are so much obliged to have a mentor like you,..... I am amazed to see how you aggregated all the resources at one place; made us available at our convenience. Thank you
Let's say I need to make some feature engineering, transformation or cleaning on data to compute a KPI: How would be the workflow? 1. Import the " data. csv" from database to powerquery 2. Transform and clean it 3. Send " data_transformed.csv" to the database 4. Make the queries on "data_transformed" table and mount the query document? Don't know if if I'm clearly with the doubt.
Excited for each new video🤩! More interviews and informative content, please. Can't wait for more! Looking forward to more videos! If possible, consider increasing the upload frequency; it would be a great motivation for us.😅😞
Hi Sir, it's a request if you can upload the remaining Dashboard. Part 2, which is the Power BI part of the dashboard-for the Bank Loan process. Until now, part 1 shows the SQL part. The Power Bi part is remaining. Thanks in advance.
Hii Brother U r amazing..can you please make a video like 2,3 power bi developer how to work together in the company ? How they will distribute work and where save dax n how they will work together.. please brother make a video for it 😊😊
Hi there, I'm having trouble importing the CSV file to SQL Server please could you assist, Error inserting data into table. (Microsoft.SqlServer.Prose.Import) Input string was not in a correct format. (mscorlib)
What is please the difference between WHEN and WHERE and what exactly CASE statement? you have used the 'CASE and WHEN in the above example'. why can't we use the 'WHERE' condition?
Hi guys, please I get error messages while running the MTD- total amount received. The error message is: date is incompatible with tinyint. I am struggling to resolve this
Hi sir i have a question in the 2nd query we need to findout the month-to-month loan application you said we need to take dec is latest month . may i know what is the reason behind it
As I noticed in your Excel file which you're using all the dates column are properly formatted but the Excel file you have provided us is not properly formatted. Also when I ran SELECT COUNT(id) AS Total_Loan_Application From bank_loan_data WHERE MONH(issue_date) = 12 AND YEAR(issue_date) = 2021 I'm getting 1 as output is it because of the unformatted issue_date column or what. Please answer.
Threre are still no part 2, but that project seems to be full version with both part 1 and part 2: ua-cam.com/video/3I8wd1AShXs/v-deo.html&ab_channel=DataTutorials
Before purchasing your data do tell in the website which version you are using .Because as i paid you money and later on got to know that tableue files cannot open because of different version .I think its your responsibility to write also .It looks i just waste my money and no help is being provided by you.First i had to pay for raw data and then i need to again pay for new tableu version .Does it seem fair to you .Why its not written on your website
I am not able to upload the csv file in mysql it shows error code that date value is incorrect datatype in issued date. How do i resolve it..anyone please help me with it
in csv the date columns some of the values are of date type others are in string type that is why the issue. You will need to change the data type for all the date columns to date. I did it through python because excel wasnt saving my changes for the csv file
What I love about this video is that it shows how data analyst can encounter errors in SQL Server when importing data and how it can be troubleshooted.
we as your viewers are so much obliged to have a mentor like you,..... I am amazed to see how you aggregated all the resources at one place; made us available at our convenience.
Thank you
Let's say I need to make some feature engineering, transformation or cleaning on data to compute a KPI:
How would be the workflow?
1. Import the " data. csv" from database to powerquery
2. Transform and clean it
3. Send " data_transformed.csv" to the database
4. Make the queries on "data_transformed" table and mount the query document?
Don't know if if I'm clearly with the doubt.
Thank You..Waiting for part Two!👍
Superb Bro. I am waiting for Part2
Excited for each new video🤩! More interviews and informative content, please. Can't wait for more! Looking forward to more videos! If possible, consider increasing the upload frequency; it would be a great motivation for us.😅😞
Thanku sir
your videos really help me a lot
Sir please upload part 2 and waiting for part 2 as soon as possible upload
Hi Sir, it's a request if you can upload the remaining Dashboard. Part 2, which is the Power BI part of the dashboard-for the Bank Loan process. Until now, part 1 shows the SQL part. The Power Bi part is remaining. Thanks in advance.
very helpful video thanks
Hii Brother U r amazing..can you please make a video like 2,3 power bi developer how to work together in the company ?
How they will distribute work and where save dax n how they will work together.. please brother make a video for it 😊😊
Love it, when the part 2 will be released ?
please provide complete powerbi portfolio project on finance domain
Waiting for part 2
Thanks for this tutorial boss. pls how can I get the BANK LOAN data used in the SQL
Hi there, I'm having trouble importing the CSV file to SQL Server please could you assist, Error inserting data into table. (Microsoft.SqlServer.Prose.Import)
Input string was not in a correct format. (mscorlib)
HI,,, good work. I was able to build the dashboard except for the filled map. could you please help me with that
From we can fetch such data for the practice?
Excited for every new video....
Thankyou Sir....
Tumhi marathi ahat ka?
One of the beautiful dashboard built brining in all insights and information to learn.
When will be the other part of the video would be released ?
make a full course video on power bi.
bro upload part 2 of this video. the power BI dashboard part its been a month
Sir great work you have done and also you explained well.
But you haven't provided domain document
Waiting for part 2 :)
released or not?
What is please the difference between WHEN and WHERE and what exactly CASE statement? you have used the 'CASE and WHEN in the above example'. why can't we use the 'WHERE' condition?
Hi guys, please I get error messages while running the MTD- total amount received. The error message is: date is incompatible with tinyint. I am struggling to resolve this
you made it Excel in part 2, but created a thumbnail Power BI + SQL + EXCEL + TABLEAU in part 1? how about Power BI and TABLEAU? Where did they go?
Very Informative video
Please make a tutorial video on DAX
sir it a great video ..thank you for that!! i want to ask one thing that will we upload a ecxel or csv file to the SQL workbench tooo?
Hi sir i have a question in the 2nd query we need to findout the month-to-month loan application you said we need to take dec is latest month . may i know what is the reason behind it
Tx
i am getting just only 1 application in December kindly correct me where i am on mistake
As I noticed in your Excel file which you're using all the dates column are properly formatted but the Excel file you have provided us is not properly formatted. Also when I ran
SELECT COUNT(id) AS Total_Loan_Application From bank_loan_data
WHERE MONH(issue_date) = 12 AND YEAR(issue_date) = 2021
I'm getting 1 as output is it because of the unformatted issue_date column or what. Please answer.
+1
the days and months have been interchanged, if you check day(issue_day) = 12 you will get 4314 as shown
I need the letter
is there part 2?
Sir please tell, How to write this project in resume
That u need to write summaries of insights
can u plz upload part 2
Uploaded excel part
Threre are still no part 2, but that project seems to be full version with both part 1 and part 2: ua-cam.com/video/3I8wd1AShXs/v-deo.html&ab_channel=DataTutorials
when can we expect 2 part
Before purchasing your data do tell in the website which version you are using .Because as i paid you money and later on got to know that tableue files cannot open because of different version .I think its your responsibility to write also .It looks i just waste my money and no help is being provided by you.First i had to pay for raw data and then i need to again pay for new tableu version .Does it seem fair to you .Why its not written on your website
Ping me on my WhatsApp number to resolve the issue, see description for contact details.
I am not able to get server name in SSMS sir. What should i do
You have when you install ms sql server
when the part 2 will be released ?
Its released, link in description
not available sir please share the link sir
@@datatutorials1
I am not able to upload the csv file in mysql it shows error code that date value is incorrect datatype in issued date. How do i resolve it..anyone please help me with it
in csv the date columns some of the values are of date type others are in string type that is why the issue. You will need to change the data type for all the date columns to date. I did it through python because excel wasnt saving my changes for the csv file
52:38 for MTD I am getting a query result of 1 not 4314. Does anyone know how to fix this issue?
Same here. I'm also getting the same output
Hi, did you fix it? I'm trying to continue studying this video
the days and months have been interchanged
@@siddhanthdhawan8678 yes but not with all dates, that's the problem, but I fixed it 👍🏼
Lum sum ammount 😂😂