Media planning

BI Dashboards for the world's largest Media & Advertising Agency
We helped build around 6 applications for them:

• BI Dashboard for MEDIA Data

- Here, we help pull around 50 GB data from TAM every week from different sources like excel, MDB files, SQL. We have written ETL to pull the data and then built a dashboard to calculate various Media parameters like GRP, TRP, REACH, AD SPENDS, Dispersion, channel-wise reach, program-wise REACH, etc.