Weekly Sales Pivot Analysis

I manage a continuously growing sales dataset and need it reshaped into a clear, self-refreshing Excel solution that shows sales trends over time. Each week a new raw file drops; the workbook must absorb that file, update all Pivot Tables, and instantly refresh every chart and KPI that matters to management. What I expect • A single Excel file (macros, Power Query and Power Pivot welcome) that automatically pulls the latest weekly data and cleans it without manual intervention. • Pivot-driven dashboards highlighting week-over-week change, rolling averages, and year-to-date trend lines. • Slicers or filters so any stakeholder can drill into dates, product groups or regions on the fly. • Clear documentation inside the workbook (or as a short PDF) explaining how to add a new data dump and verify results. Acceptance criteria The file must load a fresh sample dataset I will provide, rebuild all visuals with one click of Refresh All, and reproduce the same trend numbers I supply separately for validation.

Project ID: 40185479