Food and beverage data, finally turning into delivered orders.
For multi-site food and beverage operations under retail-private-label pressure. We turn ERP, MES, historian and demand-planning data into one Medallion foundation, and a Power BI layer your planner, plant manager and operations director actually use to defend OTIF.
See OEE, OTIF and line status as it happens, instead of compiling spreadsheets after the shift.
Spot drift and at-risk orders before they slip, and act with the right reason code the first time.
Machine, ERP and quality data on one Medallion foundation that every team reports from.
How we work in your food and beverage operation.
Four steps from your existing stack to a working planning and operations layer. You decide which steps we do, and which stay with your team.
Connect across your ERP, MES, WMS and demand planning tools
We integrate with your ERP (SAP, Dynamics 365, Exact, Infor), MES, WMS, historian (PI, AVEVA) and demand planning tool (SAP IBP, o9 or in-house). Vendor-neutral. We don't replace what works.
Build the data layer around SKU, recipe and site
Medallion architecture on Azure with SKU, recipe, allergen, customer site and retail customer as first-class dimensions. Hosted in our tenant or yours, depending on data-residency and traceability requirements.
Build the reports each role actually uses
Power BI per role. Demand planner sees forecast accuracy and OTIF risk. Plant manager sees OEE per line with capacity overlay. Ops director sees OTIF, labour and forecast in one consolidated view.
Turn historic patterns into validated proposals
Reason codes derived from your historic demand and production patterns. The Activate layer proposes forecast adjustments, capacity reallocation and sparepart orders. Your planner, plant manager or maintenance lead validates before action.
Full technical breakdown of every building block on what we build →
Three modules. Food-and-beverage defaults.
Same Medallion foundation as the rest of our work. Different defaults out of the box, because food operations are not generic manufacturing.
OTIF, forecast accuracy and delivery performance in one view, sliced per retail customer, per SKU, per site. The Activate layer proposes forecast adjustments with reason codes derived from your historic patterns. Your demand planner validates.
Discover Planning & Delivery →Real-time OEE per production line, downtime causes and changeover times. With capacity utilisation and labour hours overlaid, so the production picture matches the planning picture. The Activate layer proposes root causes; your planner validates.
Discover Production Performance →Quality, defects, MTBF and MTTR with allergen-changeover and cleaning schedules built into maintenance views. The Activate layer proposes maintenance actions and sparepart orders with reasoning; your maintenance manager validates.
Discover Quality & Maintenance →Published case: Van Loon Group.
A food producer we work with, combining machine data and ERP into one operational foundation.
Company snapshot
- Sector
- Food production
- Footprint
- Multiple food production sites
- What we connected
- PatchOEE machine data and Reflex ERP at production-order and line level
- What it powers
- Shop-floor screens and Power BI reporting across locations
What we built together
Van Loon Group runs multiple food production sites where production, planning and dispatch have to align closely every day. StriData linked PatchOEE machine data and Reflex ERP at production-order and line level, creating one reliable foundation for shop-floor screens and Power BI reporting across locations.
Questions food and beverage manufacturers ask us.
How do you handle our SAP, Dynamics 365 or Exact landscape?
We integrate with what you have rather than replacing it. We have working patterns for SAP (ECC and S/4HANA), Dynamics 365 Finance and Operations, Exact Globe and Online, and Infor. We pull the data we need into the Medallion foundation and leave your ERP untouched. We are not an ERP project.
Can your planning layer extend our SAP IBP, o9 or in-house forecast tool?
Yes. We sit alongside, not in place of. We pull demand signals, forecast outputs and actuals from your planning tool, and build the reporting and Activate layer on top. Reason-coded forecast adjustments flow back into your tool if you want them to, or stay as recommendations for your demand planner.
What do you do with HACCP, FSSC 22000 and traceability data?
We make it visible alongside production data, so quality and operations see the same picture. We don't replace your food safety management system, and we don't claim to automate compliance. Traceability data becomes a dimension in the data model so it can be correlated with line performance, allergen changeover and customer complaints.
Does this work for multi-site with different ERP instances and different MES versions?
Yes. We see this all the time. The Medallion foundation absorbs site-level differences in the Bronze and Silver layers, and exposes consistent definitions in Gold. You don't need to harmonise ERPs across sites first. We start with one site, validate the approach, and replicate the pattern across the rest.
Can you work alongside our internal BI team?
Yes. We frequently work as a specialist layer next to an internal team. We bring the Medallion methodology, the Activate layer and the food-and-beverage delivery patterns. Your team keeps ownership of the parts they already do well. We are explicit about which work stays with us and which transfers back.