Master data quality reporting at Accelleron relied on a largely manual refresh process based on SAP ECC list exports, Excel transformations, and manual Power BI updates. The process was time-consuming, error-prone, and dependent on individual availability. Increasing reporting frequency and ensuring consistent data quality was difficult due to system constraints, limited automation options, and strict IT governance within the existing SAP landscape.

The project followed a Design Science Research approach. An automated reporting pipeline was designed and implemented iteratively, starting from SAP ECC data extraction and extending to file processing, central data storage, and Power BI reporting. SAP-native extraction mechanisms were combined with Microsoft Power Automate and Microsoft Fabric to enable automated ingestion, transformation, and reporting while respecting existing system, governance, and organisational constraints.

The project resulted in a fully functional and automated data pipeline for master data quality reporting. The solution reduced manual reporting effort from several hours per cycle to a few minutes of monitoring activity and enabled a reliable daily reporting refresh instead of a weekly manual execution. Reporting execution is now stable, reproducible, and independent of individual availability. By centralising data ingestion and transformation within Microsoft Fabric, Excel-based processing was eliminated and replaced with structured, auditable data preparation. The solution preserves SAP ECC as the single source of truth while transparently handling system constraints through a hybrid automation approach. As a result, data quality issues can be identified earlier, reporting availability has improved, and operational risk from manual handling has been significantly reduced. The implemented architecture provides a scalable foundation that can be extended to additional master data objects and process performance indicators without fundamental redesign, supporting future reporting and data governance initiatives.