US Superstore — Profitability & Margin Erosion Diagnostic
DuckDB SQL Analytical Pipeline • 49 States • 17 Sub-Categories
Total Revenue 37,873 Units
$2,297,200.86
Gross top-line sales across all divisions
Total Net Profit 12.47% Margin
$286,397.02
Technology & Office Supplies drive 93.6% of profit
Furniture Division Profit 2.49% Margin
$18,451.27
32.3% of revenue ($742.0K) but only 6.4% of profit
10 Loss-Making States -13.92% Margin
-$98,246.74
Generated on $705,684.21 sales (28%–39% discounts)
Texas Net Loss (Rank #1) 37.02% Avg Disc
-$25,729.36
$170,188.05 revenue eroded by uncapped discounting
Executive Takeaway: Severe margin compression in Furniture (2.49%) is driven by heavy promotional discounting in Tables (-$17,725.48 at 26.13% discount) and Bookcases (-$3,472.56 at 21.11% discount). Sub-categories with average discounts exceeding 20% consistently suffer margin collapse.
Macro Division Performance (Revenue vs. Net Profit)
Comparison across the three primary operating segments
Division P&L Summary Table
Query 1 output — Macro margin benchmarking
Division Units Sold Revenue ($) Net Profit ($) Net Margin (%) Share of Profit
Sub-Category Profitability & Discount Elasticity (17 Product Lines)
Query 2 output — Evaluating net profit against promotional discount rates
Sub-Category P&L Schedule
Click any column header to sort ascending or descending
Sub-Category Division Units Revenue ($) Net Profit ($) Margin (%) Avg Discount (%)
Geographic Audit: Exactly 10 states account for -$98,246.74 in net losses despite generating $705,684.21 in sales. Every loss-making state maintains an average discount between 28.35% and 39.00%, whereas top profitable states (California, New York) cap average discounts below 7.30%.
Regional Profit & Discount Variance Across States
Query 3 output — Comparing bottom 10 unprofitable states against top 10 profit leaders
Complete State-Level Financial Audit (49 States)
Click column headers to sort • Use search box to isolate specific states
State Revenue ($) Net Profit / Loss ($) Net Margin (%) Avg Discount Rate (%)
Root-Cause Isolation: Shipping mode analysis proves losses in Texas are driven by a flat 30.00% discount rather than expedited freight. Drilling into the Texas Consumer segment isolates Binders (-$12,166.62) and Appliances (-$4,252.27) as the primary financial bleeders.
Customer Segment Economics (Query 5)
Consumer drives 50.6% of revenue but trails in margin efficiency (11.55%)
Segment Revenue ($) Net Profit ($) Margin (%) Avg Discount
Shipping Hypothesis Test: Tables in Texas (Query 4)
Standard Class incurs the largest loss (-$1,466.03) under a flat 30% discount
Ship Mode Texas Tables Loss ($) Texas Discount Company-Wide Profit ($)
Granular Root-Cause Drill-Down: Texas × Consumer Segment (Query 6)
Net profit/loss across all 17 sub-categories within the Texas Consumer segment
Sub-Category Texas Consumer Sales ($) Texas Consumer Profit / Loss ($) Effective Margin (%) Status