SQL Data Analytics Project (Otodom)
3 videos • 25,886 views • by techTFQ This is a video series where I have built an end-to-end Data Analytics project using SQL, Python, and Google Sheets. This video series contains 3 parts (3 separate videos). In this Data Analyst Portfolio project, we will scrape the Otodom website data using the Bright Data tool and then load the data into the Snowflake database. In the Snowflake database, we shall analyze, clean, and transform 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 scope of each video in this video series: 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. I am building this project using property listing data taken from the https://www.otodom.pl/ website using the Bright Data platform. However, a similar project can be built using any other dataset of your choice Thanks,