Community Submissions

Charting Opta Statistics With Bubbles & Radars

Readers who are familiar with any of my previous output on this site may be aware that I like taking a visual approach to the numbers side of the game. Such an approach helps to make the ‘story’ stand out at a glance in a way that the tables of numbers in the members area can’t achieve.

Without wanting to open up long-standing arguments over whether a focus on statistics brings anything meaningful to Fantasy Football, I don’t think it’s controversial to say that for most Fantasy managers, the holy grail is to find attack-minded players who can both score and assist, preferably who no one else has noticed and who come at a cheap price.

The tables in the members area will certainly flag up players who score well on the threat and creativity metrics, but (with apologies to Doosra and his tables), I sometimes struggle with the tabular format of the data, and I like to apply factors like Fantasy Premier League (FPL) price or ownership to help identify the cheap differentials.

This brings me on to bubble and radar charts, a couple of formats I’ve been playing with to visualise the members data and help sift the Fantasy gold from the plethora of two-pointers.

Analysis like this always works best with a large sample size of data. With only four Gameweeks of this season gone, we certainly don’t have enough data to draw confident conclusions; only an idiot would look at the numbers and attempt to pull out any meaningful analysis.

So… I’m now going to look at the numbers and try and pull out some meaningful analysis.

72 Comments Post a Comment
  1. Diva
    • 9 Years
    8 years, 8 months ago

    Great work! I've been using data visualization on my blog, but I bow before the master.

  2. Zasa
    • 9 Years
    8 years, 8 months ago

    The GOAT of community contributions, fantastic work like always. Thanks for this!

  3. tm245
    • 12 Years
    8 years, 8 months ago

    This is the article every community contributor has wanted to submit. Fantastic work.

    1. Pepereina Pizza
      • 10 Years
      8 years, 8 months ago

      agreed. I stood and applauded. Thank you OP !

  4. RubeRx
    • Fantasy Football Scout Member
    • 9 Years
    8 years, 8 months ago

    I could probably stare at this for hours upon hours

  5. The Albatross
    • 14 Years
    8 years, 8 months ago

    I'm really impressed. Thanks for sharing this.

  6. Hank Moody
    • 9 Years
    8 years, 8 months ago

    gomis or vardy?

    1. Pepereina Pizza
      • 10 Years
      8 years, 8 months ago

      subscribe and the world will be at your fingertips

  7. Shmadz - Le Saux Solid Crew
    • 11 Years
    8 years, 8 months ago

    These charts are like a Babel fish for stats! Superb work, TTT. Many thanks for this.

  8. rakkhi
    • Fantasy Football Scout Member
    • 13 Years
    8 years, 8 months ago

    Have produced similar radars but far less good looking in Google sheets. Find it very useful. Great analysis

  9. d1sable
    • Has Moderation Rights
    8 years, 8 months ago

    Simply amazing -

    When you said other source i thought you meant Football Manager - you can switch the normal stats view to a similar graph in that 😛

      • 10 Years
      8 years, 8 months ago

      Ted Knutson from Statsbomb and now Brentford FC format to radar charts is almost identical. This doesn't take anything away from 3rd Turd though, this is an excellent take on them.

  10. VillaDan
    • 10 Years
    8 years, 8 months ago

    Fantastic article. Can the members area please add these chart formats as standard?

    1. Mungo
      • 9 Years
      8 years, 8 months ago

      Awesome analysis, thank you! If there was a way of incorporating points potential vs price to your bubble chart, that would be super awesome, great work, I'm looking forward to more of this, be fab if these charts could be added to the members area!

  11. MOTHRA
    • 8 Years
    8 years, 8 months ago

    That's amazing. Better than championship manager.... Statistics are the future.

  12. Veraswami
    • 9 Years
    8 years, 8 months ago

    Awesome stuff mate !!

  13. roscola
    • Fantasy Football Scout Member
    • Has Moderation Rights
    • 12 Years
    8 years, 8 months ago

    Beyond brilliant

  14. Super PVA - Small Spuds
    • 10 Years
    8 years, 8 months ago

    Outstanding. Thank you very much.

  15. FPL Daniel
    • 14 Years
    8 years, 8 months ago

    My head hurts. I think we need youtube tutorial for more understanding of all this bubbles. But thanks man you are my idol, this is ridiculous (positive comment) stuff

  16. rakkhi
    • Fantasy Football Scout Member
    • 13 Years
    8 years, 7 months ago

    Hi The3rdTurd if you are still monitoring the comments on this page: I was looking at how to create the radar's like you did with my own charts. Some looking around and googling did not identify how to easily create radars in Tableau. All the links seem to be using a background image and then somehow working out the x/y coordinates or using some complex maths. Did you find an easy way? email me please: rakkhi.s[AT]gmail.com

    1. The3rdTurd
      • 13 Years
      8 years, 7 months ago

      You've pretty much described how I did it, i.e. it's a background image with x/y coordinates calculated in a spreadsheet. I don't think the maths is that complicated though - essentially you just work out the x/y coordinate of each maximum metric value (i.e. at the outer edge of the chart), then scale it back accordingly based on the players' actual performance stats.

      I used this as a guide:

      http://www.theinformationlab.co.uk/2013/08/05/radar-charts-in-tableau/

      1. rakkhi
        • Fantasy Football Scout Member
        • 13 Years
        8 years, 7 months ago

        Thanks for the reply. May look into it but in searching for why Tableau did not support radar charts in their base graphs was reading some stuff saying radars are very poor ways of visualizing information and there are almost always better ways. The different axis values is a key reason why radar maybe good for this data though and they certainly look good! I was experimenting with using a simple bar graph with converting the data into a percentage of the league top values for past years. Made me actually want to learn more about visualising data better!
        https://public.tableau.com/views/EPL15-16PlayerPerformance/PlayervsBenchmark?:embed=y&:display_count=yes&:showTabs=y

  17. GreenWindmill
    • Fantasy Football Scout Member
    • 12 Years
    8 years, 7 months ago

    😯

    Oh

    My

    Goodness

    For tedious personal reasons I won't go into I've barely been around for weeks and have just been catching up on some reading. So happy I did as this is about the best article I've seen on here. Just superb. A sincere thank you for submitting it.

  18. robdag
    • Fantasy Football Scout Member
    • 11 Years
    8 years, 3 months ago

    This chart was amazing. What happened to this?

      • 10 Years
      8 years, 3 months ago

      Probably had the plug pulled on it by OPTA for too much data sharing

      1. Elvy
        • Fantasy Football Scout Member
        • 8 Years
        8 years, 3 months ago

        It's still there. Go to public.tableau.com and search "FPL2015"

          • 10 Years
          8 years, 3 months ago

          heh, thanks

    1. robdag
      • Fantasy Football Scout Member
      • 11 Years
      8 years, 3 months ago

      Thanks!