Wankhede Stadium will host the biggest match of the 7th Indian Premier Twenty20 tournament’s knockout stage when the Mumbai Indians and the Rajasthan Royals clash with the final playoff spot on the line. Rajasthan is through with a win, while Mumbai will have to win convincingly to make up the .333 difference in net run rate to leap past the Royals. Losers of their first five matches, the defending champions have shown great resilience to revitalize their campaign but they will most likely have to put up a target of 220 or chase down a middling total in a dozen overs to enter the eliminator playoff match. Find out how Mumbai crushed Rajasthan earlier this week and see how these sides faired against each other last season. By loading ball by ball match data into SAP HANA we create insight-laden visualizations with SAP Lumira and SAP Crystal Reports to preview tonight’s epic showdown.
With SAP Lumira we can create a pair of pie charts that show the percentage of team batting runs that each Indian and Royal batsman has scored this season. Both club’s offensive production is fairly spread out as seemingly in nearly every match one batsman will emerge for each team for a big innings. Mumbai’s Skipper, Rohit Sharma, is the leading scorer for the Indians with 353 runs. Ambati Rayudu, Lendi Simmons, and Kieron Pollard have each excelled in matches and have scored more than 250 runs this season. Ajinkya Rahane’s 339 runs leads all Royals in scoring, and Karun Nair, Sanju Samson, and Shane Watson each have decently sized slices in Rajasthan’s pie.
By making a few adjustments to our parameters we can can create a 3D bar chart that shows the number of four and sixes that each Mumbai and Rajasthan batsman has scored through the first 13 matches of the tournament. Rahane and Nair have each hit over 30 fours but have failed to send balls over the rope as they have only three and seven maximums respectively. Sanju Samson, Shane Watson, and James Faulkner have hit the most sixes for Royals. Sharma, Pollard, and Simmons have each mauled double-digit maximums during Mumbai’s innings. Simmons, the only batsman to score a century this tournament, has smashed 35 fours in only six matches. If Mumbai hopes to greatly elevate their run rate they will likely need another phenomenal performance from Simmons.
Mumbai’s Harbhjan Singh has been one of best bowlers in the entire tournament as the right-handed off-spinner’s 6.08 economy is the second best for bowlers who have delivered more than 8 overs of balls. With SAP Crystal Reports we can break down many of Singh’s bowling statistics by line and length of delivery to see which deliveries have been most effective for the Indian National. Singh regularly bowls with an outside off line as he has recorded a dot on over 40 percent of those deliveries and has only conceded one maximum from an outside off ball. Singh’s middle stump balls have also been excellent as he has posted an economy of 5.49 when bowling straight down the wicket.
Consistently Singh’s best balls have been middle stump length balls, where he has either recored a dot, taken a wicket, or conceded a single on over 90 percent of those deliveries. Over a quarter of Singh’s balls have been outside off length balls where he has recorded a dot on 47.3 of those 74 tosses and posted an economy of 4.94. Check out the attached PDF for even more insights on Singh’s bowling.
Can Singh stump Rajasthan’s batsman and Simmons batter their attack enough for Mumbai to miraculously earn the final playoff spot?
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.
SAP HANA Academy