N. Okoro
← All projects

SALES ANALYTICS · EXCEL

Sales Performance in Excel

How do sales vary by region, channel, product, and month?

Excel

2,000 orders · Portfolio case study

Revenue by region · USD

North561,754
Central556,705
East467,809
South444,494
West421,322
Web visualisation · calculated from supplied data

The question & data

A practice dashboard connects business questions to KPI cards, PivotCharts, slicers, and timelines.

2,000 distinct order IDs in a learning/practice dataset. The workbook includes planning and supporting pivot sheets.

The approach

  1. Mapped business questions to revenue, orders, quantity, and average order value.
  2. Built supporting PivotTables and five sales charts.
  3. Connected slicers and timelines for focused comparisons.

What the work reveals

Dataset revenue totals $2,452,084.30 across 2,000 orders.

The dataset contains 5,552 units sold; average revenue per order is $1,226.04.

From findings to next steps

Explore category and channel contributions before prioritising a deeper margin or customer analysis.

Read the results in context

Practice data includes dates through December 2026; it is not evidence of realised business results.

Based on supplied portfolio materials. Findings describe the dataset and report; recommendations are proposed next steps, not measured business outcomes.

Next case study Zepto Inventory & Pricing ↗