Data Analyst Portfolio Project | Finance Domain | Start to End | For Beginners | Part 1

[@eugenelee591]

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.

[@samsmith3961]

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

[@BrunoCestari-y4f]

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.

[@IronMan.o_0.]

Thank You..Waiting for part Two!👍

[@abhiaski1400]

Superb Bro. I am waiting for Part2

[@kapur.betzy2023]

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.😅😞

[@collindarmen8730]

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)

[@jaychikhalkar2351]

Sir please upload part 2 and waiting for part 2 as soon as possible upload

[@julierazafindranaly7876]

Love it, when the part 2 will be released ?

[@DailyDiary4U]

Waiting for part 2

[@subhashreepriyadarshini-l2h]

Thanku sir your videos really help me a lot

[@ceyhunozturk5115]

Waiting for part 2 :)

[@ritamdas_ju]

released or not?

[@MuhammadAli-ib4xn]

very helpful video thanks

[@imranahmad4575]

From we can fetch such data for the practice?

[@KhanSameer-d4w]

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 😊😊

[@monica_brht]

52:38 for MTD I am getting a query result of 1 not 4314. Does anyone know how to fix this issue?

[@sameermalhotra7915]

Same here. I'm also getting the same output

[@heretolearndshare]

Hi, did you fix it? I'm trying to continue studying this video

[@siddhanthdhawan8678]

the days and months have been interchanged

[@heretolearndshare]

@@siddhanthdhawan8678 yes but not with all dates, that's the problem, but I fixed it 👍🏼

[@Happy_Soul_31]

please provide complete powerbi portfolio project on finance domain

[@chalanatyjostna2229]

HI,,, good work. I was able to build the dashboard except for the filled map. could you please help me with that

[@Adeymolahubs]

Thanks for this tutorial boss. pls how can I get the BANK LOAN data used in the SQL

[@satishshinde8768]

Excited for every new video.... Thankyou Sir.... Tumhi marathi ahat ka?

[@karan1147]

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.

[@adhyankumar9492]

bro upload part 2 of this video. the power BI dashboard part its been a month

[@ank_kumar12]

make a full course video on power bi.

[@NagalakshmiH-n7f]

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

[@moseadegoke]

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

[@sameermalhotra7915]

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.

[@yousefashraf8572]

+1

[@siddhanthdhawan8678]

the days and months have been interchanged, if you check day(issue_day) = 12 you will get 4314 as shown

[@alexstulov4365]

Threre are still no part 2, but that project seems to be full version with both part 1 and part 2: kzbin.info/www/bejne/aXqbqJdndribjtU&ab_channel=DataTutorials

[@ashish90702]

Very Informative video Please make a tutorial video on DAX

[@okdokd3385]

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?

[@jabinjayakumar1193]

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 ?

[@adityapunjabi4760]

Sir great work you have done and also you explained well. But you haven't provided domain document

[@Muhammadwaseemkha9003]

i am getting just only 1 application in December kindly correct me where i am on mistake

[@chalanatyjostna2229]

is there part 2?

[@vuquanghuy55]

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?

[@ajeeths9922]

when the part 2 will be released ?

[@datatutorials1]

Its released, link in description

[@ajeeths9922]

not available sir please share the link sir @@datatutorials1

[@SwapnilPakhare-m5q]

Sir please tell, How to write this project in resume

[@datatutorials1]

That u need to write summaries of insights

[@SoundharyaAlagappan-rl7xl]

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

[@siddhanthdhawan8678]

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

[@tejaschaudhari9781]

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?

[@hariVetri-s2t]

can u plz upload part 2

[@datatutorials1]

Uploaded excel part

[@raghuraman8844]

I am not able to get server name in SSMS sir. What should i do

[@datatutorials1]

You have when you install ms sql server

[@parthsanghavi521]

when can we expect 2 part

[@josephabraham4222]

I need the letter

[@Laturkar_brand237]

Tx

[@saimarashid9012]

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

[@datatutorials1]

Ping me on my WhatsApp number to resolve the issue, see description for contact details.

[@Rabbani_World_Flock]

Lum sum ammount 😂😂