Work that changed how leaders decide.

The challenge

Forecast accuracy, on-time-in-full delivery, inventory days and cost to serve each came from a different team and a different source. Root causes surfaced weeks late; expedited freight and write-offs were discovered after the fact.

What we did

• Defined one KPI language for plan, source, make and deliver: north-star outcomes, driver KPIs, owners and thresholds
• Built a certified data model on Microsoft Fabric covering demand, supply, inventory, production, logistics, quality and financial impact
• Delivered a control tower with exception triage across the seven processes: idea to launch, forecast to plan, source to pay, plan to produce, order to cash, deliver to serve and record to report
• Set up the operating model: a business owner for every process, a weekly KPI quality review and closed-loop issue tracking

Impact

• +8 pts forecast accuracy in pilot categories
• −12% inventory days with no loss of service
• +4 pts on-time-in-full delivery and 15% less premium freight

The challenge

Critical processes ran on spreadsheets, email approvals and one-off tools. Each new request was built differently, with no common model for security, data access or support.

What we did

• Defined the Power Platform environment strategy, security roles, data-access model and DLP policies
• Built reusable patterns for apps, cloud flows and approvals, integrated through Azure Functions, Logic Apps and Data Factory
• Introduced Copilot Studio agents, multi-agent orchestration and Model Context Protocol integrations into day-to-day workflows
• Put analytics projects under Git version control with Azure DevOps CI/CD

Impact

• 30+ digital solutions delivered per year
• Governed environments with clear separation of duties
• AI agents embedded in operational workflows, within existing security standards

The challenge

Commercial teams reconciled figures by hand before every review. Pricing exceptions surfaced late, and nobody owned an end-to-end view of the registration process.

What we did

• Designed and delivered a Power BI sales management system as part of a digital transformation program
• Built price-control analytics comparing online marketplace prices against policy
• Delivered a category market-share dashboard with financial-efficiency analysis
• Led a Lean Six Sigma project to map and streamline product registration

Impact

• One trusted view of sales performance across channels
• Price deviations visible by platform and product
• Significantly shorter product-registration lead times

The challenge

Deductions were cleared manually weeks after invoicing. Expedited freight and small-order surcharges were absorbed as overhead, so unprofitable service patterns stayed invisible.

What we did

• Built an order-to-cash control tower: order fill, on-time delivery, invoice accuracy, open deductions and days sales outstanding on one page
• Modeled cost to serve by customer, channel and lane, allocating freight, handling, deductions and returns to the order
• Classified deductions with document AI and routed disputes to owners with service levels
• Gave sales and finance the same customer profitability view, refreshed daily

Impact

• 100% of customers with a visible cost to serve
• −40% time to resolve deductions
• −6 days sales outstanding

The challenge

Spend sat in the ERP by cost center, plans in marketing’s files and sales in another system. Each review started by rebuilding the numbers, and over-spend was discovered after the budget was gone.

What we did

• One model of marketing spend, plan and sales by brand, activity and month, refreshed daily from the ERP
• A decision view for the finance controller and the business head: spend against plan next to sales against plan, by brand
• Alerts when a brand’s spend runs ahead of plan while its sales trail
• Monthly operational reviews run from the same view, with locked month-end numbers

Impact

• Daily visibility of spend against plan, instead of weeks after close
• 2 brands re-phased within the quarter, before the budget was exhausted
• 1 review where finance and marketing debated actions, not numbers

The challenge

Distributor sell-out data arrived in different formats and matched the company’s product and customer codes only partly. Leads, key accounts and distributor coverage were tracked in separate spreadsheets.

What we did

• Matched distributor sell-out to the company’s products and customers, raising coverage from half of sales to most of it
• A distributor Pareto and key-account view: who sells what, where, and where penetration is low
• New-lead and opportunity tracking tied to the CRM, so sales results are recognized automatically
• Sales incentives re-based on sell-out, with the same numbers visible to sales, finance and distributors

Impact

• 86% of sales now visible at the point of sale
• Quarter-end loading gone: shipments now track sell-out
• Top 3 distributors make 67% of sell-out and have dedicated plans

The challenge

Planners lacked early warning of demand shifts, inventory risk was hard to prioritize by business impact, and service failures were explained after the fact rather than prevented.

What we did

• Designed a target BI architecture as a decision pipeline—from source data to a unified semantic layer to role-based cockpits and workflow actions
• Built a capability model across Plan, Source, Make and Deliver, connected by a cross-functional control tower
• Defined a KPI framework with north-star outcomes, driver metrics, owners, thresholds and review cadence
• Prioritized demand sensing, inventory health and on-time-in-full use cases into a three-wave roadmap

Impact

• One KPI language for supply chain, with a named owner for every metric
• A sequenced roadmap from foundation to predictive, global rollout
• Use cases that target stock-outs, overstock and service reliability together

The challenge

Requests passed through six functions with no view of where they waited. Incomplete requests bounced back, urgent cases were handled by phone, and no one owned the end-to-end lead time.

What we did

• Mapped the process and measured queue and touch time at every step from the workflow data
• Simplified the request form and the approval sequence to one step per function
• Introduced first-in, first-out rules and a real-time Power BI monitor of every open request
• Set a service standard per step, with owners and a weekly review

Impact

• 55 → 18 days average lead time
• 144 → 21 days spread between the fastest and the slowest request
• 9 in 10 new products set up within 30 days

The challenge

Distributor stock, sell-out and return data lived with the planners, finance and sales separately. No one could see which distributors held too many weeks of stock before the product came back.

What we did

• One view of distributor stock in weeks, sell-out, expiry exposure and returns, by distributor and product
• A stock policy per distributor segment, with alerts when weeks of stock exceed the limit
• Distributor performance re-evaluated monthly on sell-out and returns, not just on sell-in
• Finance and supply planning review the same numbers before each order cycle

Impact

• 4.1% → 2.3% of sales returned from the market
• Under 6 weeks of stock at every major distributor
• Monthly distributor review on sell-out, with returns owned by name

The challenge

Planners balanced product mix, pallet positions and weight limits in spreadsheets. Each market did it differently, and nobody could see how full the network’s trucks really were.

What we did

• Load-building rules that optimize product mix against pallet, weight and volume limits for every lane
• A load utilization cockpit: fill rate by lane, plant and carrier, with the loads below standard flagged daily
• Optimized orders created automatically, with planners reviewing exceptions instead of building every load
• Weekly review of lanes below target with logistics and planning

Impact

• 78% → 91% average truck fill
• −14% trucks needed for the same volume
• Hours → minutes to build the day’s loads

The challenge

Descriptions had to fit each brand’s voice, be accurate to the recipe and pass review. Alt text was required for accessibility, and new recipes kept arriving every month.

What we did

• A generation pipeline that reads recipe metadata, tags and images and drafts descriptions in each brand’s voice
• Automated alt text for every image, checked against the recipe before publishing
• Editorial review in the content system: approve, edit or reject, with every change fed back to improve the drafts
• Production deployment that handles new recipes every month without manual work

Impact

• 3,200 recipe descriptions written in six weeks
• 100% of images with alt text
• 9 in 10 drafts approved by editors without changes

The challenge

Performance by business line, product and region was assembled in spreadsheets. Adjustments were hard to trace, and access to sensitive financial data was managed report by report.

What we did

• Brought balances, income, expenses and credit data together on a governed data platform
• Defined one certified set of measures for revenue, margin, efficiency and credit losses
• Automated reconciliation to the general ledger after every refresh
• Built executive scorecards with variance to plan and prior year, and information security by business line

Impact

• One reconciled set of numbers for management, finance and risk
• A faster, more predictable month-end
• Every adjustment traceable, with access governed by role

The challenge

Every KPI had its own card and its own colours. Comparisons to plan and prior year looked different on each page, so meetings were about the charts, not the business.

What we did

• One notation for actual, plan and prior year on every page, with signed variances and a message in every title
• Replaced 107 KPI cards with a compact matrix and small multiples, and rebuilt the data model for speed
• A design system: palette, typography, templates and a report checklist adopted by every team
• Coached analysts to write the message first, then choose the chart

Impact

• 40 → 6 pages and 90 → 4 seconds to open
• One definition and one look for every KPI
• Half the meeting time spent on what the numbers are

The challenge

Each asset team tracked wells, budgets and production its own way, so leadership could not compare performance across basins or see problems while there was still time to act.

What we did

• Integrated drilling, production and capital-spend data on a governed data platform
• Built well performance views that compare every new well with its expected production curve
• Delivered capital spend against approved budgets, well by well, refreshed daily
• Automated data validation, and field data capture with low-code apps

Impact

• Weekly operations reporting produced automatically
• Cost and schedule variances visible while wells are being drilled
• One view of performance across assets and basins

The challenge

Production, quality and maintenance data sat in separate systems at each site. Daily reviews debated the numbers instead of the causes, and improvement work could not be compared across plants.

What we did

• Agreed one definition of equipment effectiveness and losses across all plants
• Connected production, quality and maintenance data in Microsoft Fabric
• Gave operators a simple app to record each stop and its cause at the line
• Delivered plant and line scorecards, with automatic alerts for unplanned stops

Impact

• One performance language from the line to the leadership team
• Downtime captured at the source, by cause
• Improvement priorities set on facts, plant by plant

The challenge

Volume, price, mix, material and labor assumptions were not linked, so leaders could not see why the forecast moved or test a scenario before deciding.

What we did

• Built a driver-based model: volume, price and mix by product line, material and labor rates by plant, with actuals loaded from the ERP each month
• Rolling 12-month forecast refreshed monthly, with locked snapshots so every version is auditable
• Variance bridges from budget to forecast by driver, by plant and by product line
• Scenario inputs in a Power Apps form, approvals in Teams

Impact

• 4 months → 10 days forecast cycle
• Half the forecast error at a three-month horizon
• −60% finance time spent preparing data

The challenge

Leaders could not see where cash was stuck or which issues their teams could act on, and every department maintained its own version of the numbers.

What we did

• Built governed Power BI semantic models on the enterprise lakehouse for revenue, collections and receivables
• Codified business rules into the model, documented and owned by the business
• Built information security into the model, with access governed and audited person by person
• Automated refresh orchestration, timed to upstream warehouse loads

Impact

• One view of financial performance, from executive scorecard to transaction
• Zero line-level variance when detail was reconciled to source
• Access governed user by user, with audit-ready coverage reporting

The challenge

Names were spelled differently across systems, detailed reports were assembled by hand, and late adjustments could quietly change numbers that had already been reported.

What we did

• Resolved identities across systems using stable identifiers instead of names
• Delivered a personal scorecard with built-in information security, so each person sees only their own results
• Built a separate finance export, restricted to approved users and gated by a monthly lock
• Introduced locked month-end snapshots, refreshed automatically after close

Impact

• Self-service access to individual performance detail
• Locked, auditable month-end numbers—no silent restatements
• Exports controlled by role, in line with finance policy

The challenge

Attrition was only visible after people had left. Compensation reviews compared roles by hand, and sensitive data could not be shared beyond HR.

What we did

• One workforce model: headcount, hires, exits, vacancies, hours and compensation by site, role and tenure, refreshed weekly
• Attrition analysis by tenure, role and manager, with early-warning indicators
• Compensation positioning against bands, with information security so each leader sees only their own teams
• Workforce plan against budget by month, with scenarios for openings and overtime

Impact

• −5 pts first-year attrition
• −18 days time to fill
• Weekly view with role-based access replaces the quarterly deck

The challenge

Leaders saw results only after the month closed. Budgets were set monthly while operations ran weekly, and channel performance could not be tied to outcomes.

What we did

• Unified CRM, scheduling and operational data in the lakehouse and Power BI
• Built cohort-based conversion curves from first contact to completed treatment
• Delivered weekly forward-visibility reporting against budget, by market and channel
• Converted monthly budgets into weekly targets using working-day calendars

Impact

• A forward view of demand, weeks ahead
• Budget pacing by market and channel in one place
• Marketing channel performance tied to outcomes

The challenge

Spend by channel, leads in the CRM, appointments in the practice system and revenue in finance were reconciled once a quarter, in a spreadsheet.

What we did

• Joined spend, leads, consultations, scheduled and completed visits and revenue into one governed model, refreshed daily
• Pacing views of spend and leads against the monthly budget and target, by channel and market
• Cost per lead, cost per completed visit and return by channel, with a six-week lag between first contact and treatment
• A weekly briefing for marketing and operations leaders, with exceptions first

Impact

• Weekly return by channel instead of quarterly
• −22% cost per completed visit after reallocating spend
• ±3% budget pacing every month

The challenge

Quality and sourcing teams worked from static reports, and drawing-release notifications to suppliers moved through manual channels that introduced errors.

What we did

• Built control-chart trending, supply-management and supplier-quality dashboards
• Identified and implemented new KPIs for the supplier performance rating system
• Streamlined the drawing-release process by moving notifications into the supplier change-notification system

Impact

• A broader, data-driven supplier rating system
• Fewer defects in the drawing-release process
• Timely supplier-quality visibility for sourcing and quality teams