Client: ETV Bharat - News and Media (Ramoji Group)
Media and Publishing Company - ETV Bharat - A leading comprehensive Digital National News platform conceived to deliver seamless news and information services (in 13 languages), using video-centric Mobile App and Web Portals.
Achievements
65
% Cost Saving on BigQuery billing
30
% Improved Query Processing
Objective & Challenge
The client has desired to build an interactive dashboard for their entire Editorial team, State Heads and Content Writers (~50 readers) to understand the performance of their digital news platform.
The objective was to allow the stakeholders to visualize and evaluate the effectiveness of their content by Region, State, Language, Category, Sub-Category etc.
The challenge for the client was the BigQuery (BQ) + DataStudio integration resulted in huge billing while serving the purpose of building dashboards and wanted ViuStats to propose possible solutions that are cost effective and robust.
Solution
Increased the query efficiency and performance through BQ Clustering
Programmed queries to run faster while spending less time on partitioning logic
Created a smaller sub-set of tables based on the business reporting needs and connected them with DataStudio
Outcome
POC enabled client's team to realize the following benefits:
65%
Cost Saving on BigQuery billing
30%
Improved Query Processing
Proposed strategy of automating daily export from BQ to AWS RedShift allowed the client's team to realize a cost reduction of at least 4 times compared to the current incurring cost.
