Chayanon Boonthanom

Data Analyst

Transforming data into actionable insights with precision and clarity.

View My Work

Featured Projects

Restaurant Business Intelligence & Database Analysis By SQL

An end-to-end database simulation developed using SQLite and Python (Pandas). I designed a comprehensive relational schema covering staff, menus, customers, and transactions. The project showcases advanced SQL techniques like CTEs and Aggregate Functions to analyze customer behavior and sales performance across four primary tables.

View Code on GitHub →

E-commerce Customer Insights & RFM Segmentation By R

An in-depth EDA of the Online Retail Dataset using R. Investigated 10 analytical dimensions and implemented RFM Feature Engineering to segment customers by behavior. Using Tidyverse, I transformed raw data into insights to optimize marketing and purchasing patterns.

Read Case Study →

Superstore Sales Performance & Profitability Analysis By Python

Strategic analysis of the Sample Superstore Dataset using Python. Focused on Profit Margin analysis and operational inefficiencies. Provided data-driven recommendations to optimize supply chain logistics and enhance regional sales strategies for business profitability.

Read Case Study →