Project Overview: Ferns and Petals Sales Analysis

This analysis project focuses on understanding the sales performance and customer behavior of Ferns and Petals (FNP) — a leading gifting platform specializing in delivering products for occasions like Diwali, Raksha Bandhan, Holi, Valentine's Day, Birthdays, and Anniversaries. The goal of this project is to uncover actionable insights that can help optimize sales strategies, enhance product offerings, and improve customer satisfaction.

Using Microsoft Excel, the dataset was systematically:

• Loaded, cleaned, and transformed to ensure data integrity,
• Modeled to establish relationships between orders, products, customers, and occasions,
• Analyzed using Pivot Tables, DAX measures, and other Excel tools,
• And finally visualized with an interactive dashboard featuring charts, slicers, and KPIs.

The dashboard provides clear answers to ten key business questions, covering areas such as:

• Total revenue generation
• Average order and delivery time
• Monthly and occasion-based sales trends
• Top-performing products and customer segments
• Geographic insights on order distribution
• Product popularity across different occasions

This analysis serves as a foundation for data-driven decision-making and helps Ferns and Petals refine their marketing and logistics strategies moving forward.

Problem Statements:

1. Total Revenue: Identify the overall revenue.

$3,520,984.00