A resource library for supply chain analytics teams.

Tools, references, and frameworks built by practitioners. Free to use. Shaped by years of hands-on enterprise supply chain work.

Explore the librarySee the reference builds

For supply chain and operations leaders: how the practice works

Explore by business problem

Metric definitions and reference builds — working dashboards over simulated data — organized by the question they answer.

Browse by system

Inventory & Working Capital

What you're holding, why it's there, and what it costs to hold it.

Reference build

Inventory Health & Working Capital

On-hand units · 365 days

All 8 in Inventory & Working Capital

Demand Planning & Forecasting

How wrong the forecast is, in which direction, and where the error is worth fixing.

Reference build

Demand Forecast Accuracy

Forecast vs. actual units · 28 months

All 5 in Demand Planning & Forecasting

Customer Service & Fulfillment

Whether the order arrived complete, on the date you committed to.

Reference build

Service & Delivery Performance

OTIF by customer against its order lines · 24 customers

All 10 in Customer Service & Fulfillment

Procurement & Supply

What's on order, when it lands, and how the supplier actually performs.

Reference build

Supplier Scorecard

The 6 widest re-promise gaps · 22 suppliers

All 3 in Procurement & Supply

Manufacturing & Production

Whether the plant built what the plan said it would build.

Reference build

Production Schedule Performance

Mix vs. volume attainment · 52 weeks

All 5 in Manufacturing & Production

Data Foundation & Governance

Landing ERP data in a lakehouse without losing deletes, history, or control of who reads it.

Reference build

Data Readiness

13 evidence conditions × 3 observed runs

All 6 in Data Foundation & Governance

Reference builds frozen on 2026-09-07.

All 14 reference builds

Start from the system you run

The same library, entered by source system — written for whoever has to query it. All of it free and ungated.

Every reference: tables · a quirks guide · an extraction guide — plus t-codes, programs or data entities where the system has them

One index — tables, KPIs, t-codes and guides. Try , , , or .

SAP

Flagship

159 tables · 92 t-codes · 11 modules

SAP EWM

68 tables · 25 t-codes · 9 modules

JD Edwards

94 tables · 92 programs · 18 modules

Dynamics 365 F&O

63 tables · 26 data entities · 10 modules

Infor M3

33 tables · 36 programs · 9 modules

Oracle EBS

104 tables · 12 modules

Oracle Fusion

85 tables · 11 modules

NetSuite

70 tables · 11 modules

From the F4211 entry in the JD Edwards reference — the Julian date decode and implied-decimal scaling, exactly as the reference generates it.

3 parameters not filled: <catalog>, <schema_data>, <KCOO>

-- F4211 sales order lines, quirks handled
SELECT
  d.SDDOCO AS order_number,
  d.SDLITM AS item_number,
  CASE WHEN d.SDTRDJ IS NULL OR d.SDTRDJ = 0 THEN NULL
       ELSE DATE_ADD(MAKE_DATE(1900 + CAST(d.SDTRDJ AS INT) DIV 1000, 1, 1),
                     CAST(d.SDTRDJ AS INT) % 1000 - 1)
  END AS order_date,  -- CYYDDD Julian → DATE
  d.SDUORG AS qty_ordered,
  d.SDUPRC / POWER(10, 4) AS unit_price,  -- 4 implied decimals
  d.SDAEXP / POWER(10, 2) AS extended_price
FROM <catalog>.<schema_data>.f4211 d
WHERE d.SDKCOO = '<KCOO>'

References re-verified weekly; latest 2026-10-06.

Browse the full library

Shaped by real work

Analytics investments stick when the people building them understand the supply chain, not just the tools.

Nothing here started as content. Every reference in the library was written from years of hands-on work inside enterprise supply chains — the kind where exactly that gap was the problem, and closing it meant learning both the business and the data.

The practice takes consulting selectively and stays engaged through implementation, which is why the references read like working notes rather than vendor collateral.

How the practice works
Scope
demand planning, inventory, procurement, fulfillment, production
Platform
Databricks — Unity Catalog, Delta Lake, AI/BI dashboards
Method
Medallion layers into Kimball star schemas (the shape BI tools and Genie read correctly)
Engagement
A short intro call first; a scoped proposal only if it fits

Working on a supply chain analytics challenge?

Every inquiry is read and answered — tell us what you’re working on.

A short intro call first; a scoped proposal only if it fits.

Start a conversation