Rental properties listed in Idealista (Spain)
Date of project completion: February 2023
Source freshness: October 2022
Source: Idealista data on apartments for rent in Spain
Credit: Data was originally uploaded by Laura Barreda in Kaggle
Goals:
-
To practice my SQL skills for basic data transformation
-
To create my first personal GitHub repository
-
To create a dashboard on Tableau Public
What steps were taken in this project?
​
1. Downloading CSV file from Kaggle
2. Importing data to DBeaver Community, so that I could explore the table via SQL queries
3. Creating basic transformations of the data using SQL queries (e.g. distribution of the apartments by price range).
-
The queries were saved in .sql files created with VS Code
-
Those .sql files were pushed to my GitHub public repository so they can be viewed by anyone!
​4. A dashboard was also published at Tableau Public.
