Vasanth Naib's Blog

Previous post Next post
Currently Being Moderated

Am blogging this from Teched 2012, Bangalore.

 

My experience so far:

 

Downloaded the software from: http://scn.sap.com/docs/DOC-31008

 

sapvisualintelligence.PNG

 

Then, Installed the SAP Visual Intelligence, very intuitive.

Activated a trial version.

 

Bingo, installed in five minutes.

 

Which Data to use for visualization?

 

Cricket being my favorite sport. I wanted to see what I could see.

I scraped data of test match results from 1990s till current date.

 

I pulled the csv to sap visual intelligence.

 

The simple question I tried to answer was.. Will India win in 3rd test match against England in Kolkata? Knowing the history one can safely say(bet) on the team which could win!

 

Step 0: My data set contained the following:

 

Winner,Result,Margin,Match,Place,Date

New Zealand,won,9 wickets,New Zealand v Australia,Wellington,15-Mar-90

,draw,-,West Indies v England,Port of Spain,23-Mar-90

West Indies,won,164 runs,West Indies v England,Bridgetown,5-Apr-90

West Indies,won,inns & 32 runs,West Indies v England,St John's,12-Apr-90

,draw,-,England v New Zealand,Nottingham,7-Jun-90

,draw,-,England v New Zealand,Lord's,21-Jun-90

.

.

.

.

India,won,9 wickets,India v England,Ahmedabad,15-Nov-12

Sri Lanka,won,10 wickets,Sri Lanka v New Zealand,Galle,17-Nov-12

West Indies,won,10 wickets,Bangladesh v West Indies,Khulna,21-Nov-12

,draw,-,Australia v South Africa,Adelaide,22-Nov-12

England,won,10 wickets,India v England,Mumbai,23-Nov-12

,-,-,Sri Lanka v New Zealand,Colombo (PSS),25-Nov-12

 

 

 

Step 1: Who has dominated the test cricket from 1990s to current? We can see that WestIndies decline had already started.

countryvsvictory.PNG

country_date_victory.PNG

 

 

Step 2:  Having ascertained that. In which ground did each country fare well. For this I needed a HEAT MAP

 

winnerheatmap.PNG

Not quite intuitive. But, one can imagine this is just a heat map. But, interestingly, by placing filters one could change the graph types.

A very nice slicing and dicing options in SAP visual intelligence.

 

Step 3: England looks like have a strong field in the heat map.

england_heatmap.png

 

Step 4: Who all won in Lords apart from England?

 

lords.png

Step 5: What about India? where is the heat map of India showing? It is Kolkata! it's strictly India's strong hold. Nobody can win easily in Kolkata for India. Let's see what the SAP Visual Intelligence shows:

 

kolkata.PNG

 

Step 6: What can we predict for the 3rd test match between India and England in 2012 in Kolkata?

India will win ... as per the history. .This is what SAP Visual Intelligence enables you.. to predict the future by enabling easy and intuitive analysis of past data!

 

Step 7: Wait a mintue! What happened in Mumbai? i.e. 2nd test between India and England? What did the records say?

 

mumbai.PNG

 

For all you know India should have won, but the predictions went wrong. This is a classical case of missing DIMENSIONS to predict the future. Now, for Kolkata can we get the dimension which was missing in Mumbai and predict more accurately?!!

 

Conclusion:

 

With SAP Visual Intelligence, I could download a light weigh Visual analysis tool and run CRITICAL ANALYTICS and derive important inference out of it. Definitely a handy tool!

 

Cheers

Vasanth

Comments

Actions