[Cricket Match Preview] 53rd Match – Royal Challengers Bangalore V Chennai Super Kings

The recently eliminated Royal Challengers Bangalore will conclude their 2014 campaign by hosting the Chennai Super Kings. Loser of their previous three matches, the Super Kings will be even hungrier for a win this afternoon as a place in the first qualifier is within their grasps. Discover how Bangalore overhauled the Super Kings in Ranchi earlier this week and see how the teams faired against each other last season. By loading ball by ball match data into SAP HANA we can create informative visualizations with SAP Lumira and SAP Crystal Reports to preview tonight’s match.


With SAP Lumira we can create bar charts that show the number of fours and sixes that the Super Kings’ and Royal Challengers’ batsman have struck so far this season. Super Kings’ Dwayne Smith, in yellow below, has smashed 42 fours and his 33 sixes are greater than any total amounts of fours that any Royal Challengers have hit. Aside from Yuvraj Singh and AB de Villiers, the Royal Challengers have struggled to hit maximums.

Screen Shot 2014-05-23 at 10.00.41 AM.png

By creating a geographical hierarchy for each batting team’s region we can show the percentage of runs each team’s bowlers have conceded via boundaries this season. The Royal Challengers’ bowlers have conceded 1,045 of their runs from boundaries vs 912 non boundary runs. The Super Kings have conceded 58.7 percent of their runs via boundaries as their bowlers have given up 1,160 boundary runs and 817 non boundary runs.

Screen Shot 2014-05-23 at 10.09.50 AM.png

With SAP Crystal Reports we can examine bowling statistics for the Super Kings’ most consistently efficient bowler, Ravichandran Ashwin, broken down by line and length of delivery. Ashwin’s economy rate of 6.98 is the best for all of the Super Kings’ bowlers that regularly bowl. Ashwin has been tremendous when delivering balls with a middle stump line, as nearly 90 percent of his middle stump tosses have resulted in either a dot or a single, for an excellent 5.23 economy.

Screen Shot 2014-05-22 at 10.11.35 PM.png

A vast majority of Ashwin’s 287 balls have been length balls. Ashwin has an economy of 6.62 from his 210 length balls and has had a lot of success will off stump and middle stump lines but has been struck rather hard when tossing length balls to the leg side. The spinner has conceded boundaries on over 20 percent of his leg stump and outside leg length ball deliveries whilst his outside off, off stump, and middle stump length balls have been sent for boundaries in less than nine percent of his tosses.

Screen Shot 2014-05-22 at 10.13.20 PM.png

Will Chennai win and make a Kingly first qualifier? Or will the Royal Challengers send their fans off with victory?


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.

Check out all of the Indian Premier Twenty20 Match by Match Analysis here.


-Tom Flanagan

SAP HANA Academy

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

618 Views