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.😅😞
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 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.
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 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.
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
Threre are still no part 2, but that project seems to be full version with both part 1 and part 2: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3I8wd1AShXs.html&ab_channel=DataTutorials
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
