Manufacturing Downtime Analytics

this project focused on analyzing machine downtime and turning it from a clear loss into actionable insights that help management increase productivity and reduce waste.

We worked on:

✔ Data Cleaning & Transformation

✔ Building a complete Data Model

✔ Creating DAX Measures

✔ Designing 4 professional Power BI Dashboards

✔ Analyzing downtime by reason, category, machine, and shift

✔ Calculating KPIs like:

Total Downtime

Availability %

OEE

MTTR / MTBF

Production vs Target

The dashboards provide a clear view for decision-makers:

"Where is the factory losing time? And how can we turn that into profit?"