Back to Projects
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
Product Performance & Inventory Optimization
Comprehensive product analysis and inventory optimization for 3,500+ SKUs
Data Preparation & Libraries
Task: Loaded comprehensive data analysis libraries and read Online Retail.xlsx dataset. Cleaned raw dataframe by dropping null values and removing non-positive quantities.
Result: Optimized dataset ready for comprehensive product performance analysis with clean, reliable data.
Data preparation and cleaning code
Cleaned product dataset preview
Product Aggregation & KPIs
Task: Created line-level revenue and grouped by StockCode + Description to compute product KPIs including Total_revenue, Total_Quantity, Num_Transactions, and sales dates.
Result: Comprehensive product_performance dataframe with detailed product-level metrics for 3,500+ SKUs.
Product aggregation implementation
Sales Velocity & Movement Classification
Task: Calculated Days_activity and Sales_velocity (Total_Quantity / Days_activity) for movement classification. Bucketed SKUs using qcut into Fast/Medium/Slow categories.
Result: Movement_category column enabling differentiated replenishment rules and inventory prioritization based on product movement patterns.
Sales velocity calculation code
Product movement classification visualization
Stockout Risk Assessment
Task: Built monthly_sales aggregation and computed coefficient_of_variation to flag stockout_risk levels (low/medium/high).
Result: Monthly turnover analysis identifying ~15 SKUs with high stockout risk requiring immediate attention and proactive management.
Stockout risk assessment algorithm
Stockout risk classification dashboard
ABC Classification
Task: Implemented ABC analysis using cumulative revenue percentage with class thresholds (A: ≤80%, B: ≤95%, C: remainder).
Result: ABC_Class column enabling prioritized inventory management, resource allocation, and strategic focus on high-value products.
ABC classification implementation
ABC product classification visualization
Dashboard Creation
Task: Built comprehensive Tableau dashboard integrating all product performance metrics and inventory optimization insights.
Result: Interactive dashboard providing real-time insights into product performance, stockout risks, and inventory optimization recommendations.
Merging datasets for the performance dashboard
Dashboard features