Delivery Model Standardization (Individual)

Case synopsis

Swire Coca-Cola (SCCU) operates under two distribution models: “Red Truck” for high-volume customers serviced directly by Swire, and “White Truck” or “Alternate Route to Market” for smaller customers served by third-party distributors. This project is about identifying improvements over Swire's incumbent segmentation strategy (400-gallon threshold) by analyzing customer characteristics and ordering behaviors to support long-term success.

Model: KMeans & Hierarchical Clustering

Exploring the ability to cluster customers based on profile characteristics and ordering performance.

clustering hierarchical kmeans quarto r

Data Wrangling

Combining raw files, standardizing values, and enriching the full data set ahead of modeling exercises.

data wrangling tidyverse quarto r
Vector Graphic of Data Analysis

Exploratory Data Analysis

Exploring the raw files produced by Swire, identifying opportunities for modeling the business problem.

eda quarto duckdb python geospatial