Posted on Aug 16, 2019 by Rhishikesh Joshi in AI | Media | Entertainment Problem: Let us start with explaining you in brief the business problem in Indian Media Industry that we intend to tackle. There are majorly 4 stakeholders viz. Advertisers, Media Agencies, Broadcasters and Broadcast Audience Research Council (BARC) – central rating agency. Advertisers hire Media Agencies to […]
Business Case: To analyze and tell a story about viewership data for the particular channel. Understanding and viewing trend patterns across markets, channels and content while also comparing them. A proper deep dive into every aspect of the necessary KPIs and GRP ratings. Solution: To create a consolidated view of market, channels and performance […]
OVERVIEW: Communicating insights through data visualization is not easy, even with the best Business Intelligence Tools at our disposal. Many a times we find ourselves struggling to communicate clear-cut insights. One such use case is Customer or Market Segmentation problems. Scatter plots are often the go-to visuals in this case. However, they fail miserably if […]
RLD – Opportunities and Beyond Last year October Broadcast Audience Research Council (BARC) – sole TV Viewership Monitoring Entity in India – announced the release of Respondent Level Data (RLD) for Broadcasters. While it was accessible to Media Agencies before that, releasing the data to broadcasters was new. Before I explain what RLD is let […]
Posted on May 11, 2019 by Hrishikesh Joshi in AI | Media | Entertainment A few months back a paper published by Anacondas “Why Your Business Needs an AI Platform” caught my attention. The Value creation Matrix in the paper describes the impact of AI ($billion) verses share of AI impact in total impact from analytics. What surprised […]
As a DevOps engineer, the choice of cloud platform can significantly impact both workflow and project success. Amazon Web Services (AWS), Azure, and Google Cloud Platform (GCP) are three major players in the cloud services market, each of them offers a unique set of features and pricing structures. In this blog post, we’ll explore these […]
Business Case: To analyze operations and volumetrics related to insurance premium and derive appropriate trend analysis from the data. To understand and dig deeper into the different types of policy. Solution: To create an overview that spans information about policies, premiums and gives a trend analysis in terms of relevant KPIs. Technology used: Power BI […]
Business Case: Understand advertisement spends through the three mediums of TV, Radio and Print along with key metrics like GRPs, NGRPs, SOVs across multiple media channels and Dayparts. Solution: Analyzing the spending across mediums and diving deeper into the sectors and the product itself. We also want to understand how the key metrics impact these […]
Business Case: To understand spending patterns in advertisements through the four mediums of TV, Radio, Print and Digital across the two sectors of Retail and Service. Solution: Analyzing and comparing the spending across mediums and diving deeper into the sectors and the product itself. Technology used: Power BI and Excel Data Source: The report is […]
This article is for all Media Planners, Analysts, and Data Engineers dealing with digital campaign management platforms like Google Ads, DV360 or Meta. We have extensively worked on the reporting side of these platforms, and or experience says that creating a scalable data model for your reporting teams can turn out to be quite challenging. […]
