Premier League Game Changer

I wanted to build an app for demo purposes that shows how you can conduct What If analysis in Qlik Sense, I just needed a theme…

It isn’t really that long ago since Jimmy Hill introduced the the 3 points for a win system to English football in 1981 in an effort to encourage attacking play and tackle the issue dwindling crowds.  Big hitters like Germany, Spain, Brazil and Argentina didn’t introduce the system until as recently as 1995.  Nowadays it’s hard to think that teams only got 2 points following victory.  Some pundits have argued that it actually stifled attacking play; causing teams that went 1-0 ahead to “park the bus” and protect their precious points.

Continue reading “Premier League Game Changer”

Premier League Points – How to Get a Heap of Analysis From Even the Smallest of Data

This blog post started as one thing and ended up another, but I’m actually glad it did.  I set out with the intention of using a range of Premier League data to examine Qlik Sense Chart chart types and best practices.  However, after coming up with a list of around 20 different measures off the back of just the first 4 columns I decided it would be interesting to see what Qlik Sense can do with even the smallest of data sets.  With just 4 columns; Club Name, Season, Position and Points, there’s enough to take you wherever your mind dares and Qlik Sense provides the tools to put your thoughts onto screen.  The tools are not just the visualisations but the ability to rearrange and aggregate data within your front end calculations; in the forms of set analysis, aggr() and firstsortedvalue() functions.

Continue reading “Premier League Points – How to Get a Heap of Analysis From Even the Smallest of Data”