Skip to content

Case studies

Work grouped by the operating problem it solves

Scan the work by leadership need: faster reporting, cleaner ERP and group data, controlled AI-assisted finance operations, and transaction rigour.

Reporting and decision support

Shorter reporting cycles, controlled numbers and leadership-ready views.

5 case studies
Finance reporting automation Internal work sample

Group Budget vs Actual reporting suite

−85%

Prep time per entity

Released roughly 1,400 hours of finance capacity a year by replacing fragmented reporting files with one controlled Budget vs Actual suite. Preparation time per entity fell by 85%.

  • Excel ·
  • Power Query
BI delivery and ERP-connected reporting Internal work sample

ERP-connected inventory reconciliation dashboard

Gave finance and operations a shared, refreshable view of stock, costing and reconciliation exceptions through a report connected directly to Business Central and Navision data.

  • Power BI ·
  • DAX ·
  • Power Query ·
  • Dynamics 365 Business Central ·
  • Navision
Finance reporting automation Capability project

Controlled workbook-to-board-pack pipeline

71 / 71

Pipeline tests

Built an eight-stage pipeline that turns validated workbooks into self-contained board packs, passing 71 of 71 pipeline tests and 15 of 15 business gates.

  • Python ·
  • Pure-Python HTML/SVG renderer ·
  • YAML/JSON contracts ·
  • pytest ·
  • Headless-Chrome PDF
BI delivery and ERP-connected reporting Internal work sample

Governed Power BI models for operational and financial reporting

2 source-controlled

Semantic models

Delivered two source-controlled semantic models across 128 entities, giving operational and financial reporting a reviewable, governed foundation.

  • TMDL v3 / PBIP ·
  • DAX ·
  • Power Query (M) ·
  • Dynamics 365 CDS
Finance reporting automation Internal work sample

Finance operations workflow suite

3

Flow families in production

Automated three recurring finance operations: targeted file-change alerts, a queryable email evidence trail and supplier price-list collection for downstream reconciliation.

  • Power Automate ·
  • SharePoint ·
  • Outlook ·
  • Excel

ERP and group data architecture

Reliable source data, conformed dimensions and foundations for one group view.

4 case studies
ERP & group data architecture Internal work sample

Business Central remediation and integration readiness

months → weeks

Remediation time

Completed a Business Central remediation in weeks rather than months, protecting a live CRM integration and leaving documented operating controls.

  • Dynamics 365 Business Central ·
  • Navision ·
  • AI-assisted workflow design
ERP & group data architecture In progress

Group financial intelligence model

185

Entities modelled

Created the blueprint for consistent actual, budget and forecast reporting across 185 entities, multiple currencies and heterogeneous ERP environments.

  • Semantic layer design ·
  • Power Query ·
  • Power Pivot
ERP & group data architecture In progress

Finance data standardisation programme

~160

Companies standardised

Establishing common finance definitions, mapping rules and data-quality controls across roughly 160 operating companies and heterogeneous source systems.

  • Master data management ·
  • Mapping rules ·
  • Data quality controls
ERP & group data architecture Internal work sample

Multi-ERP reporting router

128

Companies live

Unified roughly twenty entity types for 128 live companies through one metadata-driven engine, reconciling three ERP API generations into a controlled reporting model.

  • Power Query (M) ·
  • TMDL ·
  • DAX ·
  • OData ·
  • Python

AI-assisted finance operations

Automation and AI that release capacity while deterministic checks and finance review retain control.

4 case studies
AI & agentic workflows In progress

Controlled invoice reconciliation pipeline

EUR 482k

Documented pilot

The purchase side of an end-to-end supply transformation: controlled invoice extraction with layered stock-determination logic, staged for Business Central behind a sign-off gate — estimated to release roughly 450 hours a year once posting goes live.

  • Python ·
  • LLM tooling ·
  • Deterministic validation controls
AI & agentic workflows Internal work sample

Controlled cross-ERP entity matching

62 → 117 / 144

Golden-corpus accuracy

Raised golden-corpus matching accuracy from 62 to 117 of 144 while admitting zero hard-negative automatic accepts, creating a controlled path towards a reliable cross-ERP master.

  • Python ·
  • rapidfuzz ·
  • scikit-learn (TF-IDF) ·
  • LLM referee ·
  • Pydantic ·
  • AI coding assistants (Claude Code, Codex)
AI & agentic workflows Sanitised case study

Supplier pricing benchmark with independent validation

99.2%

Structured-corpus reconciliation

Produced a defensible supplier pricing benchmark with 99.2% structured-corpus reconciliation and 98.2–98.3% agreement between two independent extraction engines.

  • Python ·
  • regex ·
  • pdfplumber ·
  • pandas ·
  • Pydantic ·
  • Gemini vision
AI & agentic workflows Internal work sample

Fleet consumption analysis and asset resolution

222 · 2,681 lines

Invoices processed

The consumption side of the same supply transformation: asset-level visibility across 222 invoices and 2,681 lines, resolving inconsistent identities and flagging 24 price-outlier codes for review.

  • Python ·
  • Gemini (structured output + search grounding) ·
  • openpyxl

M&A, audit, and transaction rigour

Reusable methods for valuation, due diligence, audit-ready analysis and executive decisions.

3 case studies
M&A, audit & deal work Capability project

M&A due diligence and decision framework

Built a reusable M&A framework that turns valuation, quality-of-earnings and financial-risk analysis into consistent, board-ready decision support across live transactions. One engagement has reached an acquisition recommendation and integration plan; no completed transaction outcome is disclosed.

  • IFRS IAS 21 ·
  • Quality-of-earnings analysis ·
  • AI-assisted workflows
M&A, audit & deal work Completed

Financial architecture for a major European deal

11 months

Engagement

Led the financial architecture for the largest European deal in Avanade's 15-year history, keeping internal economics and client-facing outputs reconciled throughout an 11-month engagement.

  • Excel ·
  • Financial modelling
M&A, audit & deal work Completed

Audit transformation through data analytics

+20%

Audit efficiency

Increased audit efficiency by 20% and inventory-testing performance by 30% by directing audit work towards material entries and control exceptions.

  • Excel ·
  • Audit analytics