For week 3, given it was Inauguration Week in the U.S., we decided to makeover a bubble chart of President-Elect Trump’s tweets. The data set provided came from Trump Twitter Archive and we ran into a couple hiccups:

  1. In the TDE I created, I thought it would be helpful to include a nicely formatted date field. However, I made a mistake; I used hh for the hour instead of HH, making 12:00-12:59pm appear as 00:00-00:59. I had no idea there was a difference between hh and HH. Basically hh returns the hour in am/pm format, whereas HH returns the hour of the day. I fixed it, but not before a few folks had already published their work. As we learned in week 1, it’s on the analyst to question the data. FYI, when working with date format options in Tableau, they use the ICU options.
  2. All of the tweets were in UTC. Very few people adjusted the data to Eastern Time, but when I think about it, that’s actually not completely correct either. Why? Because Trump isn’t always on the east coast. What would be best, in my opinion, is to leave the data in UTC and note that on the visualisation.

As always, if you see a problem in the data sets we provide, tweet Eva and me and we’ll have a look. These problems aside, there was some fantastic work this week! We’ve had over 80 submissions this week and a pretty dense data set. Kudos to all of you.

Mike Cisneros

Author: Miguel Cisneros
Link: Tableau Public

What I like:

  • Had me totally engaged instantly
  • Visually stunning
  • Summary radial charts reveal incredible patterns, and to use them to filter the main visual is brilliant!
  • Great use of color; the orange and purple contrast well
  • Love the month-by-month summaries
  • Clicking any tweet reveals the text of the tweet
  • Great summary and explanation text
  • Great use of sizing to represent engagement
  • If there was ever a great use case for a radial chart, this is it!
Curtis Harris

Author: Curtis Harris
Link: Tableau Public

What I like:

  • How in the world did he build this? Incredible!
  • At first you think it’s just packed bubbles, but look again!
  • Really like how the color becomes darker after the election
  • Technically brilliant – no wonder he won Iron Viz 2016
  • First time I’ve ever seen a subliminal message in a Tableau visualization
  • Nice search feature
  • Nice use of text as a legend
Matt Francis

Author: Matt Francis
Link: Tableau Public

What I like:

  • Love the look of the Fitbit sleeping patterns
  • Nice mobile-friendly design
  • Good use of the Fitbit sleep dashboard colors to keep with the theme
  • Barcode chart is great for showing Trump’s tweeting habits
  • Simple filter for month that works perfectly on a phone
  • Summary card gives all the important details
Kovács Ivett

Author: Kovács Ivett
Link: Tableau Public

What I like:

  • Great side-by-side layout
  • Nice story to that flows from top to bottom clearly
  • While it is wide and scrolling is required, it’s nicely divided into sections that result in a screen by screen display without having to switch screens.
  • Really like the minimal use of color
  • Good use of annotations
  • Cartoons provide a really nice conclusion
  • Sentiment analysis is made really clear simply by the use of light vs. dark
  • Good example of storytelling with data
Sarah Bartlett

Author: Sarah Bartlett
Link: Tableau Public

What I like:

  • Love the caricature! It grabbed my attention right away.
  • Like how it’s split up into three stories without a need for separate views
  • The first line chart, while not having an axis or tooltips, gives me a sense of frequency and volume.
  • Nice annotations that add context
  • Nice comparison chart of tweets vs. retweets including a good text summary that explains what you’re seeing
  • Using his campaign slogan for the summary is a nice touch
  • Good use of color overall that matches the colors of Trump’s campaign banner