/plushcap/analysis/confluent/confluent-ksql-in-football-fifa-womens-world-cup-data-analysis

KSQL in Football: FIFA Women’s World Cup Data Analysis

What's this blog post about?

This blog post explores sentiment analysis using Apache Kafka and Google Cloud's Natural Language API for the FIFA Women’s World Cup. The author uses pre-built connectors available in Confluent Hub to source data from RSS feeds of sport-related newspapers and Twitter feeds of the FIFA Women’s World Cup. They then use KSQL to apply necessary transformations and analytics, Google's Natural Language API for sentiment scoring, Google BigQuery for data storage, and Google Data Studio for visual analytics. The author demonstrates how to ingest Twitter and RSS event streams into topics, shape them with KSQL, implement Natural Language API calls in a UDF, push the dataset into Google BigQuery, and visually analyse the data in Google Data Studio. They also provide an example of sentiment analysis for a specific match between Norway and England.

Company
Confluent

Date published
July 3, 2019

Author(s)
-

Word count
2997

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.