A curated selection of advanced Excel projects showcasing forecasting, automation, operational modelling and compliance analytics.
A fully automated 12‑month rolling forecasting engine with Base, Optimistic and Stress scenarios. Designed for leadership planning, sensitivity testing and operational decision‑making.
The model integrates historical actuals, editable assumptions, dynamic scenario selection and sensitivity multipliers. All charts and KPIs update instantly based on user inputs.
The forecasting engine uses structured inputs for revenue, volume, price, COGS and OpEx. Scenario drivers are stored as true decimals, enabling precise compounding calculations. A sensitivity module applies low/high shocks to key drivers and quantifies their impact on gross profit.
A variance module backtests forecast accuracy against actuals, decomposing variance into volume, price, COGS and OpEx contributions.
A structured operational model for managing client queries, SLA exposure, agent workload and category‑level trends. Designed for high‑volume environments requiring transparency and control.
The dashboard provides executive KPIs, workload distribution, SLA compliance and ageing analysis. Interactive filters allow real‑time inspection of the underlying query log.
A heat map highlights workload concentration across agents and categories, supporting capacity planning and escalation decisions.
A compliance‑focused dashboard for monitoring regulatory breaches, analysing risk trends and supporting case‑level investigation.
The model tracks breach records, mapped severity, regulator and root‑cause fields. A rolling 12‑month metric engine calculates weighted risk and open‑case trends.
Drilldown slicers allow targeted investigation by regime, severity, owner or status.