Factory Data Analytics Flashcards

Which data aggregation method is most appropriate for calculating the average cycle time across multiple production shifts?

Answer: Apply a weighted average based on units produced per shift

A weighted average accounts for varying production volumes per shift, giving a more accurate overall cycle time.

In factory analytics, what does the term 'data historian' refer to?

Answer: A software system that stores time-series industrial data

A data historian is specialized software that captures and stores time-stamped process data from industrial equipment.

A control chart shows seven consecutive data points all above the center line. This pattern indicates:

Answer: A potential process shift requiring investigation

Seven consecutive points on one side of the centerline is a Western Electric run rule signal indicating a non-random process shift.

What is the primary purpose of data normalization in factory analytics pipelines?

Answer: To scale features to a common range for fair model comparison

Normalization scales input features to a consistent range so that no single variable dominates model training due to magnitude differences.

Which SQL window function would you use to calculate a 5-minute rolling average of machine temperature readings?

Answer: AVG() OVER (PARTITION BY ... ORDER BY ... ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)

The ROWS BETWEEN clause in a window function defines the rolling frame over which the average is computed.

A manufacturer notices that defect rates spike every Monday morning. This is an example of what type of data pattern?

Answer: Seasonality or cyclical pattern

A repeating pattern tied to a calendar cycle (weekly in this case) is classified as seasonality or a cyclical pattern.

In the context of SACA factory analytics, what does SCADA stand for?

Answer: Supervisory Control and Data Acquisition

SCADA stands for Supervisory Control and Data Acquisition, a system used to monitor and control industrial processes.