Excel Dashboard: Premier League Season 2014-15 Visualized

I was never into sports. I tried my hand in a number of sports, but I was always below average in most of it (you got to give me some credit for trying at least).

In 2010, my roommate got me addicted to watching football. We would keenly follow all the matches in English Premier League and La Liga.

I even played fantasy football with a couple of football junkies. I still follow these matches and I still suck at playing it. 🙂

But I am better at making dashboards, and in this tutorial, I will show you how to create an Excel Dashboard that analyses English Premier League games of the 2014-2015 season.

Here is how the final dashboard looks like:

Excel Dashboard - EPL

Excel Dashboard – EPL Season 2014-15 Visualized

How to use this Excel Dashboard:

  • Use Scroll bar to change the week number.
    • Note that as you change the week number, it shows the games played it that selected week and the ranking of the teams at the end of the week.EPL Excel Dashboard - Change Week Number with Scroll Bar
  • Double click on the game result cells to get the detail for the game.
    • As soon as you double click on the cells that have the game results, the match statistics update along with the logo of the clubs. It also shows the total win/loss numbers of both the teams for the entire season. For example, if I double-click on a game of Chelsea, it would show only 3 lost games for Chelsea (in red colour bar in the win/loss chart).EPL Excel Dashboard - Double click to show game details
  • Click on the help icon to show instructions. Click on it again to hide the instructions.EPL Excel Dashboard - Click to show help instructions

Download the Premiere League Excel DashboardDownload File Pic

Learn to Create World Class Dashboards in Excel. Join the Excel Dashboard Course.

Where did the data come from?
What all goes into making this dashboard?

Are you a football fan too? Do you like it? Let me know your thoughts by leaving a comment.

Download the Premiere League Excel DashboardDownload File Pic

Other Excel Dashboard Tutorials:

Learn to create Killer Excel Dashboards

Dashboard Course banner in post

If you want to learn to create world-class Excel Dashboard, consider joining our Dashboard Course. Click here to know more about the course.

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)

  • Jon

    This is awesome! Thanks for sharing Sumit.. Love it

    • Thanks for commenting John.. Glad you liked it 🙂

  • Ajay

    Amazing.. Very innovative. I really like the way it shows the instructions for help.. Would love to see player level data in this as well

    • Thanks for commenting Ajay.. Glad you liked it.. I looked for player level data, but couldn’t find a compiled data set anywhere

  • gary haas

    This makes my head hurt thinking of the possibilities.
    I have futbol die-hard friends and they are having kittens over this.

  • gary haas

    give a person a fish and he eats today, teach them to fish and they can feed themselves
    i thought it would take forever to discover your “magic”
    a little time and “like a blind man i picked up my hammer and saw”
    i will have to find time for your Dashboard course when i retire in at year-end
    the “magic” is simple and teachable

    • Thanks for commenting Gary.. Glad you like the dashboard.. This skill is easy to acquire. All you need is the right set of nuts and bolts (or hammer and saw if you prefer that)

  • Hi Sumit, excellent job! Looks great. The scroll bar is an inspired choice for navigating through the season. Out of curiosity, what part did you use the VBA for?

    • Thanks for dropping by Ben.. Glad you like the dashboard. I used VBA for 2 things:

      1. Update game stats when you double click on the game (from the list on the left)
      2. Show/Hide help when you click on the orange icon on the top right

  • Rob

    How easy is it possible to set this for 24 teams / 46 games??