Skip to main content
Supply Chain · OTIF · DIFOT · Control Tower

The picture your S&OP meeting
is currently arguing about.

Six-quadrant supply chain dashboard. OTIF, DIFOT, fill rate, in-transit visibility, supplier OTIF, freight cost. Lead and lag together. Built on Microsoft Fabric. The S&OP meeting opens this, not six different exports.

Trusted by manufacturing, FMCG, packaging and logistics operations across India, the GCC, Singapore, the UK and North America.

50+

Clients delivered

150+

Projects

14+

Years in industrial data

5

Markets

Who this is for

The supply-chain dashboard built around your role

One control view for the people who own the customer commitment — the dashboard each leader opens, mapped to the decision they carry.

Supply Chain Director

The problem

OTIF, fill rate and days of cover live across the ERP, the WMS and a planner’s spreadsheet — so the exception only surfaces after the customer has already chased it.

What we build

One supply-chain dashboard — OTIF, fill rate, cover and cost-to-serve — on a governed Microsoft Fabric model over ERP, WMS and TMS, with early exception alerts wired to the person who can act.

One control view instead of three systems and a spreadsheet

Demand / Supply Planner

The problem

You reconcile the demand signal, on-hand position and supplier commitments by hand every week, and the number is a day old before the S&OP meeting even starts.

What we build

Demand, inventory and inbound supply in one view on Direct Lake, refreshed as data lands — so planning works off the live position, not last week’s export.

20–40% stockout reduction (Hollandia Dairy)

Logistics Manager

The problem

Once goods leave the dock you lose sight of them, and an ETA slip only shows up when a customer calls asking where their order is.

What we build

In-transit visibility and carrier ETA on the same dashboard as OTIF and fill rate — WMS and TMS feeds joined to the Fabric model, exceptions flagged before the customer notices.

Exceptions surface before the customer chases

COO

The problem

Every function reports its own version of service — operations, planning and customer service each on a different number for the same week.

What we build

A single governed supply-chain model where OTIF, fill rate, cover and cost-to-serve are each defined once and read the same way across the business.

A single source of truth across operations, planning and finance

The Problem

Patterns we see in every engagement

S&OP arguments are usually data arguments. Planning, warehouse, customer service and finance each look at a different number for the same week. The dashboard ends that argument — six quadrants, one truth.

01

Planning, warehouse and customer service each on a different number.

Planning uses an Excel pull from SAP. Warehouse uses the WMS. Customer service uses the CRM. All three are correct at different timestamps. The S&OP meeting argues for 30 minutes before getting to the actual decision.

02

Alerts that page the whole DL instead of the right person.

When OTIF drops below threshold, the email goes to a distribution list of 14. Nobody owns it. Nothing happens until the next weekly meeting. We wire alerts to the named person who can act, with escalation rules that fire only on real outliers.

03

S&OP cadence is monthly. The data needs to be weekly.

Demand is moving. Supplier reliability is moving. The monthly cycle does not match the disruption rhythm. The dashboard becomes the venue for the new weekly cadence, not a replacement for the monthly review.

04

In-transit visibility ends at the dispatch dock.

Once goods leave your DC, you stop seeing them until they arrive. Customer chases happen blind. We integrate carrier EDI 214 messages and visibility providers (Project44, FourKites, GoComet) so ETA accuracy becomes a KPI.

What we build

What we build

Six quadrants on one screen. Each tile drills to the transaction so the meeting does not pause for a query.

01

Demand signal — POS-out, sell-out, order intake

Replaces

The Tuesday Excel from Sales showing last week's orders with no context for what is happening at distributor or shelf level.

  • POS-out feeds from key customers (where shared), distributor sell-out, internal order intake
  • Forecast vs actual with rolling 13-week and 52-week comparison
  • New-promo lift visible against baseline — promo effectiveness becomes a measured metric
  • Customer-level demand pattern shifts surface week 2 of the change, not month 3

Demand signal arrives weekly with named pattern shifts. Planning stops working blind.

02

Inventory position — DIO, fill rate, on-hand vs perpetual

Replaces

The 'we are mostly fine on inventory' line that hides A-class stockouts in the aggregate.

  • DIO per SKU class per location — A-class lean, C-class loose, D-class flagged
  • Fill rate order-line and case fill — customer scorecard reconciliation
  • Cycle-count variance flagged at SKU level
  • Drill from aggregate to specific SKU and lot

Inventory conversations get specific. Working capital decisions get evidence.

03

Production status — OEE, plan vs actual, quality holds

Replaces

The end-of-week production report that arrives Monday and reports last Wednesday's lines.

  • OEE refreshed live from PLC — see oee-dashboard for detail
  • Plan vs actual per line per shift — predictive trajectory to end-of-day
  • Quality hold count and value held — visible to supply chain, not just quality
  • Scrap rate trend so material variance and quality variance separate cleanly

Production data is current. Supply chain plans against real output, not last week's narrative.

04

Order fulfilment — OTIF, DIFOT, perfect-order rate

Replaces

The OTIF that is computed differently across plants and the DIFOT that customer scorecards measure but your team does not track.

  • OTIF measured from dispatch promise vs delivery confirmation — your number
  • DIFOT measured from customer PO date vs goods receipt — the customer's number
  • Perfect-order rate composite: DIFOT × invoice accuracy × damage-free
  • Reconciliation to customer scorecards (Lulu, Carrefour, Coles, Woolworths)

Customer-side metrics surface inside the same dashboard. Chargeback disputes get evidence.

05

Inbound supply — supplier OTIF (SIFOT), in-transit ETA accuracy

Replaces

The blind spot between PO confirmation and dock arrival where 'where is my container' lives in a WhatsApp group.

  • Supplier OTIF (SIFOT) per supplier per category — predicts your DIFOT 2–4 weeks ahead
  • EDI 214 carrier message integration for live in-transit ETA
  • Visibility provider integration (Project44, FourKites, GoComet) where used
  • Exception alert when supplier OTIF drops or ETA slides beyond threshold

Inbound supply pattern is visible at the same cadence as outbound. Supplier conversations get a metric.

06

Cost and cash — freight $/unit, inventory write-off pipeline

Replaces

The freight cost line on the P&L that finance sees once a month and supply chain never sees in detail.

  • Freight cost per unit / per pallet / per container — by lane, by carrier
  • Warehouse cost per touch — pick-and-pack labour as proportion of throughput
  • Inventory write-off pipeline — what is at risk in next 30 / 60 / 90 days
  • Days-on-hand cash — working capital tied up in inventory at SKU class level

CFO and supply chain see the same numbers. Cost conversations stop happening month-end-only.

Business outcomes

What changes once the control tower is live

Figures are from delivered MDI engagements, tagged to their source; capability outcomes apply to every governed supply-chain build.

20–40%

Stockout reduction

Hollandia Dairy

+15–25%

Forecast accuracy improvement

Governed demand model

40–60%

Fewer ad-hoc report requests

Copilot on a governed model

6 weeks

To first live dashboard

MDI standard cadence

OTIF, fill rate and cover in one governed view — defined once, read the same everywhere

In-transit ETA on Direct Lake — no refresh window to break

Early exception alerts to the person who can act, not a distribution list

Cost-to-serve visible to supply chain and finance on the same numbers

How we work

From data map to live control tower in 6 weeks

We map the S&OP cadence first. The dashboard supports the meeting — it does not replace it. Without that anchor the dashboard becomes wallpaper.

01

Discover — map S&OP cadence and data sources

Two weeks. Map your S&OP cadence and decision rights. Map the data sources for each quadrant. Score data quality per quadrant. Define alert thresholds with operations and customer service.

02

Prototype — six-quadrant view for one region

Two weeks. Build the six-quadrant executive view for one region or business unit. Parallel-run against the current reporting set for 2 weeks. S&OP meeting opens this. Old reports go on archive.

03

Deploy — all regions, named alerts, named owners

Four to six weeks. Roll out across regions. Wire alerts to named owners with escalation paths. Train each persona — planner, warehouse, customer service, supply chain leadership — on their scoped view.

Technology stack

Lakehouse

Microsoft FabricOneLakeDirect LakeReal-Time Analytics

Visualisation

Power BI Direct LakePower BI MobileEmbedded Power BIPaginated Reports

Automation

Power Automate alertsTeams notificationsEmail escalationSLA timers

ERP

SAP S/4HANASAP ByDesignMicrosoft Dynamics 365NetSuite

Transport & Visibility

EDI 214 carrier feedsProject44FourKitesGoCometCarrier APIs (Maersk, MSC, CMA CGM)

Operational

WMSTMSCRM order bookCustomer EDI 850/855/856

Why MyData Insights

Why choose MDI for your supply-chain dashboard

01

Microsoft Fabric & Power BI specialists

We build only on the Microsoft stack — Fabric, Power BI, Power Platform, Azure. Your IT team supports what we deliver, with no niche-vendor lock-in.

02

Operations-first, not generic BI

We build for OTIF, fill rate, DIFOT and cost-to-serve — supply-chain metrics defined the way your S&OP meeting uses them, not generic dashboards adapted after the fact.

03

Direct Lake for live data

OTIF and in-transit ETA read live Delta tables in OneLake on Direct Lake — no overnight refresh to time out before the morning review.

04

Exceptions to a named owner

Alerts fire to the person who can act, with escalation rules that trigger on real outliers — not a distribution list of fourteen.

05

Governance-first

One governed semantic model over ERP, WMS and TMS, row-level security at the model layer — so the number stays trusted long after go-live.

06

First value in six weeks

A working supply-chain dashboard for one region live in six weeks on a fixed scope — not a 50-slide roadmap to review.

Common questions

What buyers ask us

We already have a TMS / WMS dashboard. Why this?

Most TMS/WMS dashboards are operational — they answer 'what is the warehouse doing right now'. The supply chain dashboard is decisional — it answers 'are we going to miss the customer commitment'. Different question, different audience, different shape.

Can we integrate it with SAP Analytics Cloud / SAP BW?

Yes. We have moved several clients off SAC for operational analytics — Fabric is faster and cheaper at this shape. SAC stays useful for SAP-internal statutory reporting. See blog/sap-analytics-cloud-alternative-mid-market.

How do we measure if it is working?

Adoption and decision time. The dashboard is working if the S&OP meeting goes from 90 minutes to 45 and the decisions made get logged. We instrument both on day one.

What about Snowflake / Databricks?

We ship on both when the client estate requires. For most mid-market industrials on Microsoft 365 + Azure, Fabric is the right answer. For heavy data-science workloads or multi-cloud, Databricks may fit. We assess in Discover.

How much does it cost?

We work in fixed-scope, fixed-fee phases — Discover, Prototype, Deploy — never open-ended time and materials. The fee is quoted precisely after Discover, once we have seen your geography, source count and carrier integration scope, because those are what actually move the number. What we commit to upfront is the timeline: first working output in 6 weeks, not a 50-slide roadmap. Book 30 minutes with Amit and you will leave with the shape of the engagement.

Engagement

Free Supply Chain Dashboard Review

Thirty minutes with Amit on your actual supply chain — where OTIF, fill rate and cover live today, where exceptions surface too late, and what one governed control view would change. No slides, no obligation.

What you get

  • The KPIs you track today — OTIF, fill rate, cover — and which system each one actually lives in
  • Where exceptions surface too late, and who should be alerted instead
  • An ERP, WMS and TMS data-readiness check for a governed Fabric model
  • A 6-week roadmap to your first live supply-chain dashboard

Ready to move

Book a 30-minute Supply Chain diagnostic

30 minutes with Amit. No slides. No pitch deck. No obligation to proceed. We walk through your current S&OP cadence and the six quadrants — and where the gap is biggest.