This solution is designed to help production managers, supervisors, and process engineers gain instant insight into manufacturing performance data collected through the HiveMind platform. Using natural language queries, users can quickly access key production indicators, machine utilization metrics, energy consumption data, scrap analysis, and downtime information without manually searching through reports.

The assistant interprets production data and provides clear, actionable answers based on machine performance, shift activity, product information, and operational events. By transforming complex manufacturing datasets into simple conversations, it enables faster decision-making and improved production efficiency.

The system allows users to analyze and monitor:

• Overall Equipment Effectiveness (OEE)
• Machine utilization and idle time
• Energy consumption per produced part
• Scrap and quality metrics
• Downtime reasons and event tracking
• Production performance by machine, product, operation, or shift
• Historical trends across days, months, and years

Understanding Production KPIs

The assistant provides access to several important manufacturing indicators:

OEE (Overall Equipment Effectiveness)
A combined measure of machine performance calculated from Availability, Performance, and Quality (A × P × Q). OEE helps identify how effectively production equipment is being utilized.

Idle Time
The total number of seconds a machine remained stopped during a selected shift or time period.

Utilization
Represents the percentage of time a machine was actively used during a shift.

Energy per Part
Calculated using EFFECTIVE_ENERGY and TOTAL_ENERGY values and expressed in Wh per produced part, helping identify opportunities for energy optimization.

Scrap Analysis
PREV_GOOD_QTY represents good parts produced, while PREV_SCRAP_QTY indicates rejected or defective parts.

Downtime Reasons
EVENT_CODE and EVENT_NAME describe the type of production event, while EVENT_ID links multiple event slices belonging to the same downtime occurrence.

Machine Identification
RESO_CODE and RESO_NAME represent the machine code and machine name.

Shift Categories

• SHIFT_1 – Morning Shift
• SHIFT_2 – Afternoon Shift
• SHIFT_3 – Night Shift

Product Information
ITEM_CODE and ITEM_NAME identify the product code and product description.

Operation Information
OPER_CODE and OPER_NAME identify the production operation code and operation name.