[Cricket Results] – Knight Riders Overhaul Kings XI

The Kolkata Knight Riders clinically chased a middling Kings XI Punjab total to win their second consecutive match and hand the Kings XI only their second defeat of the season. This massive nine wicket win in Cuttack has lofted the Knight Riders into playoff contention and showed that they can compete with the cream of the Indian Premier Twenty20 crop. By loading ball by ball match data in SAP HANA we can create informative visualizations in SAP Lumira and SAP Crystal Reports to analyze the Knight Riders’ big win.


With SAP Crystal Reports we can create a worm chart that shows each team’s exact score at any point in the match and when their wickets were taken. After conceding 17 runs in the first over, the Knight Riders’ attack took a wicket and begin to really stymy the Kings XI’s lineup. The Knight Riders only conceded two maximums and besides a swift 72 runs from Virender Sehwag, held the other members of Punjab’s potent to 15 or less runs a piece and pinned the Kings XI to a total below 150 for only the second time this tournament. After a steady start to their innings the Knight Riders found a nice grove and cruised to a successful overhaul in only 108 balls while only losing one wicket.

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

With SAP Lumira we can plot the number of runs each Knight Rider batsman scored during their innings. The Knight Riders only needed three batsmen to overhaul the Kings XI’s total of 149, with each batsman scoring more than 35 runs and finishing with strike rates above 100. Note the frequent boundaries that Robin Uthappa in yellow, Gautam Gambhir in blue, and Manish Pandey in green, stuck below, especially the streak of nine boundaries that Uthappa and Gambhir hit in a 15 ball spree in between the 2nd and 5th overs.

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

Gautam Gambhir was KKR’s leading scored and his unbeaten 63 runs on 45 balls innings earned the left handed top of the order batsman the Man of the Match honor. With SAP Crystal Reports we can show the length, trajectory, and result of each of Gambhir’s 35 run scoring strikes. Gambhir only hit one single forward as the rest of his shots were sprayed to either his left or right. Gambhir frequently pulled his shots to his right with two for his seven boundaries coming from strikes in that direction.

Screen Shot 2014-05-16 at 11.25.48 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)

638 Views