Skip to content
All projects
Data ScienceOct 2023

Sales Forecasting & Customer Segmentation — Kalbe Nutritionals

Project-based internship with Kalbe Nutritionals and Rakamin Academy: an ARIMA daily sales forecast, K-Means customer segmentation, and a Tableau sales and production dashboard.

Deliverables

  • Exploratory SQL queries over the sales data in DBeaver
  • A Tableau dashboard of sales and production
  • Daily sales forecasting: stationarity checked with the ADF test, ACF analysis, then an ARIMA model evaluated by RMSE
  • Customer segmentation: standardised features, PCA, and K-Means with the number of clusters chosen by silhouette score