OVERVIEW: The FNP (Ferns N Petals) Sales Analysis project focuses on deriving insights from transactional sales data of an e-commerce business that specializes in gifts, flowers, and decor. This project involves data exploration, analysis, and visualization to uncover trends, customer behavior, and key business metrics. The project aims to support strategic decision-making by highlighting sales patterns, top-performing products, and customer preferences for various occasions. This is a comprehensive Excel-based project utilizing advanced techniques for data analysis and visualization.
TOOLS AND TECHNOLOGIES-
- Microsoft Excel for data cleaning, analysis, and visualization.
- Excel features such as pivot tables, charts, slicers, and formulas.
PROJECT WORKFLOW-
-
Imported and cleaned raw data to remove inconsistencies and duplicates.
-
Created an interactive dashboard to visualize key metrics and trends.
-
Used slicers to enable filtering by occasion, location, and time period.
-
Summarized data using pivot tables and charts for actionable insights.
Dashboard-
KEY INSIGHTS-
- The business processed 1,000 orders, generating a total revenue of ₹35,20,984, with an average customer spend of ₹3,520.98 per order.
- Order delivery took an average of 5.53 days, suggesting timely but slightly improvable logistics.
- Occasion-based revenue trends:
- Anniversary was the most lucrative occasion, contributing ₹7,00,000, followed by Raksha Bandhan with ₹6,00,000, and Valentine's Day with ₹5,00,000.
- Other major occasions like Diwali (₹4,00,000) and Holi (₹3,00,000) also drove significant sales.
- Category highlights: Colors emerged as the highest revenue generator, contributing ₹10,00,000, followed by Soft Toys (₹6,00,000) and Raksha Bandhan Gifts (₹4,00,000).
- Top products by revenue: The Deserunt Box was the best-selling product, earning ₹1,40,000, while other popular items like the Dolores Gift and Harum Pack generated ₹1,20,000 and ₹1,10,000, respectively.
- City-wise order distribution: Imphal led with the highest number of orders (30), closely followed by Kavali (28) and Dibrugarh (25).
- Hourly sales patterns: Peak revenue occurred between 2:00 PM and 4:00 PM, highlighting a significant midday purchase trend.
- Monthly revenue trends: August was the most profitable month, bringing in ₹7,00,000, while June saw the lowest revenue at ₹1,00,000.