Off the Charts Consulting
  • What we do
  • Who We Are
  • Blog
  • Contact

Fantasy Football

9/7/2017

0 Comments

 
0 Comments

Sentiment Analysis Part 2 - Keyword Search

9/5/2017

0 Comments

 
Last week we looked at some static data comparing Trump to Obama's twitter tone. 

Today I'm excited to show a dynamic option that allows you to search specific terms and compare the tones of the last two US presidents. If you're interested in getting one of your own, check out our products page! 

​
0 Comments

Sentiment Analysis - Trump vs Obama

9/1/2017

0 Comments

 
Sentiment analysis is still an emerging concept that is far from fully refined. It takes in strings of text and evaluates word by word to discover the overall sentiment and subjectivity. 
Due to the nature of human language there are obvious fail points, especially considering sarcasm. At an individual level it could give the sentence "No, I'm not willing to die yet" a very negative score (due to the words no, not and die) when it may be the opposite. 

But, on an aggregate level, it's not too bad. The occasional miss calculations usually become anomalies in the grand scheme. 
Below is a look at the last 3200 tweets written by former US President Obama and current US President Trump. I've run these against sentiment analysis and the results - as well as how their users interact with them - is interesting.  Also, to order your own twitter sentiment analysis - See our new products page

First let's look at total counts by sentiment and subjectivity
Picture
First interesting thing is that in the last 3200 tweets, Obama has never written directly to a user - anyone holding out hope for a reply should bury that dream. 
Sensitivity: Obama has 3% of all personal tweets as showing a negative sentiment. Trump comes in higher at 11%, having twice as many negative tweets over a smaller sum. Also of interest is that Trump overall is more positive than Obama as well. Overall, Trump shows far more emotion in his tweeting with 42% of tweets registering an emotion compared to Obama's 31%.

Subjectivity: Obama registers half his tweets as objective, with Neutral being the next highest and only sending a subjective tweet 19% of the time. Trump is a bit more spread out in his objectivity, but he does tweet subjectively less than he does Neutral and Objective. 

But where it really gets interesting is how followers react to each tweet category. 
​
Picture
Sentiment: Obama's very small negative bucket registers the best, which is surprising. If you consider the president's role, these tweet's are typically denouncements or condemnations. His Neutral and Positive tweets do about the same. 
Trump's followers don't go for the neutral tweets. Both the positive and negative tweets do way better. His twitter blows up when he shows emotion, which potentially explains why we see so much of it. 

Subjectivity: Obama's twitter base go for don't touch his neutral tweets. They, seemingly, like the facts or an opinion, but nothing that flaunts the line. And it's significant, on average when he is down the middle, he gets 2K less retweets per post.
For Trump, similar to his sentiment, people love his subjectivity. "He tells it like it is" well that's because it gets results. He averages an extra four thousand retweets more when he's subjective vs objective. 

To see how the full charts look, or to get one for you or your company register, click here
0 Comments

4000 + Foot Mountains in New England

8/18/2017

0 Comments

 
Key Findings
  • If you want to do the most work for the smallest climb then West Bond is calling your name. A 22 mile out and back for 4,500 feet. 
  • For a concentration of peaks rated Very Difficult then you need to hit up Baxter Park, where there are three challenging summits.
  • The quickest way to get 4000 feet are Saddleback Mountain in Maine which is a 3.8 mile trip and Cannon Mountain in New Hampshire which is 4 miles (and you could even take the ski lift down in the summer)
I'm a peak bagger through and through. I don't know if I would ever get off the couch for a walk that didn't involve a summit finish with a view. For that reason I put together this dashboard that concisely displays all the 4000 foot peaks in Maine, New Hampshire and Vermont. Hopefully this can help some of you plan that next ascent!
​ 
0 Comments

City of Fredericton Recreation Facility Usage

8/11/2017

0 Comments

 
Key Findings
  • Arenas generate 3/4 of all revenue with only 1/4 of ue
  • Turf soccer fields had almost 4 times more rental hours than grass fields
  • Fredericton's top 5 sports, by facility hours used, are Hockey, Soccer, Basketball, Softball, Volleyball

The City of Fredericton released their total demand and revenue statistics for all of the municipal recreation facilities. Divided by facility type and use. Here is an interesting comparison in how much is earned and when. Click any item to drive the rest of the dashboard. 
0 Comments

Atlantic Canada Opportunities Agency

7/28/2017

1 Comment

 
ACOA has played a leading role in creating development opportunities for the Atlantic Canadian provinces. Part of this is through funding awarded to projects that are expected to generate growth opportunities in a reason. Since 1995 this data has been recorded and is publicly available here. But below is all the data summarized into a fully drillable dashboard. Click a year, client or province to filter the rest of the information.
1 Comment

City of Fredericton Car Accidents (2007 -2016)

7/14/2017

0 Comments

 
Through their open data policy the City of Fredericton have captured all reported motor vehicle accidents in a spreadsheet made available on the city's site. Below is a look at all of those motor vehicle accidents, broken down by type, time of occurrence and where they took place.
​
0 Comments

History of Canadian Elections

7/14/2017

0 Comments

 
Canada has hosted National general elections since 1867 but the landscape has changed significantly. From electing 31 farmers in 1878 to the Rhino Party getting 1% of the Canadian vote in 1979, take a click through 150 years of national election history. 
0 Comments
Forward>>
  • What we do
  • Who We Are
  • Blog
  • Contact