
Spare Parts Supply Chain Analytics
Built in-house for a bus manufacturer's spare-parts business. Azure Data Factory pulls six feeds from SAP ERP and on-premises SQL Server every night, loads a star schema in Azure SQL and refreshes a Power BI report on critical stock, fill rate, stock turnover and supplier delivery performance. Rebuilt here on synthetic data.
- 6Feeds from SAP ERP and SQL Server
- 05:00Daily ADF load and Power BI refresh
- 9Star-schema tables with MERGE loads



