Demo data only — a generated sales export for a fictional 12-product catalogue; no real client data. 486 messy rows cleaned to 471: 458 dates standardised, 374 region names normalised, 353 text amounts parsed to numbers, 15 duplicate rows removed. 63 missing categories filled with XLOOKUP typed live; monthly totals built with SUMIFS and COUNTIFS; pivot summaries by category, region and month cross-checked three ways. The dashboard: $678,119.39 total revenue, 471 orders, 5,955 units, $1,439.74 average order value, with region slicers that re-filter every number. Built in Google Sheets/Excel with real formulas, no manual totals.
0 likes · 0 views · Nov 9, 2026
Raw sales export cleaned and built into a live KPI dashboard on screen: 486 messy rows to 471 clean, XLOOKUP, SUMIFS, pivots and slicers.
