[Cricket Results] – Royal Challengers Complete Chase in Final Ball

After the Royal Challenger’s potent batting lineup sleepwalked through large stretches of the UAE leg of the tournament, the short boundaries of their Chinnaswammy home stadium, enabled AB de Villiers to chase down Hyderabad’s total in the final over of their innings to snap their three match skid. By loading match data in SAP HANA we can create insight-laden graphics with SAP Lumira and SAP Crystal Reports to analyze RCB’s victory.


After losing Virat Kohli and Parthiv Patel in the second over and Chris Gayle finishing his productive yet short lived innings a few overs later, the Royal Challengers lingered well short of the required run rate for a large stretch of their innings. With SAP Crystal Reports we can create a worm chart that shows each team’s cumulative score after each balls and when precisely their wickets fell. The worm chart shows just how far off pace RCB’s run rate was through much of their chase and also emphasize the enormity of the two wickets Bangalore took in the final two overs of their attack. Entering the crease after Gayle’s dismissal, AB de Villiers, got off to a slow start but soon started to maul boundaries to every so slightly increase Bangalore’s runs per over rate, until he struck a final boundary on the second to last ball of the innings to collect a precious two points for his side.

Screen Shot 2014-05-05 at 2.47.37 PM.png

AB de Villiers absolutely rocked his fellow South African national, Dale Steyn, scoring 26 runs off of the 12 balls Steyn delivered to him including a 23 run over where de Villiers smashed a trio of sixes. With SAP Lumira we can create a pair of pie charts that shows the percentage of runs each bowler conceded in the match with a depth of the number of balls, wides, and no balls, they delivered to depict the bowling efficiency of each individual bowler. AB de Villiers dramatically elevated Steyn’s economy to 9.75 as Steyn’s gold slice is one of the largest for the Sunrisers. The small yellow slice in RCB’s pie chart belongs to Mitchell Starc, who bowled brilliantly for the Royal Challengers, conceding only 21 runs in the four overs he bowled while taking a pair of wickets.

Screen Shot 2014-05-05 at 2.56.22 PM.png

AB de Villiers’ amazing 89 runs no out performance saved the Royal Challengers’ chase and earned the right-handed batsman the Man of the Match honors. The South African faced only 41 balls and finished with a stupendous strike-rate of 217.07. With SAP Crystal Reports we can create a wagon wheel that shows the length and trajectory of each of the 30 run scoring shots de Villiers struck. The right-handed batsman struck six of his eight maximums forward with a variety of drive shots, and notched a pair of fours with beautiful reverse sweeps.

Screen Shot 2014-05-05 at 3.02.13 PM.png

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)

1085 Views