1
Data model
Star schema from SynQ exports: Site, Week, PickLog, RobotTelemetry, ServiceTicket. Relationships, grain, and why bins-per-week is not additive.
→ Powers the site breakdown
2
DAX measures
Lines per Hour = DIVIDE([Lines Picked],[Productive Hours]), time-intelligence for “vs prior period”, weighted grid utilisation, and a target-attainment measure with variance colouring.
→ Powers the KPI row
3
This board
Assemble the page: slicers wired to every visual, the throughput trend, a custom AutoStore grid visual (SVG / Deneb), bookmarks for the Monday ops review.
→ Powers the trend & grid