Facebooktwittergoogle_plusredditpinterestlinkedinmail

Analytics tools can be powerful in just about any aspect of our lives. Read below about the use of Spotfire and Tableau by our summer interns (Sidhant Uthra & Ross Wilhite) in visualizing the sentiment of people engaging on Twitter during a World Cup game.

Get the R code and the Step by Step Tutorial for Spotfire and Tableau here.

Tableau can visualize the data in a plethora of ways. A great example is the Tree Map as represented below. It can allow for the user to determine the most popular tweets and their sentiment. Moreover, it allows for the user to view the attributes of individual tweets as opposed to viewing a conglomeration of tweets in the form of a graphical representation of a country on a map. This visualization is created by combining the sentiment score, the retweet count, and the actual tweet text. Such a visualization could be useful to a company in order to determine why a certain negative tweet is popular and then diagnose and solve the more commonly occurring problem.

SentimentAnalysis_Tableau1

This is a snapshot of Sentiment Analysis of Twitter data from the Brazil v. Netherlands game running on Tableau.

  •  The green boxes are positive tweets, the red boxes negative, and the brown boxes neutral
  • The intensity of the green and red colors depends on the score
  • -6 = very negative, -1 = slightly negative, 0 = neutral, 1 = slightly positive, 7 = very positive
  • The score was determined using compatible dictionaries with words assigned a score value
  • To create this visualization, two .csv files were used: one that assigned scores to each tweet and another with all of the original data from Twitter (language, text, retweet count, etc.)
  • See Resources section for helpful PDF files

Below is a bar chart that visualizes the same FIFA game of Brazil vs. Netherlands game running on TIBCO Spotfire, one of Syntelli’s partners.

Sentiment_Analysis_Spotfire_BarChart

  • The horizontal direction measures the number of retweets and the vertical represents the score of the tweets that was captured during the sentiment analysis that we did of the tweets.
  • The color represents the language of the tweet. Yellow is English, pink is Spanish, and blue is French, and the rest are irrelevant due to their rarity in the data.
  • On the top graph, the score is represented by the average score for each amount of retweets.

 

Resources:

Positive Word List

Negative Word List

Get the R code and Step-By-Step tutorial for creating this visualization in Spotfire & Tableau

 

Facebooktwittergoogle_plusredditpinterestlinkedinmail

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

Tip of the Week

How To Create Bump Charts In Power BI

Bump charts are a visually appealing way to view a rank over time. Although not native to Power BI, bump charts can be created using the RANKX function in DAX in a line chart and Read more…

Tip of the Week

Up And Running With Row-Level Security In Power BI

It has quickly become the norm for companies to maximize their data potential by using data in their everyday business processes. And as your data grows and users increase, the need for limiting data to Read more…

blog

Summer Intern Perspective – Pt. 2

Another one of our interns, Sharat Vyas, describes his experience of doing a summer internship with Syntelli.              This past summer, I have had the privilege of interning at Syntelli Read more…

 

Login

Register | Lost your password?