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

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.