Interactive product tour

Retail sales & forecast dashboard

A formula-driven Excel workbook that turns 5,009 orders into a live sales dashboard and a segment-level demand forecast through FY2030 — no macros required to keep it current. This tour walks through the workbook the way you'd actually use it.

Total revenue

$2,297,201

Total orders

5,009

Units sold

37,873

Avg order value

$458.61

Read the build write-up

How the workbook is structured, the SUMIFS/INDEX-MATCH/FORECAST logic behind it, and what I'd change for a production BI tool.

Read the case study