[Cricket Results] – Royals Stun Bangalore with Massive Final Overs

A flurry of boundaries in the final few overs of the Rajasthan Royals’ chase suddenly grasped what had for so much of the second innings appeared to be a successful Royal Challengers defense of their formidable target, snatched a vital two points for the Royals and devastated the Bangalore faithful in the return match of this year’s battle royal. Steven Smith and James Faulkner destroyed the poor form of the Royal Challengers’ late bowlers to steal a crucial victory in the race for the postseason positioning. By loading ball by ball match data into SAP HANA we can create insight-laden visualizations in SAP Lumira and SAP Crystal Reports to analyze Rajasthan’s exciting victory.


With SAP Lumira we can create a Manhattan chart that shows the number of runs each team scored per over in the match. The Royal Challengers got out to a very slow start, scoring only six runs in their first 18 balls and completing the 10th over with a run rate of 5.70. Bangalore’s bats came to life in the final overs, scoring 10 or more runs in each of them to push their total to 190. After a decent start to their chase, the Royals’ lineup began to sputter out, finishing the 16th over at 125 for 5 with a required run rate of 16.25. Then Smith and Faulkner came exploded for the required 65 runs in a frantic 17 ball massacre.

Screen Shot 2014-05-16 at 11.33.20 AM.png

By making a few modifications in SAP Lumira’s intuitive interface we can plot the number of runs each Royal batsman scored per ball during their innings. Rahane and Nair, in blue and yellow respectively in the area chart below, established the chase’s foundation with nine fours in the first eight overs and their power was severely missed after their dismissals. A fact clearly evident from the lack of boundaries in the middle of the chart. Note the heroic furry by Smith and Faulkner at the end of the innings, shown in purple and green respectively below, as the pair combined for 14 boundaries in the match and each finished with strike-rates north of 200. Faulkner’s 41 runs on 17 balls earned the Australian all-rounder the Man of the Match honor.

Screen Shot 2014-05-16 at 11.37.16 AM.png

Yuvraj Singh was an absolute force for Bangalore, roasting the Royals’ attack for 83 runs on 38 balls and taking four wickets during his 24 deliveries. With SAP Crystal Reports we can dive into Singh’s tremendous performance by creating a Wagon Wheel that shows the length, trajectory, and result of each of his 26 run scoring shots. The Indian Southpaw struck a majority of his shots to his right, including a set of four fours that he swept behind him. Unfortunately for the Bangalore crowd, Singh’s impressive all-round display was all for naught.

Screen Shot 2014-05-16 at 11.40.04 AM.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.

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)

598 Views