[Cricket Match Preview] – 37th Match – Table Toppers Clash – Chennai Super Kings V Rajasthan Royals

Two of the tournament’s three top teams will battle for likely playoff positioning on Tuesday afternoon in Ranchi. Besides the Kings XI Punjab, the Chennai Super Kings haven’t dropped any points this season with every one of their victories coming in rather convincing fashion. The resilient Royals have emerged victorious in many close matches this season, including recently chasing down a staggering RCB total by netting the necessary final 65 runs in only three overs. Discover how the Super Kings shot out the Royals in a win early this year in Dubai and find out how the sides faired against each other last season. By loading match data in SAP HANA we can create informative graphics about Chennai’s and Rajasthan’s performances this season in SAP Lumira to preview this afternoon’s showdown.


With a few simple clicks in SAP Lumira’s intuitive interface we can create a pair of pie charts that depict the percentage of runs each Super King and Royal have scored for their respective teams this tournament. The Super Kings have scored the second highest amount of runs as a team so far this tournament and are lead by the destructive duo of Dwayne Smith and Brendon McCullum. Smith, in teal blue below, has netted 396 runs while his frequent partner, McCullum, in beige below, has scored 327 runs. Combined both have scored over half of Chennai’s batting runs this tournament. Ajinkya Rahane is Rajasthan’s leading scorer and his green slice below is the only one in the Royals’ chart to represent a total greater than 200 runs.

Screen Shot 2014-05-12 at 9.02.59 AM.png

By swapping fours and sixes for batting runs and switching to a bar chart we can quickly see how many boundaries each player has struck so far this season. It’s really no surprise that Smith and McCullum lead the Super Kings in fours and sixes as each has mauled 30 or more fours and Smith has struck 27 maximums. Rahane has send 28 deliveries to the field limit yet he has only managed to send a pair of balls over the boundary. Sanju Smason and Royal’s Skipper, Shane Watson, lead the Royals with with 10 sixes a piece.

Screen Shot 2014-05-12 at 9.12.43 AM.png

If we switch the filter from batting team to bowling team and swap out a few measures and dimensions we can quickly create a graphic that shows the bowling efficiency for each individual bowler on the Royals and the Super Kings. In SAP Lumira we can depict a bowler’s efficiency by creating a pair of pie charts that show the percentage of team runs each bowler has conceded with a depth of the number of balls, wides, and no balls they have tossed. The slice in pale yellow below in the Super Kings’s pie chart belongs to Mohit Sharma, who while conceding a rather substantial number of runs and entering the match with an economy of 7.88 has also been a wicking-taking force. Sharma’s 15 wickets and decent bowling has currently earned him the second best strike rate in the tournament. Pravin Tambe, in violet below, has been Rajasthan’s most effective bowler, as the right-armed leg spinner has earned an impressive 6.58 economy while bowling the maximum possible number of overs in every match.

Screen Shot 2014-05-12 at 9.19.55 AM.png

Can Tambe and the rest of the Royals’ attack contain Chennai’s dangerous duo of Smith and McCullum?


Keep your eyes peeled for more visualizations created in SAP Lumira using historical Indian Twenty20 data from SAP HANA. Please check back regularly during the tournament for more insights about the daily action. Also, watch out for a series of tutorial videos on how we load the data into SAP HANA.


SAP HANA Academy – over 500 free hands-on tutorial videos on using SAP HANA.


-Tom Flanagan

SAP HANA Academy

VN:F [1.9.22_1171]
Average User Rating
Rating: 0.0/5 (0 votes cast)

1029 Views