Plant metrics live in separate spreadsheets, making the numbers hard to trust. [Adjust with the real case.]
POWER BI · CASE 03
Industrial Operations Dashboard
Availability, OEE, MTBF and MTTR over a star schema using synthetic plant data.
A star schema with Power Query, documented DAX measures and a dashboard designed for daily operations meetings.
[Which decision it enables and how much time it saves.]
Plant performance · last 12 weekspreview · synthetic data · Power BI embed goes here
dashboard-operaciones/
├─ data/sinteticos/
├─ powerbi/
│ └─ operaciones.pbix
├─ dax/
│ └─ medidas.md
└─ docs/capturas/
OEE =
VAR Disp = DIVIDE([Tiempo Operativo], [Tiempo Planificado])
VAR Rend = DIVIDE([Producción Real], [Producción Teórica])
VAR Cal = DIVIDE([Unidades Buenas], [Producción Real])
RETURN Disp * Rend * Cal