Revenue Structure &
Concentration Analysis

Evaluates revenue growth dynamics, customer concentration risk, and internal SKU dependency using HHI, effective counts, and Pareto concentration modeling.

Executive Summary

Javier Gallegos

SQL · Excel · Tableau · GitHub

Primary structural exposure is product-level fragility within select categories, not customer dependency. Customer and category concentration both score low risk; SKU compression in high-revenue categories warrants targeted monitoring.

0.034

Customer HHI

Low concentration — no single customer exceeds ~9% of total revenue.

0.142

Category HHI

Balanced category exposure; top 2 categories contribute ~40% of revenue.

3–4

Effective SKUs

Driving Category 1 revenue despite 12 total SKUs in the category.

Insight 1 · Revenue Growth

Monthly Revenue Growth Driven by Order Volume Expansion

Growth Accelerating

Monthly revenue bars with an order volume trend line that rises in the most recent months.

Revenue accelerated sharply in the last five months, with monthly orders reaching 77 and revenue hitting ~$129K. AOV remained stable and new customer acquisition stayed minimal, confirming growth is primarily volume-driven rather than price inflation.

Insight 2 · Customer Concentration

Pareto Distribution & Concentration

Low Risk

Pareto curve showing cumulative revenue concentration across ranked customers.

Top 20% of customers generate about 60% of revenue, indicating a mild Pareto curve. Customer HHI of 0.034 confirms low dependency risk at the customer level.

Insight 3 · SKU Dependency

SKU Compression Within Categories

Moderate Risk

Dumbbell chart comparing observed SKU concentration versus effective SKU counts by category.

Category 1 (~21% of revenue) shows the highest compression gap (HHI: 0.304). SKU-level dependency is localized to select categories - not customer or category-level.

Structural Risk Summary

LowCustomer Concentration — HHI 0.034
LowCategory-Level Concentration — HHI 0.142
ModerateSKU Dependency within select categories (1, 6, 5)

Primary exposure is product-level fragility, not customer or category dependency. Risk is localized at the SKU level within high-revenue categories.

Strategic Recommendations

  1. Monitor high-compression categories for overreliance on leading SKUs (Categories 1, 6, 5).
  2. Evaluate SKU rationalization where redundancy exists.
  3. Protect top-performing SKUs in compressed categories from supply or pricing disruptions.
  4. Continue customer diversification to sustain the current low-concentration structure.