[Cricket Results] Mumbai Through to Playoffs on Dramatic Final Ball

An empathic six on the final ball of their innings elevated the Mumbai Indians’ net run rate over the Rajasthan Royals to snag the 4th and final spot from the Royals. After their attack conceded 189 runs, the Indians were tasked with overhauling the lofty target in 14.3 overs. With the match even after the 14.3 over, the Indians needed a four and got a six to earn the opportunity to defend their title. By loading ball by ball match data into SAP HANA we can create insightful visualizations to profile Mumbai’s amazing victory.


With a few clicks in SAP Lumira we can quickly create a Manhattan chart that shows the number of runs each team scored per over. Mumbai’ attack greatly restrained the Royals’ lineup in the first half of their innings holding them to 59 for 1 through 10 overs. However, the Royals exploded in the later half of their innings, scoring 12 or more runs in 8 overs and 46 runs off of the final 18 balls. With a massive target and limited number of balls to overhaul it, the Indians lineup started sending balls to the boundaries in a hurray and reached the half century mark by the 4th over. After a dismal four run 7th over, Mumbai scored 83 runs on the next 30 balls and smashed their way to a five wicket victory.

Screen Shot 2014-05-27 at 8.20.11 AM.png

With SAP Lumira we can plot the number of runs the Indian batsmen scored per ball with an area chart. After Lendi Simmons had a productive but brief innings it was time for the Corey Anderson show. In yellow below is Anderson’s unbeaten 95 runs on 44 balls. With 15 boundaries Anderson rocketed the Indians to the target and then Aditya Tare send the Wankhede faithful home happy with a massive playoff clinching six.

Screen Shot 2014-05-27 at 8.23.28 AM.png

Corey Anderson’s massive innings earned the Kiwi southpaw the Man of the Match honor. With SAP Crystal Reports we can create a wagon wheel that shows the line, length and result of Anderson’s 35 run scoring shots. Anderson struck a good majority of his shots forward and three of his nine fours and one of his six maximums were sent to the barrier with straight drives.

Screen Shot 2014-05-27 at 8.47.58 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)

830 Views