This project analyzes the Superstore Sales Dataset (Kaggle) to uncover business insights and trends.
The goal is to support data-driven decision-making by examining sales, profit, customer segments, and regional performance.
- Analyze monthly and seasonal sales trends.
- Identify top-selling and low-profit products.
- Evaluate customer segments (Consumer, Corporate, Home Office).
- Compare sales & profit across regions and product categories.
- Provide actionable insights and recommendations.
- Source: Superstore Dataset on Kaggle
- Columns:
Order Date, Sales, Profit, Category, Sub-Category, Segment, Region, Product Name, Quantity, Discount
- Python π
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Time Analysis: Monthly/seasonal sales & profit trends.
- Product Analysis: Top 10 products by sales vs profit.
- Customer Segments: Contribution of Consumer, Corporate, Home Office.
- Region & Category Analysis: Sales comparison using stacked bar charts & heatmaps.
- Sales peak in November/December β Prepare inventory & promotions.
- Some products (e.g., Furniture) show high sales but low profit β Review pricing strategy.
- Consumer segment brings highest sales, while Corporate yields better profitability.
- West is the strongest region, while South needs more marketing focus.