Business Intelligence
Manufacturing
Executive Dashboard for a European Manufacturer
-
Challenge
-
C-suite had no unified view of production KPIs across six European manufacturing plants.
-
Solution
-
Designed a live Power BI dashboard pulling from four ERP systems across all six sites. Our approach: mapped KPI definitions across four disconnected ERP systems to find a common standard; built standardised data pipelines feeding a single reporting warehouse; designed a live Power BI dashboard with drill-down by plant, production line and shift. Tools: Power BI, SQL Server, Azure Data Factory, DAX.
-
Result
-
Board reporting time reduced from 3 days to under 2 hours per week.