AAL is a well-known clothing brand in the United States operating since 2000, serving Kids, Men, Women, and Seniors. The company wants deeper insights into its quarterly sales (October–December 2020) to support expansion plans.
This project analyzes AAL's sales performance using Python and provides:
- Monthly trends
- State-level performance
- Customer group behavior
- Time-of-day purchasing patterns
- Key insights & business recommendations
- Clean and prepare raw sales data
- Normalize numerical fields
- Explore trends across dates, states, groups, and time slots
- Visualize patterns using bar charts, line charts, boxplots, and combined dual-axis charts
- Identify top-performing and underperforming segments
- Provide actionable business insights
- Loaded and inspected dataset
- Checked for missing values
- Converted
Datecolumn to datetime - Cleaned categorical fields
- Applied MinMax Scaling to
UnitandSalesfor transformation - Achieved normalized ranges between 0–1
- Daily sales and units visualized
- Identified major patterns across months
- December: Highest-performing month
- November: Notable dip in demand
- October: Strong but below December
- Identified top-performing and lowest-performing states
- WA recorded the lowest sales
- Men's category generated the highest sales
- Seniors category performed the lowest
- Morning had the highest sales
- Evening had the lowest activity
- Dual-axis sales & units plots used for stronger comparison
The project includes:
- Line plots
- Bar charts
- Dual-axis bar + line plots
- Boxplots
- Groupwise & statewise comparisons
All visualizations are stored inside the
/imagesfolder.
✅ December's rise indicates seasonal demand during holidays
✅ Men's category dominates overall sales
✅ Seniors category offers potential growth with targeted marketing
✅ Morning time shows peak purchasing activity
✅ Certain states (like WA) need marketing reinforcement
| Recommendation | Impact |
|---|---|
| Improve inventory for high-demand groups in December | 📈 Higher revenue |
| Focus on boosting sales in low-performing states | 🎯 Market expansion |
| Introduce evening discount campaigns | 🌙 Increased traffic |
| Expand senior-friendly product lines | 👴 New demographics |
| Launch regional marketing campaigns | 📍 Targeted outreach |
Ali Hamza Shaikh
Passionate about turning raw data into meaningful business insights.
