Overview

This project presents an end-to-end sales and logistics analysis for Ferns and Petals (FNP), a leading Indian gifting company known for occasion-based products such as Diwali, Holi, Raksha Bandhan, and Anniversaries. The analysis was performed entirely in Microsoft Excel, demonstrating in-depth proficiency in Excel for data analytics.

The goal was to uncover revenue trends, product performance, customer behavior, and delivery efficiency, and translate these insights into actionable business recommendations.

Dataset Summary

• Data Source: Ferns and Petals sales data (India)
• Structure: 3 relational tables (Orders, Customers, Products)
• Records: 1,000 Orders | 100 Customers | 70 Products
• Key Attributes:
  • Customer demographics
  • Order and delivery timelines
  • Product details and pricing
  • Occasion-based sales

Data Ingestion & Preparation (Excel + Power Query)

All data processing was handled within Excel:

• Imported multiple source tables using Power Query
• Cleaned and validated data (no missing values)
• Engineered new features, including order month, day, hour, and delivery lead time
• Calculated Total Revenue using price and quantity
• Built relational data models using Excel’s Data Model and table relationships

This step highlights strong ETL and data modeling capabilities using Excel alone.