The challenge
Where they started
Victrex had invested heavily in an Azure data platform bringing Dynamics 365 Finance and Operations and Customer Engagement data through Synapse Analytics into Power BI. Over time it had accumulated hundreds of hardcoded pipelines, dataflows and datasets, full-table reloads whose run times grew with data volume, and a Data Vault that had drifted from its own design principles. Costs were hard to predict, key services were publicly reachable, access was granted to individuals rather than groups, and neither Synapse nor Power BI had version control or automated promotion between environments. With Synapse heading towards end of life, the business needed a clear, lower-risk route to a modern platform.