Back to Gallery
PythonCapstone Project

E-Commerce Inventory Forecasting & Safety Stock Optimizer

AR
BUILT BYAsim Riaz
BEFOREWarehouse Supervisor
OUTCOMESupply Chain Analyst at Alfatah

Project Overview

A Python analytics script calculating weekly safety stock limits and reorder points based on demand volatility.

Data Scrubbing & Cleaning Pipeline

The student imported raw messy CSV database backups, scrubbed redundant column entries, normalized data structures, handled duplicate records, and configured relationship models using SQL schemas and Power BI.

Analytical Insights Generated

Configured cohort retention models, isolated regional operational leakages, tracked active customer churn risk, and mapped average revenue metrics across locations.

Project Specs

CORE TOOLPython
DATA ROWS PROCESSED500,000+ Records
TIME TO BUILD3 Weeks
COMPLEXITY LEVELHiring Grade