»Me, myself and BI«

Bissantz ponders


Data Mining with Rankings I

A while back I talked about the analytic power of simple rankings – or the iPod for data analysts as I like to call them. But did you know that a simple, sorted list can even make complex analyses easier to understand? Let’s take our Formula 1 example again. As a German who’s crazy about cars, I am pleased to see that my fellow countryman Michael Schumacher leads the list of world champions. When I sort the world champions by countries, however, we Germans only rank at #3, the Brazilians have a slight lead at #2, and the British are in a league of their own.

We can create these kinds of lists for all the dimensions available in our model, in this case: year, champion, #2, #3, nationality and constructor’s champion by team.


If we reviewed each list, we would see which factors have historically influenced the race for the Formula 1 title as well as which pilots, countries and teams have dominated the circuit – if at all.

The most important concept in data mining is autonomy. The computer should complete all of the mindless work for us – in this case, create the rankings and merge them into a single meta‑ ranking. The PowerSearch module in DeltaMaster does just that and produces the following results:

Powersearch simple

Our ranking of rankings shows that the UK has produced the best drivers in the history of F1 racing. British pilots have not only won the world championship the most times, but they have also placed second or third more times than those of other nationalities. Italy, or better said Ferrari, is the hands-down winner for the constructor championship.

Speaking of Ferraris, let’s shift our analytic expectations up another gear to explore the frequency of characteristic combinations. Stay tuned for more!

    Leave a response

    Friday, January 17th, 2014

    A subtle, yet bold statement

    Friday, November 22nd, 2013


    Friday, October 25th, 2013

    The electronic boss (2)

    Friday, September 27th, 2013

    The electronic boss (1)

    Friday, August 30th, 2013

    Is relative relatively irrelevant?

    Friday, August 2nd, 2013

    Self-Service BI: A problem or solution?

    Friday, July 5th, 2013

    Are control bodies out of control?

    Friday, June 7th, 2013

    Emotional Management Information

    Friday, May 10th, 2013

    Rationality needs emotional signals

    Friday, April 12th, 2013

    And you still can’t wrap a fish in an iPad

    »Me, myself and BI« Bissantz ponders