Solutions

Business Intelligence Dashboards for Media giant

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.

Core Skills

Microsoft Technologies (ASP .NET, C#, SQL Database, BI Solutions, ETL, etc)
PHP and CMS based Technologies
Mobile Technologies

Our Projects

Business Intelligence Solutions
Corporate e-learning Solution
Mobile Applications
Multiple Web Portals
e-commerce Portals
Money Transfer Solution

Contact us

You can reach us at

Tel: +91-80-4127-6111

Tel: +91 9481475144