This project presents a comprehensive Excel-based analytics solution using Ferns and Petals data. The interactive dashboards explore sales, customer behaviour, product performance, orders, and delivery insights with advanced KPIs, visualisations, and business intelligence techniques; all implemented in Microsoft Excel.
Filename: FnP_Analytics.xlsm
Type: Excel Macro-Enabled Workbook (uses VBA & Power Query)
| Sheet Name | Description |
|---|---|
Sales_Analysis |
Revenue trends, top occasions, time-based heatmaps |
Customer_Analysis |
CLTV, gender/city breakdowns, repeat customers |
Product_Analysis |
Top/bottom products, category-wise stats |
Order_Insights |
Order timing, seasonality, basket size |
Delivery_Analysis |
Delivery duration, on-time %, city-wise trends |
Each dashboard includes interactive KPIs, Charts, and Tables, powered by Excel Slicers and Timelines.
- Microsoft Excel
- Pivot Tables
- Slicers & Timelines
- Power Query (ETL & data cleaning)
- Power Pivot (data modelling with relationships)
- VBA & Macros (automation and interactivity)