Reporting (excel expert needed)

Deep dive excel reporting to analyse:


forecast report on quantity and value by product categories and reference to analysis



*Sales analysis
Need reports to Assess the performance on a monthly/yearly/Last 3 months L6 months basis.
The report will focus on network , product categories, segment, sub segment & collections view Goal: Provide recommendations and ,conduct fast ad hoc analysis request. Understand and identify exactly what is working and what is not (which product, model color size gender etc...


*Forecast and assortments
Need a report with a very precise calculation + automated formulas on forecasts definition for in-range products and novelties, on sales performance vs. forecasts and on assortments by point of sale.



I'm looking for:

A report easy to update and amend changes on formulas + overall format

An expert in excel and Macro

Someone who had an experience in similar request + work in Marketing/performance/forecast analysis.

Familiar with Bi extractions



Of course I'm open for any recommendations.