Business Intelligence and Data Warehousing solution for global Media & Communications leader located in NJ, USA

The client is a Media & Communications organization in USA.

Challenge

The media research company required an analytics on customers viewing patters to provide indicators on popular television shows, commercial events and news media events to advertising agencies, and national broadcast and cable networks.

Solution

• Designed state of the art customer analysis and reporting system. The 2-terabyte data warehouse was designed to provide analytical data on program viewer-ship.
• Designed analytics program to provide near-real time analysis on program viewer-ship for commercial, sports events, news segments and television shows helping to isolate popularity of shows within specific age categories.
• Designed & developed a cloud-based big data Data Warehousing and Business Intelligence solution based on decision support system - DSS technology, to deliver unprecedented analytical power to managers over a web interface.

Benefits

• Research and Analysis - Data warehouse facilitated reporting on program and viewer information helping to isolate customer viewer information within different age categories and demographics.
• Information Analytics - Information assisted cable networks, sponsors and advertising agencies to gain better understanding of the effect on their targeted audiences and the number of targeted audience impacted through their efforts.
• Anomalies - Managers can also track and analyze "gaps," which are period-to-period changes in operational trends
• Business Drivers - Analyzing the data revealed the actual viewing masses, drivers behind events and helped discover targeted audiences that previously may have been overlooked.

Technologies used:

• Data Warehouse - Google Cloud
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x