Problem:
An American commercial broadcast television network needed to improve reporting and improve viewer experience by:
- Consolidate and migrate scattered analytics from multiple platforms (GA, GAM, Conviva, Freewheel) to Azure with optimized ETL architecture and reporting using Power BI
- Automate revenue tracking across environments
- Develop custom backend features (Continue Watching, Wishlist)
Approach:
- Built various Azure ETL pipelines to consolidate analytics from GA, GAM, Conviva, and Freewheel into Azure Synapse
- Developed FAST and LIVE metrics systems using Snowflake stored procedures with daily Conviva SSD file ingestion.
- Deployed SSAS cube as intermediate layer between SQL Server and Power BI maintaining cross-source data relationships
- Built low latency APIs to support Continue watching and Wishlist features without any perceptible increase in page load times to the user
Impact:
- Automated metric tracking across FAST, live events, and syndicated channels.
- Enabled a personalized streaming experience with Continue Watching and Wishlist features on Azure.
- Empowered executive decision-making with Power BI performance and revenue analytics.
- Established unified analytics across platforms.
- Automated revenue tracking through multi-source integration.
- Enhanced user engagement via personalized features.
- Reduced costs through optimized cloud resource utilization.
