How to Calculate OEE Using Power BI

OEE (Overall Equipment Effectiveness) is one of the most important indicators in industrial engineering. It measures the real efficiency of a production process by evaluating three key factors: Availability, Performance, and Quality.

While many companies calculate OEE manually or using spreadsheets, Power BI provides a powerful platform to automate the calculation, visualize trends, and make data-driven decisions in real time.

1. What Is OEE and Why Does It Matter?

OEE answers a fundamental question: How effectively is the company using its installed capacity?

• Availability: Actual operating time vs. scheduled time.
• Performance: Actual speed vs. ideal speed.
• Quality: Good pieces vs. total pieces produced.

An OEE of 85% is considered world-class. Most plants operate between 45% and 65%, which means there is enormous room for improvement.

2. Official OEE Formulas

Availability = Operating Time / Scheduled Time
Performance = (Actual Production × Ideal Cycle Time) / Operating Time
Quality = Good Pieces / Total Pieces
OEE = Availability × Performance × Quality
        

3. Recommended Data Structure for Power BI

To calculate OEE correctly in Power BI, it is recommended to structure the data into three main tables:

• Production: good pieces, scrap, cycle times.
• Downtime: duration, type of stop, root cause.
• Calendar: shifts, days, weeks, months.

4. SVG Diagram: OEE Calculation Flow

5. Calculating OEE in Power BI Using DAX

5.1 Availability Measure

Availability = DIVIDE([Operating Time], [Scheduled Time])
        

5.2 Performance Measure

Performance = DIVIDE([Actual Production] * [Ideal Cycle Time], [Operating Time])
        

5.3 Quality Measure

Quality = DIVIDE([Good Pieces], [Total Pieces])
        

5.4 Final OEE Measure

OEE = [Availability] * [Performance] * [Quality]
        

6. Recommended Visualizations in Power BI

• Gauge indicators for each OEE component.
• Bar charts for downtime by cause.
• Time series for OEE trends.
• Pareto charts for scrap analysis.
• Heatmaps by shift or machine.

Conclusion

Power BI transforms OEE calculation into an automated, visual, and strategic process. By integrating production, downtime, and quality data, companies can identify improvement opportunities, reduce losses, and increase overall operational efficiency.

At Roadvisors, we have implemented OEE dashboards across multiple industries, achieving significant improvements in productivity and decision-making.