Abdul Rehman Ansari
All projects

Sales and business analytics

Ferns & Petals Business Analytics

Compare order, revenue, profit and occasion patterns across months, products and cities.

ExcelPower BIBusiness analysisETL
Open project repository Ask about this work
1,000 orders01 / scope
3,521K revenue02 / scope
704K profit03 / scope
August, February and March sales peaks04 / scope
01

Business question

How do sales and profit change across months, occasions, products and cities?

02

Data

Order and sales records compared by month, occasion, product and city.

03

Approach

  1. 01Prepare and summarize order data
  2. 02Compare monthly sales and profit
  3. 03Review occasion-level revenue share
  4. 04Compare city and product order patterns
04

Analysis

Built dashboard views for order volume, revenue, profit, average delivery metrics, monthly trends, occasion mix and top cities/products.

What I builtSales dashboard covering monthly performance, occasions, products and city comparisons.

05

Key findings

  • 01

    Across 1,000 orders, totals were 3,521K in revenue and 704K in profit.

  • 02

    Sales peaks occurred in August, February and March.

  • 03

    Raksha Bandhan represented 18% and Holi 16% of revenue share.

06

Business context

The monthly peaks and occasion shares make seasonality and occasion mix visible for sales reporting.

07
Open project repository

More analytics work

Browse all projects