After clinching a playoff spot with their latest victory, the Kings XI will seek to secure a spot in the initial qualifier when they host the struggling Mumbai Indians this evening. Kings XI will be seeking redemption as one of their two defeats this season came at the hands of the then winless Indians. See how Mumbai defeated Punjab earlier this month and discover how the teams fair against each other last season. By loading data from this season’s Indian Premier Twenty20 tournament into SAP HANA we can build insight-laden visualizations in SAP Lumira and SAP Crystal Reports to preview tonight’s showdown.
With SAP Lumira we can create a pair of donut charts that show the percentage the team’s runs each individual batsman has scored. Currently, wearing the Orange Cap as the tournament’s top run scorer, is the Kings XI’s Glenn Maxwell, who’s staggering 531 runs are visualized below in the large pale yellow section. Maxwell’s sudden emergence has been the talk of the tournament as his innings have dazzled crowds across the subcontinent and the UAE. With his grip on the Orange Cap slowing slipping away, Maxwell hopes he can maul many boundaries tonight against his former team and lead the Kings XI towards evening the season series. The Indians’ lineup is lead by Ambati Rayudu and Rohit Sharma, who’s respective 310 and 306 runs are depicted below in yellow and light purple slices.
By making a few simple modifications we can transform our visualization into a set of bar charts that show the number of boundaries each individual batsman has struck this season. Currently, Glenn Maxwell’s 35 maximums leads the tournament and his pale yellow bar towers above all of the bars that shows Mumbai’s batsman maximums and even fours. Maxwell’s 46 fours is the second highest total in the league and his teammate, Virender Sehwag’s 37 fours, shown in orange, also looms very prominently in the visualization. Only Sharma and Rayudu have managed to strike more than 20 fours this season and only Sharma and Kieron Pollard have managed to maul a double digit total of maximums for the Indians. Abundantly clear from this visualization is Kings XI’s propensity to take chances and swing for powerful shots.
With SAP Crystal Reports we can create an very informative graphic that shows the economy, strike rate, bowling average, and percentage of various results for each ball a bowler delivers with certain line and length combinations. With this graphic we can dive into the numbers of one of Mumbai’s top bowlers, Harbhajan Singh, who claimed the prized scalp of Maxwell in their previous clash. Singh has been one of the most consistently effective bowlers throughout this tournament as his 5.95 economy is the lowest for any bowler who has delivered more than 10 overs. The right armed off-spin bowler delivers a vast majority of his balls balls with an outside off line. Singh records a dot on over 40 percent of those deliveries and has only conceded a single maximum. Singh isn’t as effective with off stump delivers as those result in a boundary 15.5 percent of the time and he has an uncharacteristically high bowling average of 74.
A vast majority of Singh’s tosses are length balls as they are incredibly effective for him as he records a dot on 45 percent of those deliveries. Singh’s best combinations have been outside off and middle stump length balls as he has economies of 4.73 and 4.50 respectively when delivering those tosses. For even more insights on Singh’s awesome bowling performance this season check out the attached bowling grid.
Can Singh scalp Maxwell again and hopefully early to help play spoiler for Kings XI’s pursuit of one of the top two positions? Or will the Kings XI redeem their earlier defeat to the delight of the Punjab faithful?
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