{"id":246666,"date":"2024-10-21T16:20:04","date_gmt":"2024-10-21T14:20:04","guid":{"rendered":"https:\/\/www.devoteam.com\/success-story\/hadoop-to-bigquery-agora-analytics-modernisation\/"},"modified":"2025-01-27T11:27:00","modified_gmt":"2025-01-27T10:27:00","slug":"hadoop-to-bigquery-agora-analytics-modernisation","status":"publish","type":"success-story","link":"https:\/\/devoteam.info\/be\/success-story\/hadoop-to-bigquery-agora-analytics-modernisation\/","title":{"rendered":"Hadoop to BigQuery: Agora S.A.’s Analytics Modernisation"},"content":{"rendered":"\n
\n
\n

The snapshot<\/h2>\n\n\n\n
\n
\n
\n

1<\/strong><\/p>\n\n\n\n

Agora S.A., had an on-premises Hadoop-based analytics platform with growing data and infrastructure challenges<\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n

2<\/strong><\/p>\n\n\n\n

The company chose Google Cloud to improve performance, scalability, and cost-efficiency<\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n

3<\/strong><\/p>\n\n\n\n

Devoteam implemented a solution using BigQuery, Cloud Storage, Cloud Composer, and other Google Cloud-managed services<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n

About Agora<\/h2>\n\n\n\n

Agora is the 4th largest media group in Poland. Its offerings include the Helios SA cinema chain, the Next Film film production and distribution company, 9 radio stations operating under the Eurozet Group banner, outdoor advertising (AMS SA), respected news media – \u2018Gazeta Wyborcza\u2019 and Wyborcza.pl, the Gazeta.pl portal and its services (including Sport.pl, Moto.pl and Plotek.pl), the supra-regional Radio TOK FM, book, music and film publishing, as well as catering operations.
<\/p>\n\n\n\n

The Challenge<\/strong><\/h2>\n\n\n\n

In 2014, Agora began<\/strong> collecting data on service user activity using its own technology.
A Hadoop<\/strong> cluster, data model <\/strong>and data collection mechanisms<\/strong> were developed for data storage and processing.<\/p>\n\n\n\n

Hive<\/strong> was chosen for analytical purposes. The business requirement was constant access to up-to-date, aggregated data<\/strong>. Data management processes were built and a number of ETL processes based on it. In addition to traffic data, Hive also stored content metadata from monitored websites and other data from various systems.
The ever-increasing volume of <\/strong>data, the growing reporting needs on the Business side, combining different data sets, maintaining the physical infrastructure and software, addressing errors and failures – these were the main challenges of the on-prem setup.<\/p>\n\n\n\n

Concluding, the challenge featured:
<\/p>\n\n\n\n