This project is an interactive Sales Analysis Dashboard created using Microsoft Excel based on data from FNP (Ferns N Petals). It offers insights into customer behavior, revenue trends, and product performance across various dimensions.
- Total Orders: 1,000
- Total Revenue: ₹35,20,984
- Average Customer Spend: ₹3,520.98
- Average Order-Delivery Time: 5.53 days
- Highest revenue generated during Anniversaries followed by Raksha Bandhan and Valentine’s Day.
- Birthday and Diwali performed moderately.
- Colors and Soft Toys generated the highest revenue.
- Mugs had the lowest contribution, suggesting low customer interest.
- Most orders were placed between 4 AM to 8 AM and 4 PM to 6 PM, indicating peak customer activity.
- August and February saw the highest revenue spikes, correlating with Raksha Bandhan and Valentine’s Day.
- June and July saw a dip, indicating off-season for gift purchases.
- Magnam Set
- Quia Gift
- Dolores Gift Harum Pack
- Deserunt Box
- Harum Pack
- Highest orders from Imphal, Dhanbad, and Kavali.
- Cities like Gunkaal and North Dumdum showed moderate order volume.
- Microsoft Excel – Pivot Tables, Charts, Slicers, and Timeline Filters for interactivity.
- Data Cleaning and Transformation done using Excel formulas and functions.
Feel free to reach out for any feedback and suggestions.
Harshdev Parmar
📧 Email: harsh.parmar03@gmail.com