Compass Group standardized SAP master data, reporting, and supply-chain measures

Duplicate records, hard mappings, and disconnected sources caused departments to report different numbers. The inconsistencies weakened analytics and made supply-chain and food-cost reporting difficult to trust.

• Data inconsistency issues: Compass Group worked with inaccurate and inconsistent data across the organization, which weakened analytics and slowed business decisions.
• Multiple sources, conflicting reports: Reports drew on many disconnected sources, so different teams produced conflicting numbers.
• Data duplication challenges: Duplicate records and hard mappings to new structures made reporting slow and unreliable for individual departments.

BluePi integrated SAP inventory, SAP sales, and related operational sources, established a central master-data repository and workflows, defined governance standards, and applied field-level validation and quality rules for AWS Redshift reporting.

• Complete data integration: BluePi integrated diverse data sources, including SAP inventory and sales modules, into one unified data environment.
• Master data management and workflows: The solution established master data management (MDM) alongside automated workflows, standardizing how data is handled across the organization.
• Single source of master data: BluePi created a central repository for all master data, ending conflicts between different versions of the same information.
• Governance and data quality standards: Formal data governance structures and quality standards give the organization clear guidelines for maintaining data integrity.
• Data quality rules: Validation and quality control rules applied to each master data element keep data consistent and accurate through its lifecycle.

Compass Group gained standardized master records and more reliable reporting. Supply-chain activity and food costs could be reviewed from shared definitions instead of department-specific mappings and duplicate records.

• Standardized masters: Master data now uses uniform definitions and formats across the organization, ending conflicts over how data is structured and read.
• Improved data quality: Data accuracy and reliability improved across the organization, so reporting and analysis can be trusted.
• Improved supply chain monitoring: Compass Group can now track supply chain operations and food costs precisely, with better control over critical operating expenses.

SAP procurement data was extracted each day and loaded through custom ETL on Amazon EC2. Raw SAP tables entered Amazon Redshift before aggregation jobs organized facts by dimensions such as date, region, site, and vendor. Power BI used the resulting Redshift data marts to report purchase-order status and the reasons purchase requisitions did not convert automatically.

Teams moved from daily SAP dumps and repeated Excel work to scheduled reporting from Redshift data marts. Power BI made purchase-order status and failed-conversion reasons visible so departments could correct contract, quantity, and process issues.