#analytics

Tagged posts

3 posts tagged with "analytics".

April 20, 2026

~6 min read

Closed-Loop Manufacturing: Cross-Linking AOI and SMT Machine Telemetry

An optical defect and the machine event that caused it happen minutes apart and live in separate databases. Time-windowing SQL joins close the loop — here is how.

sqlmanufacturinganalyticsaoismtdata-engineering

April 13, 2026

~7 min read

·engineering

The SQL Window Function That Saved Our Defect Attribution

SMT machines log generic errors milliseconds before they log the component that caused them. A forward-fill CTE using SQL window functions bridges that gap — here is exactly how it works.

sqlsqlitewindow-functionsmanufacturingdata-engineeringanalytics

April 6, 2026

~7 min read

·engineering

From Raw Machine Logs to Predictive Maintenance: Time-Series Analytics in SMT

Raw machine telemetry tells you what happened. Time-series analytics tells you what is about to happen. Here is how First-Pass Yield, rolling defect rates, and SQL-driven root cause analysis work together.

pythonsqltime-seriesanalyticsmanufacturingpredictive-maintenance