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 of the channel and tracking how important KPIs act in a particular region across weeks. Understanding how content and slot timings can affect viewership. The dashboard has 3 modules – Discovery Mode, Comparison Analysis and Program Analysis. 

 

Tech:

SQL, AWS, Power BI

 

Data Source:

YUMI Time Band Report, YUMI Program Performance Report, YUMI Ad Break Report and Channel Master

 

Overview:

An overview page for the rest of the sections and GRP ratings plotted across weeks.

 

Discovery Mode:

Quick and easy page to discover the drop in viewership. The Discovery Mode help you identify the viewership drop over weeks. Drilling through to Day and Dayparts level insights.    

Channel / Market Comparison:

Channel comparison for competitor analysis which can then deep-dive into understanding the growth spots for the players.

 

Program Analysis:

Shows changes in Program TVR, Content Duration and Yield over previous period. You can also understand what works for you vs competition across the day by taking a look at content performance in FPC Tracking