Hello and welcome to everyone who decided to check this project out.
In this project we will design a MySQL database, populate it with the data we got through scraping some websites using Selenium and generating fake data using Faker. Run some EDA using SQL then build a dashboard.
Dashboard Link:
https://public.tableau.com/app/profile/armonia8525/viz/WanhuiSociety/WanhuiDashboard
On Medium:
Part 1: https://blog.devgenius.io/da-portfolio-project-etl-database-design-mysql-part-i-473b340806ca
Part 2: https://blog.devgenius.io/da-portfolio-project-etl-database-design-mysql-part-ii-2e5aac3fc827
Part 3: https://blog.devgenius.io/da-portfolio-project-etl-database-design-mysql-part-iii-129766e1f586
Part 4: https://blog.devgenius.io/da-portfolio-project-etl-database-design-mysql-part-iv-359fc03b9d89