πŸ›’
Scenario
Data Analyst, Jumia Marketplace, Nairobi

You've just joined Jumia's marketplace team in Nairobi. It's early January, and Q4 has just wrapped. The head of marketplace operations asks for a brief by Tuesday EOD:

  • Which product categories are growing? Which are fading?
  • Is Nairobi carrying the entire business, or are we seeing growth in secondary cities?
  • How did Cyber Week perform, and is the momentum sustainable?
  • Which vendors are our best partners? Any quality concerns?
  • What's your top recommendation for Q1 inventory and vendor investment?

Your deliverable: A one-page executive brief with 4 KPIs, a key insight chart, and a data-backed recommendation.

9,000
Q4 Orders
β‚Ή349.7M
Total GMV
9 Counties
Geographic Spread

What You'll Build

Your Capstone Deliverable

Data inspection: Load 9k orders, audit types/nulls, validate date range (1 chart).
Sales exploration: GMV by category, county spread, Cyber Week impact (3 charts).
Vendor & quality deep dive: Return rates by vendor tier, correlation matrix (2 charts).
Cohort analysis: Category momentum (WoW growth), repeat customer rate, first-order conversions.
Executive recommendation: One-page summary (4 KPIs + top insight + 3 actions) ready for leadership.

Step 0: The Brief β€” Turn Business Questions into Analytics

Before you open your notebook, frame the business questions as analytical ones:

  • Category trends: Which categories are growing WoW, and which are declining? Which drive the most GMV?
  • Geographic concentration: What % of GMV comes from Nairobi vs. secondary cities? Is there a tail opportunity?
  • Cyber Week elasticity: Did orders spike during Nov 25–Dec 3? Has the boost persisted, or is it fading?
  • Vendor quality: Do higher-tier vendors (Gold, Silver, Bronze) have meaningfully different return rates? Should we change onboarding?
  • Intervention hypothesis: If we allocate more inventory to high-growth categories (Beauty) and push Bronze vendors to quality standards, what impact could we model?

This is the analytical frame that will guide your exploration and final recommendation.

Step 1: Load & Inspect β€” Know Your Data

Start by loading the 9,000-order Jumia Kenya CSV. Your first job: understand the shape, types, and date coverage.

Step 1: Load & explore (from Lessons 4–7: Pandas Fundamentals) Run ↻
Output (summary)
Shape: (9000, 11) Data types: order_id object order_date datetime64[ns] customer_id object county object category object vendor_id object vendor_tier object order_value_kes float64 items int64 delivery_days int64 is_returned bool Date range: 2024-08-31 to 2024-12-29 Total GMV: β‚Ή349,700,000 Avg order value: β‚Ή38,856

Key observations: Your dataset has 9,000 orders spanning 120 days (late August through late December, covering Black Friday and Cyber Week). 11 columns, no missing values. The dataset includes vendor tier (Gold/Silver/Bronze), order value in KES, and a return flag for quality analysis.

Figure 1.1: Total Orders & GMV by County
GMV distribution across Kenya counties

Step 2: Clean β€” Prepare for Analysis

The data is already 99% clean, but we'll create derived columns and standardize categories.

Step 2: Data cleaning & feature engineering (from Lessons 8–12: Data Wrangling) Run ↻
Output
Cleaned dataset: Shape: (9000, 16) Missing: 0 Total GMV: β‚Ή349.7M Cyber Week orders: 836 (9.3%) Return rate: 4.8%

Step 3: Explore β€” Uncover Sales Patterns

Now dive into category performance, geographic spread, and Cyber Week impact. Hunt for growth categories, regional concentration, and seasonal effects.

Step 3: Exploratory Data Analysis (from Lessons 13–17: EDA & Distributions) Run ↻
Output (summary)
=== SALES OVERVIEW === Total GMV: β‚Ή349.70M Orders: 9,000 Unique customers: 2,387 === TOP CATEGORIES (by GMV) === Phones & Accessories: β‚Ή87.4M (25% of GMV, 2,249 orders) Electronics: β‚Ή70.1M (20% of GMV, 1,799 orders) Fashion: β‚Ή63.2M (18% of GMV, 1,622 orders) Home: β‚Ή52.5M (15% of GMV, 1,359 orders) Beauty: β‚Ή41.8M (12% of GMV, 1,078 orders) Grocery: β‚Ή24.8M (7% of GMV, 627 orders) Kids: β‚Ή10.0M (3% of GMV, 266 orders) === COUNTY CONCENTRATION === Top 2 (Nairobi + Mombasa): β‚Ή221.7M (63.4%) Remaining 8: β‚Ή128.0M (36.6%) === CYBER WEEK EFFECT === Before (30d): β‚Ή140.6M (4.69M/day) During Cyber Week (9d): β‚Ή41.0M (4.55M/day) Cyber Week boost: 0.97x (Note: date distribution skewed)

Key insights: Phones & Accessories is the GMV leader (25%), but we'll explore trend direction. Nairobi + Mombasa account for 63.4% of GMVβ€”a strong concentration but with room to grow secondary cities. Cyber Week shows modest lift in this sample, so we'll dig deeper into week-over-week momentum by category.

Figure 3.1: Total GMV by Category
Category revenue breakdown
Figure 3.2: Daily GMV Time Series (Cyber Week Highlight)
Daily sales trend with Cyber Week period marked

Step 4: Analyse β€” Deep Dives into Key Drivers

4.1: Category Momentum (WoW Growth)

Calculate week-over-week growth for each category to spot which ones are accelerating into Q1.

Step 4a: Category momentum (from Lessons 13–17: EDA & Groupby) Run ↻
Output
=== CATEGORY MOMENTUM (WoW) === ↑ Beauty: +18.2% ↑ Fashion: +8.5% ↑ Home: +6.3% ↓ Electronics: -12.1% ↓ Kids: -15.8% ↓ Grocery: -21.3% ↓ Phones & Accessories: -24.6% Top growth: Beauty (+18.2%) Largest decline: Phones & Accessories (-24.6%)
Figure 4.1: Category Momentum (Week-over-Week Growth %)
WoW category growth rates

4.2: Vendor Quality β€” Return Rates by Tier

Analyze whether vendor tier (Gold, Silver, Bronze) correlates with product quality (return rates).

Step 4b: Vendor quality analysis (from Lessons 13–17: Groupby & Ratios) Run ↻
Output
=== VENDOR TIER QUALITY === Gold: Orders: 2,214 (24.6% of total) Return rate: 1.5% Returns: 34 (8.9% of all returns) Silver: Orders: 3,141 (34.9% of total) Return rate: 3.8% Returns: 119 (31.0% of all returns) Bronze: Orders: 3,645 (40.5% of total) Return rate: 7.5% Returns: 272 (71.0% of all returns) Key insight: Bronze vendors drive 71% of returns despite 41% of orders.
Figure 4.2: Return Rate by Vendor Tier
Quality variance across vendor tiers

4.3: Operational Correlations

Compute correlations between order value, items per order, delivery time, and returns to spot operational risk patterns.

Step 4c: Correlation matrix (from Lessons 18–20: Statistical Testing) Run ↻
Output
=== CORRELATION MATRIX === order_value_kes items delivery_days is_returned order_value_kes 1.000 0.412 0.048 0.041 items 0.412 1.000 0.126 0.089 delivery_days 0.048 0.126 1.000 0.127 is_returned 0.041 0.089 0.127 1.000 Key insights: β€’ Order value vs. items: 0.412 (Higher-value orders ship more items) β€’ Items vs. returns: 0.089 (Weak; bulk orders not much riskier) β€’ Delivery days vs. returns: 0.127 (Slower delivery β†’ slightly higher return risk)
Figure 4.3: Operational Metrics Correlation Heatmap
Correlation matrix showing operational relationships

Step 5: Ship β€” Executive Deliverable & Recommendation

5.1: KPI Summary

β‚Ή349.7M
Total Q4 GMV
9,000
Orders
4.8%
Return Rate
Beauty
Top Growth (+18%)

5.2: One-Pager Recommendation

Step 5: Build your one-pager (from Lessons 27–28: Shipping & Executive Communication) Run ↻
Output (Executive Summary)
============================================================ JUMIA KENYA Q4 EXECUTIVE SUMMARY ============================================================ KEY METRICS Total GMV: β‚Ή349.7M Orders: 9,000 Avg Order Value: β‚Ή38,856 Return Rate: 4.8% TOP 3 CATEGORY OPPORTUNITIES 1. Beauty (+18% WoW, β‚Ή41.8M) 2. Fashion (+9% WoW, β‚Ή63.2M) 3. Home (+6% WoW, β‚Ή52.5M) REGIONAL CONCENTRATION Nairobi + Mombasa: 63.4% of GMV (β‚Ή221.7M) Opportunity: Drive secondary city growth (Kisumu, Nakuru) VENDOR QUALITY ALERT Bronze tier return rate: 7.5% (vs. 1.5% for Gold) Action: Audit Bronze vendor onboarding & quality controls TOP RECOMMENDATION FOR Q1 βœ“ Double down on Beauty (18.2% WoW growth) β†’ Increase inventory allocation 15-20% β†’ Cross-sell with Fashion (also growing +8.5%) βœ“ Tighten Bronze vendor onboarding β†’ Require QC pre-certification before listing β†’ Monitor return rates weekly; auto-suspend if >8% βœ“ Drive secondary city expansion β†’ Target Kisumu & Nakuru with localized promos β†’ Partner with local logistics for faster delivery Expected impact: 12-15% GMV uplift, -1.5pp return rate ============================================================

Why this recommendation matters: Beauty is the only high-GMV category (β‚Ή41.8M) with double-digit growth. Phones & Accessories is declining (-24.6%) despite being the largest categoryβ€”a signal to shift inventory. The Bronze vendor issue is a quality crisis (71% of returns on 41% of orders): tightening standards could cut return rate by 1.5pp, saving β‚Ή5.2M in logistics costs. Secondary city expansion targets untapped 36.6% of non-metro demand.

What This Capstone Demonstrates

By completing this analysis, you've practiced:

  • Data loading & inspection (Lessons 4–7): Pandas fundamentals, shape/dtypes, null checks.
  • Data cleaning (Lessons 8–12): Type coercion, outlier capping, derived features (flags for Cyber Week).
  • Exploratory analysis (Lessons 13–17): Groupby aggregations, pivot tables, category/regional breakdowns.
  • Advanced analytics (Lessons 18–22): Cohort momentum (WoW growth), correlation matrices, quality metrics (return rate by segment).
  • Visualization (Lessons 25–26): Multi-panel dashboard: 7 charts telling the story of growth, concentration, and quality.
  • Executive communication (Lessons 27–28): KPI cards, one-pager, recommendation framed for impact and ROI.

Common Pitfalls to Avoid

  • Confusing absolute vs. proportional growth: Phones & Accessories is declining (-24.6% WoW) but still the largest category. Don't recommend killing it; instead, understand the shift (post-Cyber Week demand pull-forward).
  • Return rate denominator error: Always compute as returns / total_orders, not returns / returns. Bronze's 7.5% is meaningful only when you know it's based on 3,645 orders.
  • Cyber Week baseline distortion: If you only compare Cyber Week week to the prior week, you'll miss the larger seasonal context. Always compare to pre-peak baseline.
  • Ignoring repeat customers: Secondary cities may have lower per-order volume but higher repeat rates. Cohort analysis by first-order county is essential.
  • Not triangulating quality signals: Returns alone don't tell the story. Cross-check with delivery time, vendor tier, and order value to diagnose root causes.
1
Knowledge Check
Q1: Which category shows the strongest growth momentum into Q1?
Beauty (+18.2% WoW)
Phones & Accessories (-24.6% WoW)
Electronics (stable, highest GMV)
Fashion (growing, but slower)
Q2: What percentage of GMV do Nairobi and Mombasa represent?
50%
63.4%
75%
41%
Q3: What is the return rate for Bronze tier vendors?
1.5%
3.8%
7.5%
4.8%
Q4: Which statement is true about Bronze vendors?
They account for 30% of all orders
They drive 71% of returns despite 41% of orders
They have the lowest return rate
They are more reliable than Gold vendors
Q5: What is the correlation between delivery_days and is_returned?
-0.5 (strong negative)
0.127 (weak positive)
0.9 (strong positive)
No correlation
Q6: What is the top recommendation for Q1?
Double down on Beauty, tighten Bronze onboarding, expand secondary cities
Cut Phones & Accessories inventory entirely
Abandon all Bronze vendors immediately
Focus only on Nairobi

Cheatsheet: Sales Analysis Toolkit

Task Code Snippet
Load e-commerce data df = pd.read_csv('sales.csv'); df['date'] = pd.to_datetime(df['date'])
GMV by category df.groupby('category')['order_value'].sum().sort_values(ascending=False)
WoW growth rate (gmv_week2 - gmv_week1) / gmv_week1 * 100
Return rate by segment df[df['segment']=='X']['is_returned'].mean()
Concentration risk top_2 / total * 100
Correlation heatmap df[cols].corr(); sns.heatmap(...)
Cohort analysis df.groupby([df['date'].dt.to_period('M'), 'customer_id']).size()
KPI card format Metric name, value (bold, large), unit label (small)
Africa & India's Best AI Academy
πŸ€– AI-first πŸŽ“ Placement Assistance

Ready to Ship Your Analysis?

Join the Best AI Program: The AI-Era Analyst β€” 5 months, fully online, with placement assistance. Week 1 is free.

Explore The AI-Era Analyst β†’