World Cup Dashboard 2014 – in 15 minutes

dashboard fifa

Are you caught in the World Cup craze? Two of my passions are English football and analytics (hence I’m a SE at Pentaho based in London). So when it came time for this years’ World Cup, naturally I combined my passions to analyse who is going to win and what makes a winning team?

It turns out that a Big Data Analytics team in Germany tried to predict the winners based on massive data sets. Thus far three of their top five predicted teams have faltered. So what went wrong? Is Big Data not accurate? Are analytics not the answer?

Fret not. Exploring their methodology, their analysis was based from only one source of data. At Pentaho, we believe that the strongest insights come from blended data. We don’t just connect to large data sets; we make connecting to all data easy, regardless of format or location.

So why is my little World Copa Dashboard different (pictured above)? Its simple, intuitive and quick to create using Pentaho to access and organize the information I wanted – taking only 15 minutes. Yes, raw data to dashboard in 15 minutes! Here is how I did it:

I took 2010 FIFA World Cup data in CSV format and turned it into three panels of information in a format I wanted to see. It was my view into the action. I wanted more information beyond the basic winners and loosers, rather the interest to look behind the scenes (such as how and why) about one of the most spectacular sporting events on the planet. With analytics, I wanted to explore the following questions:

  1. How did strikers compare in the final outcome?
  2. Across a team, how hard did they work?
  3. What was the strategic approach of the winning teams versus the most industrious ones?

Using Pentaho’s built in mapping features I could visualise the countries with the ‘busiest’ forwards. This told me something about the work rate of the formations that country’s manager/coach was using. I could see the efficiency of the forward position players.

leading forward players

With the pivot table I could conditionally format the table to give me an at-a-glance view of the teams with goalkeeping performance, individual defending and attacking maneuvers.

player stats

 

Embedding the Official FIFA website into my dashboard also gave me access to FIFA’s own ‘trending’ players of this tournament. I could see historic performance versus the latest information.

official FIFA

One of the most vital aspects of analytics is offering the information in the right context for the user. With the rich visualisations of Pentaho Analyser it was simple for me to divide up the teams into a scatter plot showing me which ones worked the hardest for the duration they were in the tournament and which balance took the successful teams furthest.

teamstats

In summary, I got a behind the scenes look at my World Cup data in four different visualisations all combined into one dashboard easily, quickly and efficiently using Pentaho User Console and I was able to prepare the data into a format of my choosing rapidly using Pentaho Data Integration.

Turn your data into your own personal viewpoint with the power of Pentaho Business Analytics 5.1.

GO ENGLAND…for the next World Cup, perhaps? ;)

Zaf Khan
Presales Engineer
Pentaho

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 96 other followers

%d bloggers like this: