Data Analysis in Spreadsheets (Pivot/Dashboard Plan)

I have this raw data: {{columns and sample rows}}, business question: {{question}}. Design the analysis: 1) required data cleaning/reshaping steps and a proper tabular data structure (no merged cells, consistent types, one row per {{event}}); 2) metric definitions as exact formulas (with how duplicates/refunds/cancellations are counted); 3) PivotTable design: rows, columns, values, filters, grouping; 4) dashboard layout (which 4-6 visuals, placement, slicers/timelines), and conditional-formatting rules for exceptions; 5) optional: a LET/FILTER-based dynamic summary if no pivot is desired; 6) how to refresh weekly without breaking. Assume the audience is {{exec / operational analyst}}.