Exploratory Data Analysis - Retail
Key Findings:
- Total sales was about 2.30M and profit percentage is 12.47
- Profit margin was analyzed based on state, city, category and sub-category
- Technology category had the maximum profit followed by office supplies
- On the basis of ship mode standard had the highest profit followed by second class
- Profit was inversely affected by discount
Recommendations:
Focus on the following areas weak areas-
- Category - Furniture
- Ship mode - Same day
- Segment - Home office