VizWiz

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

December 22, 2019

#MakeoverMonday: How much are Brits & Europeans expected to spend on Christmas?

, , , , , , , No comments
Two weeks to go and then I'm done helping co-lead Makeover Monday. It's an interesting combination of relief, reduced stress and anxiety, mixed with sadness. Either way, it's been amazing adventure.

This week, Eva picked Christmas-themed data...a simple survey from Deloitte about expected Christmas spending and the UK and Europe.


What works well?

  • It a simple table that is easy to understand without doing much thinking.
  • My eyes were immediately drawn to the two red declining arrows, which makes it seem to be the focus on the visualization.
  • The table is neatly organized from highest to lowest spending categories.
  • Everything is clearly labeled.
  • The highlight box on the right provides a nice summary.

What could be improved?

  • Remove the shading from 2018
  • Removed the shading from the background of the Total cell
  • Align the text labels either left of right, but not center
  • Remove the borders between the rows, but keep them to separate the headers and totals from the rest of the table
  • Change the font color of the categories to black; green could give the impression that they are increasing
  • Align the arrows on the second table with the rows they correspond to
  • Why is spending less red? I would think spending less is good

Taking all of this into account, here's my Makeover Monday week 52. Enjoy!

December 23, 2018

Makeover Monday: Spending on Christmas Gifts in America

, , , , , , , , No comments
We've done it! Another year in the books for Makeover Monday, the most fun project I've been a part of and the largest in the Tableau community (perhaps in data viz as well??). From year one with Andy Cotgreave, to years two and three with Eva Murray, to Makeover Monday the Book, this has been an incredible journey.

I believe Charlie Hutcheson is the only community member to complete all 156 weeks, though Simona Loffredo has only a couple of weeks to catch up on before the end of the year to join Charlie (and me) in the 100% club. As of this writing, Charlie has 307 vizzes on his Tableau Public profile, while Simona has 197. That's an incredible achievement and a testament to their dedication to improve week by week.

It's nearly Christmas Day, so Eva picked a Christmas-themed data set. Let's have a look at the viz:

Original viz by Statista

What works well?

  • It's a line chart based on time, so it's easy to understand what it's telling us.
  • Using one color
  • I kind of like the banding for every other year.
  • Good axis title for the measure

What could be improved?

  • Remove all of the numbers except the first and last years.
  • Add a title
  • Add the data source; surely Statista didn't come up with the data themselves. 
  • Remove the paywall so we can see information about the source and the publisher.
  • Remove the paywall for downloading the data. All you really need to do is type the numbers into Excel anyway.
  • Is there any insight?

What I did

  • Create something simple
  • Supplement with additional data to see if it can add any context. 
  • Looked at year-over-year change
  • Compare the statistics to look for relationships

I found absolutely no relationships between the average spending data and the other metrics. You might see that as a waste of time, but for me, that's part of the analytical process. Just because you don't find something, that doesn't mean the analysis is wasted. It means you have confirmed there is no relationship.

With that, here's my final Makeover Monday for 2018, focusing on the year-over-year change to highlight the Great Recession.

January 26, 2015

Makeover Monday: Facebook's Global Economic Impact

, , , , , , , , 1 comment
Last week on Facebook, I saw a link to this report by Deloitte. From what I can gather, Facebook commissioned Deloitte to estimate Facebook's impact on the economy.  Read the report for more details.

In the report, the first graphic that Deloitte shows was this donut chart that explodes into three slanted pie charts:


Some of the most striking problems:
  1. Using a donut chart to represent parts-to-whole is a bad idea. Read this post by Steve Wexler for a good explanation on why you shouldn't use donut charts.
  2. There's an implicit hierarchy from the ecosystem to the breakdown of each ecosystem, yet this view goes in the opposite direction by having the regional breakdown above the totals.
  3. The pie charts, while not 3D are slanted, which distorts their proportions.
  4. Pie charts are not the best way to compare proportions.
  5. The title is super small. Looking at this as a stand-alone graphic, it's difficult to understand what the purpose of the graphic is in the first place.
I recreated the data in Excel (get it here) and created this dashboard in Tableau (get the workbook here).


In this version, I attempted to address the concerns I outlined above by basically changing everything to bar charts and rearranging the view.  Does this work better? Note that I added some interactivity as well.

February 14, 2011

Money League: See how much the top football clubs make

, , , , , , , , , , , , , , , , , , , 2 comments

Let me start by saying I am a HUGE Arsenal fan. I catch every game that’s on TV here in the States. 

If you’re living under a rock and don’t watch football, the knockout stages of the UEFA Champions League begin Tuesday with Arsenal hosting Barcelona on Wednesday in the biggest tie of the round.  Catch the game on Fox Soccer Channel at 2:30pm ET.  If you want to see the game played at its absolute highest level, this is the game to watch.  It will be a beautiful sight.

Annually Deloitte publishes a list of the top 20 football clubs in the world based on revenue.  As always, the Guardian Datablog published a viz to go along with its article.  They published this absolutely hideous stacked bar chart.  Seriously, this is what they published.  How do you even know which team is which?  There is a fancy mouse-over feature.  This stuff kills me!

With Tableau, there are so many better ways to make this data interesting.  Here’s my take:

Interacting with the viz you can quickly see that:

  1. The Barclays Premier League dwarfs the other leagues in all revenue types
  2. The Barclays Premier League has seven of the top 20 teams (click on any of the league logos to filter the list of teams)
  3. Real Madrid is a MUCH bigger club than its city neighbor Atletico de Madrid (350% bigger)
  4. Manchester United is also a MUCH bigger club than its city neighbor Manchester City (229% bigger).  I hate them both, but Manchester City even more since they think they can buy themselves a title.  No chance with an Italian manager; the football is way too negative!
  5. Arsenal dominates matchday revenue, thanks in large part to the spanking new Emirates Stadium (I can’t wait to see it some day).  I heard on TV today that they generate $3M every game
  6. The top three clubs in terms of broadcasting revenue are all in Italy.  According to the NY Times, “Italian teams negotiate their own television contracts, with the top clubs like Inter Milan, A.C. Milan and Juventus garnering huge deals”, whereas it’s a shared revenue pool in the other leagues.  Heck, Real Madrid’s rank in broadcast revenue puts them at 17th, but their overall revenue has them at #1.
  7. German clubs lead the way in commercial revenue.  I know virtually nothing about the Bundesliga other than their games are fun to watch and the chanting by the fan is endless

Does anything else stand out to you?

Go you Gooners!

Subscribe to: Posts ( Atom )