Brabourne Stadium in Mumbai will host the Eliminator match between the Mumbai Indians and the Chennai Super Kings this evening. After starting the season 0-5, the Indians had a miraculous turnaround to earn 14 points and defeat the Royals on the last possible ball to overtake their net run rate. For most of the tournament the Super Kings occupied one of the top two positions in the table but a late three match losing streak dropped Chennai into third place. After defeating the Super Kings in last season’s final, the Indians have failed to beat Chennai this season. Find out how the Super Kings overhauled Mumbai’s total in Dubai and see how Chennai snapped Mumbai’s nine match home winning streak. By loading ball by ball match data into SAP HANA we can create insight packed visualizations with SAP Lumira and SAP Crystal Reports.
With SAP Lumira we can create a pair of pie charts that show the number of runs each Super King and Indian batsman scored in the knockout stage of the tournament. In lime green below is Dwayne Smith’s 535 runs, which was good for the second highest aggregate score in the tournament. Smith has formed excellent opening partnerships with both Brendon McCullum (peach) and Fuf de Plessis (yellow). Suresh Raina and Skipper, MS Dhoni have both scored more than 325 runs for the Super Kings. Mumbai’s Rohit Sharma (violet), Ambati Rayudu (green), and Lendi Simmons (gold) have each scored more that 300 runs during their innings. Only appearing in seven matches, Simmons has been a huge spark for the Indians’ lineup in the later half of the season as he is the only batsman to scored a century in 2014.
After creating a geographic hierarchy of bowling team region we can quickly depict the percentage of runs the Indians’ and the Super Kings’ bowlers have conceded via boundaries. The Super Kings’ bowlers have conceded 1,236 of their 2,129 runs via boundary shots while the Indians have conceded a slightly lesser percentage of their 1,927 runs from boundary shots. The Indians’ lineup should look to exploit Chennai’s propensity to conceded boundary shots.
With SAP Crystal Reports we can create a graphic that compares the economies of Mumbai’s best bowler, Harbhajan Singh, and the strike-rates of Chennai’s best batsman, Dwayne Smith, broken down by different combinations of the lines and lengths of balls they have delivered and faced. With one of the best economies in the tournament, Singh should focus on delivering middle stump and leg stump length balls if he faces Smith early in Mumbai’s attack as Singh has held batsman to less 4.50 runs per six balls he has bowled with those line and length combinations and Smith has sub 72.0 strike rates against those tosses.
Can the defending Champions extend their miraculous run? Or will Dhoni carry his Super Kings into the second qualifier?
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