SQL Data Analytics Project | Data Analyst Portfolio Project using SQL, Python, Google Sheets

Written By Thoufiq Mohammed

This blog has details about my YouTube video series where I built a end to end Data Analytics project using SQL, Python, and Google Sheets. This video series contains 3 parts (3 separate videos). The download contents present in this blog will be updated after each video is uploaded to YouTube.

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

Get datasets from Bright Data here

Download all the project materials used in the video below:

Thoufiq Mohammed https://techtfq.com
Previous

Solving a Real SQL Interview Problem | Job Vacancies SQL Query
Next

Lets Simplify and Solve a Complex SQL Interview problem