Automated Excel Performance Dashboard

I need a single Excel workbook that turns my monthly sales and inventory figures into clear, automated insights. Once I drop raw data into a dedicated sheet, every other page in the file should refresh instantly, giving me:

• Dynamic graphs and charts that highlight month-to-month performance shifts
• Clean summary tables for quick reference
• Pivot tables I can slice by product line, region, or any future field I add

The focus is purely on reporting and analysis—no transaction entry or stock-count tools are necessary. I’m happy for you to lean on Power Query, Power Pivot, VBA, or standard formulas, as long as the end result updates with one click (or better, on open) and stays easy for a non-technical user to maintain.

Hand-over will include the finished workbook, a brief walkthrough video or document explaining where to paste new data, and confirmation that all visuals recalculate correctly with sample updates.