SQL Data Analytics Project (PART 2) | Data Analyst Portfolio Project
This is the SECOND part of the video series where I will build a Data Analytics project using SQL, Python, and Google Sheets.
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.
Get data from Bright Data using the below link:
https://brdta.com/techtfq
This data analysis project will be built as a 3 video series, this is the first part of the video series. Each video part will be released within 2 days of each other.
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.
Timestamp:
0:00 Intro
1:23 Setting up new Python environment
3:05 Python code to convert Latitude Longitude Coordinates to Address
15:56 Loading Address CSV file to Snowflake
22:40 Setting up API's in Google Developer Console to use Google Sheets
27:28 Convert Title language from Polish to English Step 1 Python to Sheets
39:03 Convert Title language from Polish to English Step 2 Sheets to Snowflake
40:26 Loading Title CSV file to Snowflake
42:18 Conclusion
Download the scripts and sample dataset used in this video from my blog.
The link below:
https://techtfq.com/blog/sql-data-ana...
Please do like and subscribe to the channel for more SQL, Python, and Data learning. Also would love to read your feedback in the comments below.
Disclaimer: This video series is sponsored by Bright Data.
🔴 My Recommended courses 👇
✅Complete Data Analytics Bootcamp:
https://codebasics.io/bootcamps/data-...
✅ Learn Power BI:
https://codebasics.io/courses/power-b...
✅ Learn complete SQL:
https://learnsql.com/?ref=thoufiqmoha...
✅ Practice SQL Queries:
https://www.stratascratch.com/?via=te...
✅ Learn Python:
https://codebasics.io/courses/python-...
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic concepts
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Intermediate concepts
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance concepts
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC SQL Queries
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTERMEDIATE SQL Que...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPLEX SQL Queries
✅ Data Analytics Career guidance:
• Data Analytics career and more
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
✅ Git and GitHub Tutorial:
• Git and GitHub
✅ Data Analytics Projects:
• Data Analytics Projects
THANK YOU!
Thoufiq | techTFQ
