[Cricket Match Preview] – 40th Match – Critical Mid-Table Tango – Kolkata Knight Riders V Mumbai Indians

The 40th match of the Indian Premier Twenty20 tournament will be a decisive battle in the pursuit for the fourth and final playoff spot when the Kolkata Knight Riders clash with the Mumbai Indians in Cuttack. Both clubs are in the midsts of disappointing sub .500 seasons with Kolkata having one more win than Mumbai. A win today could very easily turn out to be a deciding factor in if either of these team sneak into the final playoff spot. See how Kolkata easily defended their total in the season’s opening match in Abu Dhabi and discover insights on how the teams competed against each other last season. After loading ball by ball match data into SAP HANA we can create informative graphics in SAP Lumira and SAP Crystal Reports to preview tonight’s match.


In SAP Lumira we can create a pair of horizontal line charts that show the number of batting runs each team’s individual batsman have scored through nine matches this season. Robin Uthappa, in peach below, is Kolkata’s and the match’s leading run-getter with 302 runs. Gautam Gambhir and Manish Pandey, in blue and gold respectively below, have both scored in excess of 200 runs for the Knight Riders. Mumbai’s highest run-getter is Ambati Rayudu, who’s 277 runs are shown in green below.

Screen Shot 2014-05-13 at 1.01.44 PM.png

By applying a few filters in SAP Lumira we can create a pair of pie charts to comparing the the bowling efficiency of each individual bowler by showing the percentage of runs each bowler has conceded and adding a depth of the number of balls, wides, and no balls they have delivered. The dark orange slice of KKR’s pie belongs to Shakib Al Hasan, who’s 6.08 economy from 23 overs is currently has the 4th best economy in the tournament. KKR’s large magenta slice belongs to their ace and work horse bowler, Sunil Narine, who has an economy of 6.36 and has taken 13 wickets in the 36 overs he has bowled. The tall blue and gold slices of Mumbai’s pie belong to Lasith Malinga and Harbhajan Singh who have both posted impressive economies, strike rates, and bowling averages.

Screen Shot 2014-05-13 at 1.06.19 PM.png

By connecting our data in SAP HANA to SAP Crystal Reports we can examine Latish Malinga’s bowling with detailed granularity. Malinga has been quite effective tossing outside off stump deliveries, as he has posted an economy of 5.43 from 50 deliveries with that line. Malinga has taken a decent percentage of his 15 wickets from off stump deliveries as he has an impressive 9.83 strike when tossing off stump balls.

Screen Shot 2014-05-13 at 1.10.48 PM.png

Maligna has excelled when tossing yorkers and length balls so far this tournament, posting minuscule economies of 4.56 and 5.43 respectively when delivering 56 balls each with those lengths. Maligna has struggled when tossing this 48 half volleys by posting a large economy of 8.87 and conceded boundaries on 23 percent of those deliveries. However, the right-arm fast bowler will most likely continue to bowl half volleys as those net him a scalp every 6.85 tosses.

Screen Shot 2014-05-13 at 1.12.22 PM.png

Who’s stud bowlers will turn the tide with timely wickets in tonight’s mid-table tussle?

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)

827 Views