SALES ANALYTICS · EXCEL
Sales Performance in Excel
How do sales vary by region, channel, product, and month?
2,000 orders · Portfolio case study
Revenue by region · USD
Web visualisation · calculated from supplied dataThe 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
- Mapped business questions to revenue, orders, quantity, and average order value.
- Built supporting PivotTables and five sales charts.
- 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.