VizWiz

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

April 13, 2020

#MakeoverMonday: Messi vs. Ronaldo - Who Took the Fewest Minutes to Score?

, , , , , , , , No comments
I haven't written a blog about Makeover Monday since the end of last year and I want to get back into the habit of blogging, so I'll give a quick review of what could be improved with this week's viz.


What could be improved?

  • Curvy lines don't help you see the exact points of the data. When curved lines are drawn, they render to smooth out the lines, therefore misleading the location of the data along the axis. 
  • Does the data represent each season or matches within a season? Given that I haven't looked at the data yet, the curved lines make me think the latter.
  • Is there a missing title?
  • What does the y-axis represent?
  • It looks like the data might be goals per match, but that would be misleading since they might have substitute appearances? Would goals per minute normalize the data better?

For my alternative, I decided to see who scored goals more often based on the number of minutes played, in other words, how often do they score? Then I wanted to know, season by season, who was better based on that stat.

July 21, 2014

Makeover Monday: Slicing Up the La Liga & Premier League Revenue Pies

, , , , , , , , 19 comments
Over the weekend, Reader Ben Jones sent me a message on Twitter pointing me to this post by @kmgfootball, which he thought would be great for a Makeover Monday example.


The point the writer is trying make is clear: Barcelona & Real Madrid combined get almost as much revenue as the rest of the clubs in La Liga, whereas in the Premier League, there's much more parity and revenue sharing. The problem is that the charts are basically unreadable.
  1. There are 20 slices in each pie.
  2. Each slices contains way too much content: team logo, team name and revenue, yet it lacks the percentage each team takes in, which is more meaningful than the revenue in this case.
  3. The image is blurry.
  4. The fonts are tiny.
I recreated the data and used Tableau to build a lollipop chart instead of a pie chart.


I chose a lollipop chart because I wanted to show the data in a bar chart view, but accentuate the end points. I then color-coded the dot on the end of the lollipop by the revenue and kept the range consisted across the leagues. In addition:
  1. I kept the scales for the bars the same on both charts so that you could see how the leagues compare to each other.
  2. I converted the Pounds to Euros (1 british pound sterling = 1.26 Euro) to make the data more comparable.
  3. I included the share of revenue as a label on the lollipop.
This view makes two points very obvious:
  1. There are only two teams that matter to TV networks in Spain.
  2. The Premier League is very, very rich. The team will the lowest revenue allocation is higher than the third highest team in La Liga.
How would you visualize this data differently? The lollipops are merely one approach. Download the Tableau workbook here and leave a comment with a link to your version.

September 13, 2013

When Arsenal stole Mesut Ozil from Real Madrid, they got a player nearly as good as Xavi and Iniesta combined

, , , , , , , , , , 3 comments
Fact: Mesut Ozil is a Gunner
Fact: Across all competitions, Ozil is nearly as good as Xavi and Iniesta COMBINED, merely 0.01 goals + assists per game behind the combined pair.  Get your head wrapped around that.

When Arsenal surprised everyone by actually spending some money on transfer deadline day with the club-record signing of Mesut Ozil for $67M, many of the pundits (1) were in shock that Madrid sold him and (2) thought Arsenal had secured THE BEST central midfielder in the world.

Turning to the data, you can easily make such an argument.  Using the viz below, you can compare Ozil to many of the other top central midfielders in the World.

  • Despite having played fewer seasons than nearly all of the players on this list, Ozil is the leader in total assists, leader in goals + assists per game, and the runaway leader in assists per game across all competitions.
  • Xavi and Iniesta may get all of the plaudits, but they are well down the list of goals + assists per game across all competitions, coming in at 10th and 13th respectively.  They are far behind Ozil and just behind Santi Cazorla.  This has to bode well for Arsenal.
  • Ozil has been the clear leader in assists across all competitions for the past four years. meanwhile Xavi's production has steadily dropped, with a dramatic drop off in the 2009/10 season.
  • Ozil consistently performs better for country than club and on the international stage, his performance vs. his peers is even more staggering.
  • Barca need to get Cesc on the field more often.
  • Frank Lampard, despite playing for the Evil Empire in Chelsea, was astonishingly consistent and dominant from 2003/04 through 2009/10.  Frank performs better than Gerrard on the international stage when looking at averages per game, yet you would think, based on what you hear in the press, that Gerrard's performances far exceed those of Lampard.  The data shows otherwise.  I suppose that's why they call them pundits and not experts.
  • Manchester United are desperate for an attaching midfielder to complement Michael Carrick.

Play around with the viz and comment with things you see.  You can also download the workbook here.

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 )