[Cricket Results] – Knight Riders Complete Chase in Final Over

The Kolkata Knight Riders overhauled the Sunrises Hyderabad’s middling total in the final over to win their fourth straight match in a row and put themselves in the driver’s seat for postseason contention. The Knight Riders are the hottest team in the tournament as their bowling has been in great form and their big bats have been striking very well. By loading ball by ball match data into SAP HANA we can create insightful visualizations in SAP Lumira and SAP Crystal Reports to analyze KKR’s seven wicket victory.


With SAP Crystal Reports we can create a worm chart that shows each team’s score at every moment in the match and when each team’s wickets were taken. The Sunrisers started off with an excellent pace, but greatly floundered in the later half of their innings and scored only 34 runs on the last 36 balls they face. As evident in the visualization, Kolkata’s pace started off much slower than Hyderabad’s but with by consistently scoring overs near their frequently required run rate of eight, the Knight Riders’ successful chase rarely felt in doubt throughout their innings.

Screen Shot 2014-05-19 at 9.41.32 AM.png

Using SAP Lumira we can plot the number of runs each Knight Rider batsman scored per ball. As one can see in area chart, the run-scoring production was spread out rather evenly as Robin Uthappa (yellow), Manish Pandey (Green), Yusuf Pathan (Red), and Ryan ten Doeschate (Orange) all scored 25 or more runs for the Knight Riders. Uthappa added to league leading total of fours by sending five more balls to the boundary.

Screen Shot 2014-05-19 at 9.42.58 AM.png

We can show the match bowling efficiencies for KKR’s six bowlers with SAP Lumira by creating a pie chart of the percentage of runs they conceded and adding a depth of the number of balls, wides, and no balls they delivered. Umesh Yadav was honored as the man of the match, as the right armed medium-fast Indian national took three wickets and finished his four overs with an impressive economy of 6.50. Sunil Narine, shown in green below, had another great performance as he took a wicket and finished with a match best economy of 5.25.

Screen Shot 2014-05-19 at 10.01.45 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)

1176 Views