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.

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

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

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

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

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

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.

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

Text analytics project focusing on Brazil's e-commerce data to evaluate customer/supplier patterns.

This project explores and analyzes food industry data to uncover sales trends, customer preferences, and market insights. Using data cleaning, visualization, and exploratory data analysis (EDA), it helps businesses make informed decisions, optimize strategies, and improve overall performance in the competitive food sector.