This project analyzes Nike sales data to uncover key business trends, profitability drivers, and actionable insights across product categories, regions, customer segments, and sales channels.
The focus is on transforming messy, real-world sales data into a clean, reliable dataset and generating insights that support strategic decision-making.
- Analyze 2,500 Nike sales records
- Identify revenue and profit trends
- Evaluate product, region, and channel performance
- Provide actionable business recommendations
- Data Loading & Quality Assessment
- Data Cleaning & Validation
- Exploratory Data Analysis (EDA)
- Data Visualization
- Insight Generation & Business Recommendations
Initial dataset issues:
- Missing Order Dates: 24.6%
- Missing Units Sold: 49.4%
- Missing MRP: 50.2%
- Negative Units Sold
- Discounts greater than 100%
➡️ Highlighted the importance of data cleaning before analysis.
- Filled missing numerical values
- Converted negative units sold to positive
- Capped discounts at 100%
- Standardized region names
- Unified multiple date formats
- Removed invalid records
✅ Final clean dataset: 1,884 transactions
- Total Revenue: ₹546,786.16
- Total Profit: ₹2,563,539.17
- Total Units Sold: 1,765
- Average Order Value: ₹290.23
- Date Range: July 2023 – July 2025
- Men's category generates the highest revenue
- Kids category delivers the highest profit
- Indicates better margins in Kids’ products
- Top Revenue Generators: Basketball, Training, Soccer
- Lifestyle is the most profitable despite lower revenue → high efficiency
- Top Revenue Region: Kolkata
- Top Profit Region: Bangalore
- Bangalore shows high transaction volume but lower AOV
- Online generates more revenue
- Retail is slightly more profitable
- Transaction count is nearly identical
- Most profitable discount range: 40–50%
- Men’s Running shows negative profit margin (red flag 🚩)
- Revenue peaks in Q4 (Nov–Dec)
- Post-holiday slump in January
- Summer lull in July
- Optimize discount strategy for profitability
- Investigate losses in Men’s Running category
- Scale high-margin product lines (Lifestyle, Kids Basketball)
- Replicate Bangalore’s success model in other regions
- Improve data collection standards
📌 Full presentation-style report available in the report/ folder.
Ashok M
MIT License