This repository contains my academic marketing and customer data analytics related projects using R and SQL.

Strategy Consulting Virtual Experience Program

Vehicle data classification (supervised, unsupervised learning)

Built upon an existing open-source project to analyze cosmetic product pricing by examining ingredients, brand influence, and customer ratings. Enhanced the project with ingredient scoring, brand analysis, and data visualizations using Python and Sephora data.

Python client for the YouGov BrandIndex API. Query brand perception metrics, sentiment scores, and consumer awareness data with timeline and multi-brand support.

Classification ML models for predicting customer outcomes (namely, whether they're likely to opt into email / catalog marketing) depending on customer demographics (age, proximity to store, gender, customer loyalty duration) as well as sales and shopping frequencies by department

Performed Clustering Analysis using SAS v9.4 on Power Usage & Consumer Goods Data to draw insights about the dataset.

Transform Product Reviews into Strategic Market Insights

Optimize promotion targeting for Starbucks' simulated data.

AI-powered consumer trend prediction model — discovers emerging themes, tracks sentiment, and predicts trend momentum from any product review dataset

Consumer Behavior & Data Analytics Externship project with Beats by Dre - combining quantitative & qualitative insights to explore brand perception, product preferences, and sentiment patterns.

Exploratory Data Analysis (EDA) on Fitbit users' data to uncover trends in activity and health metrics.

Evolution of Consumer Insights & Analytics solution, from service design optimization to real-time insights and analytics

This repository contains an end-to-end data analysis project for Bellabeat, a health-focused smart device company. As a junior data analyst, we explore public smart device usage data to identify key behavioral trends and translate them into actionable marketing insights for Bellabeat.

Live consumer demand data for AI market research agents. Amazon, Google Shopping, TikTok, Reddit, App Store. Free tier.

3-Layer Korean NLP × Trend × ML pipeline detecting consumer switching signals for head & shoulders.

A Web Scraping project for the Yunnan Sourcing Website, using Scrapy & Beautiful Soup. Jupyter Notebook provided with analysis.

M2 Internship report

Bellabeat Fitbit Case Study - Marketing Analysis

Portfolio of Chung Hy Dai, market research and consumer insights analyst