An end-to-end pipeline that automates GroupM’s data gathering and reporting, so their teams spend their time on analysis instead of assembling spreadsheets.
Power Business Decisions with Cloud Scale Analytics
Microsoft
Delivery partner
Practice
GroupM is one of the world’s leading media investment companies, responsible for more than $60bn in annual media investment. Collecting data from multiple sources, combining it and analysing it was an arduous, manual job, and that manual work crowded out the part that actually creates value: exploring the data and drawing insight from it.
We built an end-to-end extraction, staging, transformation and reporting pipeline on Microsoft’s cloud. Excel source files live in SharePoint Online; Azure Logic Apps within Azure Data Factory pull them into an Azure storage account; and SQL Server Integration Services extracts, transforms and merges them with existing data in GroupM’s Azure SQL databases. Power BI connects to those tables for analysis, and we worked with GroupM’s stakeholders to design and build the dashboards they needed, published to their Power BI workspaces with row-level security and refreshed regularly through data gateways.
GroupM closed the gap between business and IT, putting analysis in the hands of the people who know the data. Automating the extract and load removed the manual work and made data available sooner, so teams get to quick, valuable insight instead of spending their time gathering numbers.
Similar work in Technology & Innovation
First Technology
A cloud chat assistant, Harvey, that lets legal and paralegal staff check contract terms, dates and notice periods in seconds instead of digging through documents.
Practice
Modernise Apps with Azure AI
First Technology
We gave First Technology staff local AI chat and agentic desktop agents running on our private NVIDIA GPU cluster, so the data and token generation stay local, the bill is in local currency, and responses come back fast.
Practice
Private AI Inference
Vector Gaming
Vector Gaming needed serious GPU horsepower to train a custom 350-million-parameter model for smarter game NPCs. We put our private GPU cluster behind their Vulkan-based distributed trainer and cut a two-month run down to a fraction of that.
Practice
Distributed Model Training
Get in touch
Send us the gist of what you are trying to do. The right person from First Digital will be in touch within a working day.
