🏡 There are over 70,000 Airbnb listings in London (as of March 2023)

😷 Around 15% of listings were added after the city's first lockdown in March 2020.

🌏 4% of hosts are not based in the UK, and hosts in Saudi Arabia charge almost double the average price per night.

<aside> 💡 Background: This project was completed following a Data Analytics course with Brainstation to showcase my SQL and Tableau skills in particular.

</aside>

The following tracks the process I took for this project.

Selecting the data

I selected the dataset from Kaggle based on:

1. Personal interest
2. Variety of data types
3. Number of records

<aside> ℹ️ Datasource: Kaggle

</aside>

Importing the data

• I first created a table in mySQL using the following code.
• ⚠️ I encountered the following errors
• ✅ I used the following solutions as a workaround