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:

Download Tutorial

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:

Download Tutorial

 

Facebooktwittergoogle_plusredditpinterestlinkedinmail

Leave a Reply

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

Related Posts

blog

XBRL Automation for Financial Analysis

There is a common misconception about the costs associated with structuring data for financial filings to regulators. Companies assume that converting financial reports to XBRL a high effort / low value expense. But the lack Read more…

blog

Power BI Tutorial: How To Create Bump Charts

In this Power BI tutorial we’ll go over the steps to create bump charts, which are a visually appealing way to view a rank over time. Although not native to Power BI, bump charts can 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…

 

Login

Register | Lost your password?