In this Data Analyst Portfolio project, we taken the Otodom Housing Data and then load the data into the Snowflake database.
In the Snowflake database, we analyzed, cleaned, and transformed data and finally build reports to answer some of the most common questions related to the property market in Poland.
For a couple of the tasks involving the transformation of data, we shall use Python and Google Sheets.
Mentioned below is the steps:
Part 1 - Scrape data, Load data and Flatten data using SQL.
Part 2 - Transform data using SQL, Python, and Google Sheets.
Part 3 - Analyse, Clean and build reports using SQL.