Data Science & Analytics

Web Analytics and Product Analytics for an E-commerce

This personal proejct involves working with a SQL relational database (six data tables) to analyse web traffic and product performance, aiming to optimise marketing strategies for a hypothetical e-commerce start-up.

MySQL Web Traffic Analytics Product Analytics

Evaluating Impacts of Cost-saving Interventions

This statistical project is based on data sourced from the American Causal Inference Conference 2022 Data Challenge. I used a quasi-experimental approach (the Difference-in-Differences method) to evaluate the effectiveness of policy interventions aimed at reducing healthcare expenditures.

R Causal Inference DiD Regression Hypothesis Testing

Fun Projects

Webtoons Scraper

In this project, I developed a Scrapy-based scraper to gather data from over 1,000 webtoons, including details like genres, ratings, and release status. Initially designed to collect data at a single point, the scraper can be adjusted to run at different intervals. This allows for continual updates as new webtoons are added.

Python Scrapy Webscraping

Recreating Spotify Wrapped

As an avid user of Spotify, in this project, I explored my personal streaming data from Spotify to understand my listening habits throughout 2023. I have created an interactive dashboard in Tableau to showcase key insights. I plan on updating the dashboard every year to keep track of my music taste.

Tableau

UX Research & Design for Product Development

My personal interest in art and tech inspired me to work on these projects. I designed two mobile apps: Pet Shop App and Mental Health(Therapy) App, as well as a website for a restaurant. I conducted UX research to identify problems, and created wireframes, and prototypes using Figma to bring my ideas to life.

Figma Adobe XD UXD Usability Testing