Narrow the month to one priority-review order

Compare revenue with training profitability assumptions and choose the first order to inspect.

Question for this chapter

Which order behind January 2017 revenue should be reviewed first?

Why this matters now

A revenue total does not determine an action. Order count, revenue share, discount, and margin must be read together to distinguish broad growth from a transaction whose commercial terms need review.

Try it

Run these three pipelines, then open the dataset with the matching name:

Monthly Sales Summary Pipeline
Customer Sales Summary Pipeline
High-value Low-margin Order Review Pipeline

Monthly Information dataset comparing order count, net revenue, discount, and margin — January revenue is about USD 9.11 million, while the training-assumption margin is 11.35%.

Customer summary dataset showing the order context for each customer — Dynamic Industries has only two orders.

The High-value Low-margin Order Review Pipeline applies this Workshop rule:

Net revenue is at least USD 1,000,000.
The training-assumption margin is below 20%.
The order contributes at least 50% of revenue for its month.

Pipeline calculating priority-review rules per order from the sales master — Calculate all three criteria at the order level.

After the run, open Priority Order Review → Data.

Priority Order Review dataset with order 18622, its customer, and material type in the first row — The first row is Dynamic Industries order 18622 for material type ZSER.

Scroll right to inspect the discount, margin, monthly revenue share, and review decision.

First row showing discount 0.18, margin 0.1, monthly revenue share 0.9321, and PRIORITY_REVIEW — Only this first row satisfies all three criteria and receives PRIORITY_REVIEW.

Success looks like this

Evidence	Visible value	Interpretation
Month	67 January 2017 orders, USD 9,118,915.6 net revenue, 11.35% margin	High revenue and a low assumed margin occur together.
Customer	Dynamic Industries, 2 orders, USD 8,670,000 net revenue	A few orders dominate the monthly result.
Order	18622, USD 8,500,000 net revenue, 93.21% of January	This order drives the revenue spike.
Terms	18% discount, 10% margin, `PRIORITY_REVIEW`	Review the commercial terms first.

Interpret the result

Do not describe January 2017 as broad demand growth. Order 18622 contributes 93.21% of the month's revenue and has a 10% training-assumption margin. The Workshop decision is to verify the discount, cost, and currency terms of the Dynamic Industries ZSER contract first.

Next decision

Next, verify that the selected order leads to the same customer, line, material, and date in the relationship graph.