Solutions

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.

• Media Planner and Campaigning Tool

- We basically built and application for Media Planning. Based on the Historical data, the tool helps Media planners to create Campaigns and Monitor campaigns

• BI Dashboard for GroupM end clients

- Here, we built a SAAS application to auto-generate Media reports. Every week, ETL happens. Data gets pulled from different sources - TAM, Map in the form of excels, SQL, MDB files and gets uploaded. After this, weekly and monthly reports are automatically generated. We also provide a lot of customized features such as - Mapping at advertiser, channel, brand, category levels. Also, the media planner can create customized plans by selecting required Categories and Brands as well as selecting required TG-MG Combinations. Various reports such as Top Categories, Brands, SOE-SOV Mix, Media Mix, BHI Index, etc have been automated.