OEE and Operational Routine Management Dashboard

Productivity Indicator
OEE Indicator
Loss Indicator

Project Information

  • Category: Analytics / BI
  • Type: Operational Dashboard
  • Status: Completed
Technologies:
Looker Studio SQL GCP - BigQuery Google Sheets

OEE and Operational Routine Management Dashboard

This project features the development of a Business Intelligence solution aimed at the tactical and operational level, with the goal of increasing visibility over the efficiency of the manufacturing process (OEE) and supporting daily production management. The work encompasses the entire life cycle: from the ingestion of raw data from the production lines to the creation of real-time performance indicators, allowing for an agile response to process deviations and machine downtime. The tool acts as the core of routine management, transforming operational data into immediate action plans for the supervision team.

The implementation of this solution made it possible to identify performance bottlenecks faster and more accurately, resulting in a significant increase in operational availability and greater assertiveness in dealing with losses (Bulk, Overweight, and Packaging). The direct impact of this visibility was an average gain of 2,200 parts/day directed to production, optimizing resource usage and reducing the financial impact of monthly losses. The dashboard structure facilitates stratified analysis by machine and shift, ensuring that improvements are sustained by data rigor.

Key Highlights

  • Real-Time OEE Monitoring: Dynamic visualization of availability, performance, and quality indicators to support the tactical level.
  • Loss Stratification: Detailed analysis by category (Overweight, Bulk, and Packaging Material) to prioritize continuous improvement projects.
  • Resource Performance Ranking: Identification of the largest LGI (Loss Generation Index) offenders comparing different lines and machines.
  • Measurable Impact on Volume: Conversion of technical efficiency into real productive gain, adding 2,200 units/day to the line output.