Analysis of AirBnB Data Using SQL | Data Portfolio Project

Practice your SQL skills by analyzing AirBnB data from the Austin Texas area. This would also make a great data portfolio project to add to your data portfolio or resume. I'll walk you through where to get the data, and how to answer business problems using SQL like what hosts are making the most money.

This video is part of a challenge I'm doing to do 30 Data Science Projects in 30 days

See you data nerds tomorrow!

#SQL #dataanalyst #datascienceproject

[josephmiller]

I love this! I’m also in Utah :) and am in the first semester of A data science masters program. Not having come from a tech background at all, I was getting a little bogged down in my SQL course because I just wasn’t quite sure what the real world application was, and was having a hard time seeing the big picture. It seems like this is a simple example, but it really helped me! It probably also helps that I’ve also always been fascinated with a vacation rental properties, and I’d love to create my own YouTube channel one day :-)

Thanks again!

[NickHass]

Avery, you are absolutely killing it on all platforms!! Love your content 💯

[markslima]

This is impressive, and really helping me in my data analytics quest! Thanks and now I am subscribed!

[siddhantkohli]

The dirty part was very intriguing Thank you !

[pinoydataanalyst]

Can you elaborate how you imported the listings.csv to SQL?

[AaranDanielMusic]

Hi Avery, I love this project and it has inspired me to do one of my own similarly for Buenos Aires! I was wondering how accurate/reliable to do you think the Inside AirBnB data is?

[Swish]

Hi I'm interested on doing sql projects for my own.. I just don't know where to get these data that I need 😢 can u please give ideas to where to get these type of data?

[visionaryapril_art]

How do you put the data into SQL or import the data

[Charlay_Charlay]

when i download the reviews and open in MSSQL it dosent show me the review details. just the id and the date....where are the reviews?

[narameen]

Is that e google data analytics certification good

[sunchimoonchi]

Love the part of burner acct??? New follower here cumpa

[matthewhugo]

Hey Avery! Thanks for the content. I wanted to ask, you said "Using SQL" - what are you using, and is it on a windows or Mac? If its on windows, please would you provide an alternative for Mac. I have PostgresSQL (PgAdmin 4) and its impossible to import a CSV. Help would be greatly appreciated :) thanks and looking forward to your content!

[samueldecarvalho]

I feel like availability isn't the best metric. What if it's not available for a reason other than it's booked? Of course, there doesn't seem to be a better option, but it is a limit of the data.

[Brandon_BB]

Is there a free sql server for mac that you recommend ?

[BAbhishekPatil]

I'm unable to import the 'listings' table to mysql workbench. Only 27 rows got imported. Please help Avery! Love ur videos !!

[younisshami]

The two questions u mentioned, are these questions given to the analyst by the company ? or what ?
love your videos

[aparsa-mit]

Great video! Are you still available on email?

[Khan-mcgi]

how to do 30 Data Science Projects in 30 days i am new for data science

[amj.composer]

Sees "Python > R"
Me: Sir, you're goddamn right

(Sorry I just spent all of college learning R and I consider it the biggest waste of my time and I just wish I did python)

[AmerickiZivot]

I think you are misleading people about your 30 day project because you haven’t completed nor started the projects and the data is not available as you say.