f

Ferns N Petals — Sales Analysis

1 Jan – 29 Dec 2023
The finding
Four festival months carry
68% of the year's revenue.

Valentine's, Holi, Raksha Bandhan and Diwali compress a gifting business into four narrow windows. The other eight months run at roughly a fifth of that pace — which makes inventory, staffing and delivery capacity a calendar problem before it is a demand problem.

Occasion
Category
Timing

When does the year actually happen?

Revenue by month

Bars are revenue; the line is average order value. Festival months are marked.

Day of week

Orders placed, by weekday.

Hour of order

Gifting doesn't keep office hours — shaded bands are the small hours.

Weekday × hour density

Each cell is one hour-slot; brighter means more orders placed.
Assortment

What sells, and what earns?

Category

Revenue, with orders and average order value alongside.

Top products by revenue

Bars are coloured by category. Hover for units and order count.

Price band

Where revenue concentrates across the ₹203–₹1,977 catalogue.

Basket size

Units per order, from 1 to 5 — share of orders vs share of revenue.
Occasion

Which occasion pays best?

Revenue and order value by occasion

Volume and value pull in different directions here.

Category × occasion

Revenue in ₹ thousands (so 121 = ₹1.21 lakh). Reads as a buying-pattern map.
Customers

Who buys, and where do gifts land?

Highest-value customers

Lifetime revenue across the period, with order count.

    Delivery cities by orders

    Gifts ship to the recipient, not the buyer — so this is a long tail.

      Buyer split

      Revenue by registered buyer gender.
      Fulfilment

      Do we keep the delivery promise?

      Order-to-delivery time

      Measured to the hour from order timestamp to delivery timestamp.

      Average days, by occasion

      A dated-event gift is late if it misses the date — so spread matters more than the mean.
      Reference

      What's in the data?

      Model

      Two one-to-many relationships, joined on the keys below — the same star schema the Power Pivot version used.

      customers.csv · 100 rows

      One row per registered buyer.

      orders.csv · 1,000 rows

      One row per order — the fact table.

      products.csv · 70 rows

      One row per catalogue item.