204 regression analysis, and evaluating the causes of unproductive time. 7.1. Data Sources Two databases were used: 7.1.1 Production Database Contains records of drilled meters per shift including date, shift, equipment, and drilled meters. Figure 1 – Production Database Sample 7.1.2 Operational States Database Contains records of equipment status and delay events including status type, delay cause, date, shift, and duration (seconds). Figure 2 – Operational States Database Sample 7.2. Data Processing and KPI Calculation Both databases were imported into Power BI. Only production-related records were considered for analysis. Mechanical availability and utilization were calculated using operational status times, and a consolidated summary table was created including: ● Date ● Shift ● Equipment
RkJQdWJsaXNoZXIy MTM0Mzk2