Project info
- Client:
- Large Media House
- Category:
-
Business Intelligence and Visualization Solutions
Project Description:
The end client is one of the largest media house which carries out media planning, execution and reporting for its end clients.
Key Challenges:
- Diverse data sources varying with client and high volume associated with click level tracking
- Identification and implementation of standard sources and standard reports for a diverse client base
- Seamless and reduced timeline to onboard multiple clients
- Ensure data reconciliation with standard reports published by data providers
Solution:
- Build of Standard connectors to source all data from data providers to ensure standardization across clients
- Build of a data warehouse at the most granular level to provide comprehensive reporting & analytics capability
- Client specific marts to ensure robust security and address client specific dimensional reporting
- Flexibility of user specified visualization tools accessing SSAS cubes
- Rich set of auxiliary applications
- Extend reporting capabilities through user defined KPI
- On boarding tool to ensure seamless on boarding of multiple clients with diverse requirements
- Robust validation process to ensure reconciliation with data providers
Benefits:
- Creation of a consistent data asset integrating multiple sources for enterprise wide use in a secure manner
- Ability to determine efficacy of different media channels on a single reporting platform
- Near real time reporting that allows alteration to campaigns
- Increased leverage of platform through seamless on boarding of multiple clients