How a unified Power BI scorecard with Anomaly Detection and Copilot summaries gave operations leadership a single live view of the entire business — replacing weekly stale reports with real-time insight.
Operations data was scattered across four separate systems — MES for production, QMS for quality, ERP for shipping, and HRIS for staffing. Leadership relied on outdated weekly reports, so problems were often discovered days after they occurred, delaying corrective action.
Built Azure Data Factory pipelines to pull data from all four systems every 15 minutes and load it into a central SQL Server operational data store with a unified KPI model.
Designed a clean Power BI scorecard using traffic-light indicators for key metrics (OEE, First-Pass Yield, On-Time Shipment, Headcount vs Plan) with full drill-through capability.
Enabled Power BI’s built-in Anomaly Detection visual on all time-series KPIs. The system automatically flags statistically significant deviations and surfaces likely root causes.
Configured Smart Narratives and Copilot in Power BI to generate plain-English explanations of every metric’s status, trend, and comparison to prior periods — updating live with each refresh.
Power Automate sends a Copilot-generated operations briefing to leadership via Microsoft Teams every morning at 7am, highlighting overnight performance and any detected anomalies.