Jumia Performance Dashboard

Data Engineering: Cleaned 42K records and architected a Star Schema using a Bridge Table to link Sales and Marketing data, ensuring 100% accuracy in ROAS and CPA tracking.

Business Insights: Identified a 33.6% order cancellation rate and pinpointed Groceries as the highest-margin category (17.25%), providing actionable growth strategies.

Marketing Optimization: Analyzed $92M in ad spend, discovering that TikTok delivers the highest ROAS (12.5), enabling data-driven budget reallocation.