Live Interactive Dashboard
Project Intent
Analyzing the end-to-end operations of Wide World Importers to drive actionable insights across sales performance, inventory, and customer lifetime value. This project integrates full-stack data capabilities—from raw SQL extraction to advanced ML modeling in Python.
The Methodology
SQL Extraction
PowerQuery ETL
ARIMA & KMeans Modeling
Power BI Storytelling
Data Model
Star-Schema Architecture
Analysis & Strategic Findings
Sales Performance & Forecasting
Identified Packaging and Clothing as primary revenue drivers. Implemented ARIMA models to predict next-quarter performance.
Customer Segmentation (K-Means)
Segmented client base into three distinct tiers based on frequency and monetary value to tailor marketing strategies.
Inventory Optimization
Isolated stock imbalances: Shipping Cartons (Overstocked) vs Courier Bags (Understocked).
