Project overview
The project aimed to migrate the siloed data warehouse for ad sales and traffic monitoring areas from Microsoft’s on-site infrastructure to the cloud using Snowflake. This involved reporting and ELT (Extract, Load, Transform) processes that utilize data from programmatic platforms as well as internal client sales and traffic systems. The goal was to standardize online advertising data, enable consistent reporting across all programmatic platforms and provide decision-makers with the Ad data necessary to maximize ad revenue.
Client background
A leading media company in Poland, which operates a diverse portfolio of television channels, digital platforms and streaming services and reaches millions of viewers and users daily. Our client is part of a multinational mass media and entertainment group.
Goals
Standardizing online advertising data to enable consistent reporting across all programmatic platforms. Migrating the siloed data warehouse for ad sales and traffic monitoring areas to a cloud-native solution and extending the data model to handle new data sources. Standardizing reports to allow for new KPI support.
