Real Work Scenarios
Each scenario starts with the business problem, defines the key and data grain, then connects the learning pattern to a real WorkTools utility.
Find Supplier Price Increases
You receive last month and this month price lists. Identify increases, decreases, new SKUs and removed SKUs.
Key: SKUOpen →ProcurementReconcile PO vs Invoice
An invoice may contain wrong quantities or unit prices. Compare PO lines to invoice lines and flag value differences.
Key: PO + ItemOpen →LogisticsFind Missing Deliveries
Orders exist, but deliveries may be partial or missing. Calculate open quantity per order line.
Key: Order + ItemOpen →InventoryFind Inventory Shortages
Compare on-hand stock with average daily usage and lead time.
Key: ItemOpen →InventoryPrioritize Inventory with ABC
Classify items by annual consumption value so attention follows financial impact.
Key: ItemOpen →InventoryCalculate Reorder Point
Estimate when replenishment should trigger based on demand and lead time.
Key: ItemOpen →ProductionExplode a Multi-Level BOM
A finished item contains subassemblies that contain components. Calculate total component requirements.
Key: Parent + ComponentOpen →ProductionAnalyze OEE Loss
A line misses target output. Separate availability, performance and quality losses.
Key: Line/ShiftOpen →ProductionEstimate Production Capacity
Determine whether machines and shifts can meet daily demand.
Key: LineOpen →ProductionCompare Takt Time and Cycle Time
Demand determines takt; actual process speed determines cycle time. Check if capacity is aligned.
Key: LineOpen →QualityTrack Yield and Scrap
Measure how much input becomes good output and where scrap is concentrated.
Key: Item/LineOpen →WarehouseFind Duplicate Handling Units
Each HU should be unique, but scans can be repeated or copied.
Key: HUOpen →WarehouseExpected vs Scanned HUs
A worklist expects HUs, while scanner logs record actual HUs. Find missing and wrong scans.
Key: PO + SM + HUOpen →Data QualityClean an ERP Export
ERP exports contain whitespace, mixed case and empty rows before analysis.
Key: Business keyOpen →ReportingCombine Weekly CSV Files
Weekly exports share columns and must become one dataset for analysis.
Key: Same schemaOpen →DataSplit a Large CSV
A downstream system cannot open or upload a very large CSV.
Key: RowsOpen →SQLGet Latest Status per PO
An event table contains many status rows per production order. Return only the latest row.
Key: POOpen →ProcurementPick Best Supplier Quote
Several suppliers quote the same items. Find the lowest valid quote per item.
Key: ItemOpen →