The challenge
What was getting in the way
Cross-source joins, ambiguous filter paths, and bidirectional relationship conflicts made the Power BI model unreliable across production lines.
Food Manufacturing
Production Compatibility Analytics
Arla — Riyadh Dairy Facility
A repaired composite model and DAX layer that made cross-source production compatibility usable across L7, L8, L9, SIG, and HASSIA.
Power BIDAXTREATASComposite ModelsManufacturing
The solution
What was built
The model logic was rebuilt with TREATAS-based DAX workarounds, conflicting filter paths were resolved, and an interactive compatibility matrix was delivered.
- Composite model diagnostics across multiple sources
- TREATAS-based DAX for cross-source logic
- Resolution of ambiguous and bidirectional filter paths
- Interactive production compatibility matrix
- Coverage across L7, L8, L9, SIG, and HASSIA
5 linesCovered in one matrix
StableCross-source model logic
InteractiveCompatibility analysis
System flow
How the pieces connect
A simplified architecture view. Production details vary by environment, identity model, data policy, and operating constraints.
Source
Multiple production datasetsComposite model→
Diagnose
RelationshipsConflict analysis→
Resolve
DAX + TREATASCross-source logic→
Model
Compatibility rulesReliable measures→
Explore
Power BI matrixFive production linesRelated work
More systems in the same problem family
Start with one workflow
Bring me the process that is slow, manual, or difficult to scale.
In 20 minutes, we can map the bottleneck, identify what is worth automating, and decide whether a proof of value makes sense. No pitch deck required.
Book a complimentary workflow audit →
Can’t find a suitable time on the calendar? Message me on WhatsApp and I’ll do my best to arrange a time that works.
In Riyadh during LEAP 2026 · Remote worldwide · On-site by arrangement