1. Problem Statement
The Outerwear category has shown persistent underperformance across multiple business dimensions: revenue, margin, and customer engagement. Despite moderate sales spikes in peak seasons (Fall and Winter), total Outerwear revenue ($18.5K) lags far behind other categories, indicating structural weaknesses in demand generation and retention.
High discount penetration (44.4%) suggests dependency on promotions to move stock, compressing margins and signaling that customers perceive inadequate value at full price. Meanwhile, ratings are only moderate (3.75 overall) and decline further in Fall (3.64), implying inconsistent product quality or unmet customer expectations during the peak sales window.
Seasonal dependency, discount-driven sales, and stagnant customer retention lead to a vicious cycle: deep discounting drives one-time purchases but suppresses long-term profitability. Our analysis aims to diagnose these issues and design actionable solutions for merchandising, marketing, and financial optimization.
2. Primary Hypothesis
H₀ (Null Hypothesis):
Outerwear performance aligns with normal seasonal apparel patterns and observed sales fluctuations reflect natural demand variability.
H₁ (Alternative Hypothesis):
Outerwear underperforms due to addressable factors — seasonal dependency, discount addiction, quality decline, and poor retention — which can be mitigated via assortment diversification, pricing strategy, and loyalty optimization.
3. Sub-Hypotheses and Analytical Approach
| ID | Sub-Hypothesis | Key Tests | Expected Outcome |
|---|---|---|---|
| H1 | Seasonality Hypothesis: Outerwear revenue is overly concentrated in Fall–Winter seasons. | Seasonality Index; Chi-square for uniformity; MoM trendline | Revenue >50% from Fall/Winter → confirms dependency. |
| H2 | Discount Dependency Hypothesis: High discount penetration artificially sustains volume. | T-test on AOV (discounted vs non-discounted); Repeat purchase rate | Discounts → higher one-time buyers, lower loyalty. |
| H3 | Quality/Ratings Hypothesis: Outerwear ratings dropping in Fall correlate with reduced repurchase rates. | ANOVA: ratings vs season; correlation (rating vs repurchase) | Declining Quality → reduced retention, especially in Fall. |
| H4 | Retention Hypothesis: Outerwear attracts one-time, non-subscriber customers. | Chi-square: loyalty distribution; segment comparison (new vs loyal buyers) | Majority transactions from non-subscribers → poor loyalty. |
| H5 | Assortment Mismatch Hypothesis: SKU concentration in specific sizes/colors limits appeal. | Herfindahl Index on SKU diversity; distribution plots (size/color) | Over-indexed in M/Cyan → missing revenue from underserved segments. |
4. PromptBI Dashboard Link
Outerwear Category Analytics and Deep Dive
Summary Insight: The Outerwear category has shown significant trends in revenue, transaction counts, and customer preferences, with notable seasonal variations and discount impacts.
Key Metrics:
- Total Outerwear Revenue: $36,753.00
- Average Outerwear Rating: 3.75
- Outerwear Transaction Count: 639
- Most Common Outerwear Size: M
- Most Common Outerwear Color: Cyan
Supporting Metrics and Trends:
- Revenue by Category: Clothing leads with the highest total revenue, but Outerwear has a significant presence.
- Average Order Value (AOV): Footwear has the highest AOV, indicating higher-value purchases.
- Transaction Count: Clothing is the most transacted category.
- Units Sold: Clothing also leads in units sold.
- Rating Distribution: The most frequent rating bin is 3.25-3.5.
- Discount Penetration: Outerwear has the highest discount penetration among all categories.
- Customer Loyalty Metrics: Loyal customers show a higher transaction count in the Outerwear category.
- Seasonal Trends:
- Revenue Peak: Fall season
- Transaction Peak: Winter season
- Price Distribution: The most frequent price bin for Outerwear is $20.00-$30.00.
5. Visuals Section — PromptBI Chart Placement Guide
1. Revenue by Category Comparison (Bar Chart)
Key Insights:
- The chart reveals the total revenue generated by different product categories: Accessories, Clothing, Footwear, and Outerwear.
- The highest revenue is from Clothing with $104,264, followed by Accessories with $74,200.
- Footwear generates $36,093 in revenue, while Outerwear has the lowest revenue at $18,524.
Trends and Implications:
- Clothing is the top revenue generator, indicating strong customer demand and potentially higher profit margins.
- Outerwear, with the lowest revenue, suggests either lower demand, higher competition, or pricing issues.
Customer and Business Impact:
- The disparity in revenue between categories highlights the need for targeted strategies to boost underperforming segments like Outerwear.
- Understanding why Outerwear has the lowest revenue could uncover market gaps or customer pain points.
2. Average Order Value by Category (Bar Chart)
Key Insights:
- The Outerwear category has the lowest Average Order Value (AOV) at $57.17, significantly below the other categories.
- In contrast, Footwear leads with the highest AOV at $60.26.
Business Implications:
- The lower AOV in Outerwear suggests potential areas for improvement in customer engagement or product offerings within this category.
- Consider analyzing customer feedback and sales data specific to Outerwear to identify pain points or opportunities for upselling.
3. Transaction Count by Category (Bar Chart)
Key Insights:
- Outerwear transactions are 54% lower than Accessories and 81% lower than Clothing.
- This indicates potential underperformance or lower customer demand in the Outerwear segment.
Business Implications:
- Consider reviewing the Outerwear product lineup for relevance and appeal.
- Evaluate marketing efforts targeted at this category to identify gaps.
- Explore seasonal trends or external factors affecting Outerwear sales.
4. Units Sold Comparison (Bar Chart)
Key Insights:
- Lowest Sales Volume: Outerwear has the fewest units sold at 324, significantly lower than other categories.
- Sales Gap: There's a notable 1,413 units difference between Outerwear and the highest-selling category, Clothing.
Business Implications:
- The low sales in Outerwear may indicate market saturation, competitor dominance, or customer disinterest.
- Consider a market analysis to understand the underlying causes and explore strategies to boost Outerwear sales.
5. Rating Distribution (Histogram)
The histogram reveals the distribution of customer ratings for the Outerwear category, which is crucial for understanding customer satisfaction and identifying areas for improvement.
Key Trends:
- The most frequent rating bin is 3.25-3.5, indicating a central tendency towards average satisfaction.
- Ratings between 3.25-3.5 and 3.75-4.0 have the highest number of reviews, suggesting a significant portion of customers are moderately satisfied.
- There is a noticeable drop in the number of reviews for ratings below 3.0, implying fewer customers are highly dissatisfied.
- The lowest rating bin (2.5-2.75) still has a considerable number of reviews (379), indicating room for improvement in product quality or customer experience.
Business Implications:
- Focus on enhancing products or services to move the average ratings upwards, especially targeting the 2.5-2.75 range.
- Investigate the causes behind the moderate satisfaction levels in the 3.25-3.5 range to identify specific pain points or areas for enhancement.
- Leverage the high number of reviews in the 3.75-4.0 range to gather insights on what customers appreciate most, and amplify those aspects in marketing and product development.
6. Discount Penetration by Category (Bar Chart)
Outerwear leads in discount penetration, signaling strong customer response.
Key Insights:
- Outerwear has the highest discount penetration at 44.44%, indicating a robust customer response to discounts in this category.
- Accessories and Footwear follow with discount penetrations of 43.79% and 43.24% respectively, showing consistent customer interest.
- Clothing has the lowest penetration at 42.08%, suggesting potential room for optimization in discount strategies.
Business Implications:
- Focus on maintaining and enhancing discount strategies for Outerwear to capitalize on high customer engagement.
- Investigate why Clothing has lower discount penetration and explore opportunities to increase its appeal through targeted promotions or product improvements.
- Monitor trends in Accessories and Footwear to ensure continued customer interest and adjust strategies as needed.
7. Customer Loyalty Metrics by Category (Stacked Bar)
Transaction Insights:
The Outerwear category shows a total of 324 transactions (233 non-subscribers + 91 subscribers).
Key Trends:
- Non-subscribers dominate with 233 transactions, significantly higher than subscribers.
- Subscribers contribute 91 transactions, indicating a smaller but present loyal customer base.
Business Implications:
- The lower transaction count for subscribers suggests potential growth in customer loyalty for Outerwear.
- Focus on converting non-subscribers to subscribers could increase overall transaction volume.
8. Outerwear Revenue by Season (Line Chart)
Why It Matters:
Understanding seasonal revenue trends in the Outerwear category is crucial for aligning inventory, marketing efforts, and customer engagement strategies.
Key Trends:
- Spring: High revenue at $9,749, indicating strong demand.
- Summer: Lowest revenue at $7,449, suggesting reduced need for outerwear.
- Fall: Peak season with revenue at $9,778, the highest point.
- Winter: Slight drop from Fall, revenue at $9,777.
Business Implications:
- Focus marketing and promotions in Fall to capitalize on peak demand.
- Consider inventory adjustments for Summer to align with lower demand.
- Analyze customer behavior in Spring to replicate successful strategies in other seasons.
9. Outerwear Transactions by Season (Line Chart)
Why It Matters:
Understanding seasonal trends in outerwear transactions helps in aligning inventory, marketing efforts, and customer engagement strategies to maximize sales and customer satisfaction.
Key Trends:
- Winter Peak: Outerwear transactions peak in Winter with 170 transactions, indicating high demand during this season.
- Spring High: Spring follows closely with 169 transactions, suggesting strong seasonal demand.
- Lowest in Summer: Summer sees the lowest transaction count at 134, reflecting reduced need for outerwear.
- Fall Resurgence: Fall shows a resurgence with 166 transactions, close to Spring levels.
Business Implications:
- Focus marketing and promotional efforts on Winter and Spring to capitalize on high transaction periods.
- Consider inventory adjustments to ensure sufficient stock during peak seasons while managing lower demand in Summer.
- Explore strategies to boost sales in Summer, such as promoting lightweight outerwear or transitional pieces.
10. Discount Impact on Outerwear Revenue (Scatter Plot)
Why This Matters:
Understanding how discounts affect outerwear revenue is crucial for optimizing sales strategies and maximizing profit margins.
Key Trends:
- Fall shows the highest revenue at $9,778 with a discount penetration of 45.18%.
- Summer has the highest discount penetration at 50% but the lowest revenue at $7,449.
- Spring and Winter show similar revenue figures around $9,750 with discount penetrations of 40.24% and 47.65%, respectively.
Trendline Analysis:
The trendline equation y = -185.25x + 17666.75 indicates a negative correlation between discount penetration and revenue. As discount penetration increases, revenue tends to decrease.
Business Implications:
- Higher discounts do not necessarily lead to higher revenue, as seen in Summer.
- Moderate discount levels in Fall and Winter correlate with peak revenue.
- Consider reducing discount levels in Summer to potentially increase revenue.
11. Customer Segmentation by Season (Clustered Bar)
Why This Matters:
Understanding customer behavior across different seasons helps tailor marketing strategies and inventory planning for the Outerwear category.
Key Trends:
- Loyal Customers Drive Transactions: The 'Loyal' segment consistently shows higher transaction volumes compared to the 'Active' segment across all seasons.
- Seasonal Variance:
- 'Loyal' customers peak in Spring with 133 transactions and maintain high levels in Fall (129) and Winter (132).
- 'Active' customers show less variance, ranging from 31 transactions in Summer to 38 in Winter.
- Summer Low for Loyal Customers: The 'Loyal' segment drops to 103 transactions in Summer, indicating a potential area for engagement strategies.
Business Implications:
- Focus retention strategies on the 'Loyal' segment to maintain high transaction volumes.
- Investigate why 'Loyal' customers drop in Summer and develop targeted campaigns to re-engage them during this period.
- Consider inventory adjustments to align with the high demand from 'Loyal' customers in Fall, Spring, and Winter.
12. Price Distribution (Histogram)
Customers prefer lower price ranges.
Key Trends:
- The most frequent price bin is 20.0-30.0 USD, with 112 transactions. This indicates a strong preference for lower-priced outerwear.
- The number of transactions decreases as the price increases from 20.0-30.0 USD to 70.0-80.0 USD.
- There is a slight uptick in transactions in the 80.0-90.0 USD range, suggesting a segment of customers willing to pay a bit more.
Business Implications:
- Focus marketing efforts on the 20.0-30.0 USD range to capture the largest customer segment.
- Consider promotional strategies for the 80.0-90.0 USD range to leverage the observed interest.
- Analyze the 70.0-80.0 USD range to understand the drop-off and adjust pricing or product offerings accordingly.
13. Size and Color Distribution (Stacked Bar)
Why This Matters:
Understanding the distribution of outerwear sizes and colors helps tailor inventory and marketing strategies to meet customer preferences effectively.
Key Trends:
- Medium Size Dominance: Size M has the highest counts across almost all colors, indicating a strong preference for this size.
- Popular Colors: Beige, Blue, Brown, and Gray are consistently popular across all sizes, with notable peaks in Size M.
- Size L Insights: Size L shows a varied distribution with Cyan and Brown leading, suggesting a niche market within larger sizes.
- Size S Observations: Size S has lower overall counts, with Beige and Olive standing out, hinting at specific customer segments.
- Size XL Trends: Size XL has the lowest counts, with Cyan and Lavender showing slight preference, indicating limited demand.
Business Implications:
- Focus inventory replenishment on Size M, especially in popular colors like Beige, Blue, and Gray.
- Consider targeted marketing campaigns for Size L, highlighting popular colors like Cyan and Brown.
- Evaluate the need for Size S and XL, possibly reducing stock for less popular colors to optimize inventory.
- Explore customer feedback for Size S and XL to understand specific needs and preferences.
6. Short Conclusion & Prioritized Recommendations
Key Takeaways
- Outerwear's low profitability stems from high discount usage, narrow SKU range, and weak customer retention.
- Seasonality is confirmed but not optimized — demand surges in Fall/Winter, yet margins erode.
- Moderate but declining ratings suggest emerging product or expectation alignment issues.
- Data indicates assortment imbalance (overindexing in size M and Cyan color), limiting growth potential.
Recommendations by Function
| Function | Action Priority | Recommendation |
|---|---|---|
| Merchandising | 🔹 High | Diversify Outerwear SKUs — introduce extended sizes (S, XL), rebalance color range, and add transitional products for off-seasons. |
| Marketing | 🔹 Medium | Shift communication from discount-heavy promos to "durability and design" value messaging; launch a Summer lightweight outerwear campaign. |
| Finance | 🔹 High | Optimize discount policy — cap average discount <35%, test bundle promos instead of direct markdowns to protect margin. |
| CRM / Loyalty | 🔹 Medium | Introduce a loyalty reward or seasonal bundle subscription for outerwear customers to improve repeat purchase rates. |
One-Line Executive Summary
"Outerwear's performance problem is not demand shortage but value perception and assortment imbalance — by optimizing variety, discount structure, and retention strategy, the category can regain profitability and year-round engagement."
Top comments (0)