[Cricket Results] – Royals Swift Six Wickets Swipe Points from KKR

With their opening partnership still intact and needing only 50 runs from the final 6 overs the Knight Riders appeared to be well on their way to overhauling the Royals’ total of 170 runs at Sardar Patel Stadium in Motera. However, back to back single over scalping hat tricks from Shane Watson and Pravin Tambe severely derailed KKR’s chase and stemmed the tide in the Royal’s successful defense. By loading match data into SAP HANA we can create insightful visualizations with SAP Lumira and SAP Crystal Reports to analyze how Rajasthan won.


With SAP Crystal Reports we can create a worm chart shows each team’s cumulative score per over and when exactly each of their wickets were taken. As evident from the chart, by the middle of their chase, the Knight Riders were beginning to noticeably elevating their score above the Royals’ pace until the dramatic 15th and 16th where they lost more wickets, six, then they scored runs, five to nearly flat line their chase. From that point on the snake bitten Knight Riders could only muster a pair of boundaries as their unsuccessful chase sputtered out in the final few overs.

Screen Shot 2014-05-06 at 11.53.15 AM.png

Using SAP Lumira we can plot the number of runs each Rajasthan batsman scored during the match. The first four Royals’ batsman of the match, Ajinkya Rahane, Karun Nair, Sanju Samson, and Shane Watson, in blue, yellow, red and purple respectively below, all scored 30 or more runs to provide a great foundation for Rajasthan’s innings. The four struck 10 fours and mauled four maximums.

Screen Shot 2014-05-06 at 12.01.24 PM.png

Pravin Tambe’s defense preserving wicket hat-trick earned the right handed legbreak bowler the Man of the Match honor. With SAP Crystal Reports we can create a graphic that shows the line, length, and result of each of his 24 deliveries. Tambe took his three wickets on connective balls with an off stump yorker, a middle stump half volley, and a leg stump length ball. Tambe finished his four overs with an economy of 6.50.

Screen Shot 2014-05-06 at 12.06.01 PM.png

By swapping in Royals’ Skipper, Shane Watson, as the bowler we can quickly show how Watson earned his wicket hat-trick in the over before Tambe. All three of Watson’s scalps were from length balls as well as seven of his 10 dots. Watson finished the match with an impressive economy of 5.25.

Screen Shot 2014-05-06 at 12.07.01 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.

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)

926 Views