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