VizWiz

Launch, grow, and unlock your career in data
Showing posts with label Alabama. Show all posts

December 13, 2017

Alabama's Special Election: The 13 Counties that Swung the Vote

No comments
Unless you've been living under a rock, you know that Democrat Doug Jones defeated Republican Roy Moore in a special election in Alabama yesterday because the first Democrat to win a U.S. Senate seat in Alabama since 1992.

To help me understand where Senator Jones won, I downloaded the election results from Wikipedia (for the 2016 Presidential election) and from The New York Times (for the 2017 Special Election).

My Goals

  1. Understand the change county-by-county across the two elections
  2. Emphasize the counties that switched from Republican to Democrat

I was struggling with the wording of my dashboard, so I posted it on Convo for feedback from my colleagues. Here's what I posted:


The feedback was fast and furious, just the way I give it to them. Essentially this view wasn't terribly clear, especially the map. Ben Moss basically told me that I created a confusing (a.k.a. crap) viz and suggested using a blue color palette instead to emphasize the change towards the Democrat in each county.


Better, but this could easily mislead the reader into thinking that every county was won by the Democrat. Ravi Mistry suggested grey instead.


Nope! That doesn't work either. So back to the drawing board I went. Ben Jones and Jonni Walker were visiting The Data School today so I asked for their feedback. Ben suggested directional arrows and pointed me to his blog post for creating the arrow shapes I needed.

The next step was to take the slope graph and make it directional arrows, focusing only on those counties that switched from Republican to Democrat. From there, it made sense to split the map into two by election to give side-by-side maps and shade the counties by the party that won and the percentage of the vote.

Lastly, I cleaned up the titles and I was done. Fun exercise and I learned quite a bit about directional arrows and the Democratic stripe that goes straight through the middle of Alabama.

December 11, 2014

Makeover Monday (on Thursday): How one of the richest teams in college football makes & spends its money

6 comments
In late November, Cork Gaines of Business Insider wrote about how the University of Alabama football team makes and spends its money. The two articles were accompanied by these two pie charts:


There are many issues with these charts:
  1. They are pie charts, which makes comparing the slices difficult.
  2. The slices are not labeled with the amount, so I have to make some guesses as to their contribution to the whole and then multiply that by the total shown in the titles. That's way too much work.
  3. There are categories missing from the source data.
  4. Why are these in two separate articles since they are a related story? Why aren't they combined in a single story?
  5. There's no mention of the profit the football team turns.
I could go on, but I'll stop there. One of the great things Cork does in his articles is link to the source data. This allowed me to download the data from this website and build my own visualization.


NOTE: This is an update of the original chart based on feedback from Nelson Davis. Nelson suggested making the bar sizes relative across the charts, which my first version failed to do.

First, I need to give a special thanks to Emily Kund for reviewing this viz and providing some great feedback. For example, it was her idea to use the Alabama official colors in the viz.  Thanks Em!

In my version of the viz I wanted to:
  1. Bring the revenue and expense data into the same view
  2. Provide a high-level overview, including profit
  3. Rank the categories in descending order, except for "Other", which I prefer to place last in the sort
  4. Include the actual amounts by labeling the bars
Thoughts? Which do you prefer? Why? You can build your own by downloading the Tableau workbook used to create this viz here or view it on Tableau Public here.

August 18, 2014

Makeover Monday: SEC Football Coaches Get Paid!

5 comments
College football season is nearly upon us and for those that live in the Southeastern US, college football is king. It dominates EVERYTHING - from sports talk to newspapers to online forums to Facebook posts to coaching salaries. College football = Life to so many people. If you've never been to an SEC football game, add it to your bucket list; it's an experience unlike any other.


Saturday Down South is a website dedicated to all things SEC football. This past Thursday, they published this list of the salaries for each coach in the SEC (except for Vanderbilt who does not publish their coach's salary).


This list is simple enough, yet when I saw it, I felt like there was more of a story in there. You can clearly see, just from the table, that Nick Saban is a huge outlier. He's a winner, and he gets paid to win. Keep in mind that these are only their base salaries too. Bonuses, appearance fees, etc. are not included.

I decided to use Tableau's story points for the first time to answer a couple of key questions:
  1. How much of an outlier is Saban compared to his peers in the SEC, to other coaches in other sports and to other college football coaches?
  2. How widespread is this level of pay for college football coaches and how does the SEC stack up?
  3. Is Saban worth the money?
I also need to give a quick thank you to Emily Kund and Matt Francis for reviewing this story for me.

Some things I've learned while using Story Points for the first time:
  • If you want to tell a story, know the questions you want to answer ahead of time. This will help you plan the beginning, middle and end of the story.
  • As I answered questions, I was led to more questions, which led to finding more data, which led to a better story. Be prepared to iterate.
  • Story Points are pretty inflexible. You can't do any formatting of you viz once you're inside the Story Point. You have to go back to the original worksheet to change anything. I had expected this to work more like editing a viz on a dashboard.
  • I feel like I'm not quite using Story Points as they were intended. I feel like I'm missing their intent in this attempt because I could have done all of this same formatting with multiple dashboards and tabs. I need to learn more about the “idea” behind Story Points.
Download the data here and the Tableau workbook here.