Project info

  • Date:
  • April 22, 2022
  • Client:
  • Large Media House
  • Category:
  • Business Intelligence and Visualization Solutions
  • Address:

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


  • 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


  • 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
Scroll to top