Excel Programming & Marketing Support Needed

I have a stream of operational and campaign data that must be turned into clear, automated business-reporting dashboards inside Excel. The core of the job is to use advanced Excel programming—formulas, VBA, or Power Query, whichever you prefer—to pull raw tables, clean them, and generate weekly summary reports that management can read at a glance.

Alongside the technical build, I also want the reports to feed directly into ongoing marketing decisions, so an eye for marketing metrics and the ability to suggest small optimisation tweaks will be valued. Think of it as equal parts data-driven programming and practical marketing insight.

Key deliverables
• A fully automated Excel workbook that refreshes on demand and outputs management-ready business reports.
• Short documentation (or loom video) explaining the workflow so my team can maintain it.
• A brief set of marketing recommendations extracted from your findings in the data.

Acceptance criteria
The workbook must refresh without errors on a clean machine, complete its data processing in under five minutes, and reproduce the sample visuals we agree on during kickoff.

If you have solid experience combining Excel-based data analysis with marketing-oriented thinking, I’d love to hear how you would tackle this.