Ferns And Petals Sales Analysis
The FNP Sales Analysis Dashboard provides a comprehensive overview of business performance, customer behavior, and product trends. It tracks total orders, revenue, delivery performance, and average customer spending, while also breaking down revenue across occasions, product categories, and cities.
The goal of this dashboard is to enable data-driven decision-making by highlighting sales patterns, best-selling products, seasonal demand, and key revenue drivers.
- Total Orders: 1000
- Total Revenue: ₹35,20,984
- Average Customer Spend: ₹3,520.98
- Order Delivery Time (Avg): 5.53 Days
These KPIs indicate strong customer engagement and a consistent order flow, with a healthy average spend per order.
- Top Performing Occasions:
- Anniversary and Raksha Bandhan generated the highest revenue.
- Holi and Valentine’s Day also contributed significantly.
- Lower Performing Occasions:
- Diwali and Birthday sales were comparatively lower.
👉 This suggests that customer demand peaks during personal relationship-driven occasions rather than general festivals.
- Top Categories:
- Cakes dominated sales with the highest contribution.
- Soft Toys and Sweets were strong performers.
- Lower Categories:
- Mugs, Plants, and Colors had minimal revenue share.
👉 Core product lines (cakes and gifts) are revenue drivers, while novelty items underperform.
- Peak Months: March and August showed revenue spikes.
- Low Months: April, May, and November experienced sharp declines.
👉 Seasonal spikes suggest heavy dependence on festival/occasion periods; strategies are needed for off-season revenue growth.
- Revenue remains stable throughout the day, with noticeable peaks around 8 AM–10 AM and 8 PM–10 PM.
👉 Customers prefer early-morning orders (likely gifting surprises) and evening purchases.
- Magman Set – Highest selling product.
- Quia Gift – Close second.
- Dolores Gift, Deserunt Box, and Harum Pack also performed strongly.
👉 Premium gift sets are the top contributors, indicating strong customer preference for bundled gifting solutions.
- Top Cities by Orders: Durg, Kalyani, and Khardah led order volumes.
- Other High-Performing Cities: Bhopara, Bilaspur, and Guntrah.
👉 Strong penetration in Tier-2 and Tier-3 cities suggests growth opportunities beyond metros.
- Expand Core Categories: Cakes, sweets, and toys should be prioritized for marketing and inventory.
- Boost Underperforming Categories: Launch targeted campaigns for plants, mugs, and colors.
- Off-Season Campaigns: Create promotions during low months (April–May, November) to balance revenue cycles.
- Time-Based Promotions: Offer discounts in the evening (8–10 PM peak) to maximize conversion rates.
- Regional Expansion: Invest in Tier-2/3 city logistics and marketing campaigns, where demand is rising.
The FNP Sales Dashboard highlights strong customer demand for cakes and gifting products, occasion-based purchase trends, and significant contributions from non-metro cities. By focusing on seasonal campaigns, improving weaker product categories, and enhancing customer engagement during off-peak months, FNP can accelerate growth and profitability.
Created by: Paramesh Mandapaka
📧 mandapakaparamesh9@gmail.com
⭐ If you find this project helpful, give it a star on GitHub!