The Royal Challengers Bangalore will host the Delhi Daredevils in Chinnaswamy Stadium tonight in the 38th match of the 2014 Indian Premier Twenty20 tournament. Bangalore’s once promising season has been derailed by three consecutive defeats, and even though RCB is currently in seventh place in the table they fortunately only sit two points behind the the Knight Riders for the final playoff position. The Daredevils are having yet another disappointing season as they currently sit at the bottom of the table with only two wins in their nine matches and come into this match riding a four game winless streak. Read about how Bangalore easily overhauled Delhi’s total earlier this season in Sharjah and discover how the teams faired against each other in last season’s clashes. By loading ball by ball match data into SAP HANA we can create insight-laden visualizations of Bangalore’s and Delhi’s tournament with SAP Lumira and SAP Crystal Reports to preview tonight’s matchup.
With SAP Lumira we can create a pair of bar charts that visualize the number of runs each team’s batsmen have scored this season. In teal blue below is the 284 runs of Delhi’s leading scorer, JP Duminy. Dinesh Karthik’s 232 runs is in magenta below and his is the only other Daredevil to exceed 200 runs. Bangalore’s leading run scorer is their South African wicketkeeper AB de Villiers, who’s 282 runs is in blue below in the Royal Challengers’ chart. Bangalore’s all-rounder Yuvraj Singh, in peach below, has also been productive in the crease this season by scoring 227 runs. After missing the first four matches of the season, Bangalore’s powerful opening batsmen, Chris Gayle has yet to really have any sustainable innings as his total in orange below is only 108 runs.
By creating a pair of pie charts that depicts the percentage of bowling runs conceded by each bowler and the number of balls, wides, and no balls, they have delivered we can visualize the bowling efficiency for each bowler. The large orange slice belongs to Mohammed Shami and the 271 runs he has conceded is one of the highest totals for any bowler this tournament. While the 33 overs Shami has bowler have earned him a respectable economy of 8.27, the right arm medium speed bowler has only taken four wickets and thus has a large bowling average of 68.25. Yuzvendra Chahal has been arguably Bangalore’s most effective bowler as evidenced by the light pink slice in the Royal Challengers’ pie below. Chahal has only conceded 208 runs in the the 35 overs he has bowled and is one of just four bowlers with a sub 6.00 economy.
With SAP Crystal Reports we can dive much further into Chahal’s bowling by creating an in-depth grid of his economies, strike rates, and bowling averages broken down by the length and line of his deliveries. Chahal has been very efficient when tossing balls with a middle stump and off stump line. 31.9 percent of his 60 middle stumps balls have resulted in dots and has earned him an economy of 5.70 in that line. When delivering his 90 balls with an off stump line Chahal has conceded only a pair of sixes and has posted an economy 5.80.
Chahal has struggled a bit with half volley deliveries as three out of the 18 balls he has delivered with a half volley length has been sent skying beyond the rope and has given him a high economy of 10.0. A lion’s share of the right-arm leg spinner’s deliveries have been very effective length balls. When tossing length balls Chahal has posted a staggeringly low economy of 5.20 and has taken wickets on 6.3 percent of those tosses for impressive an impressive strike rate of 16.0 and a laudable bowling average of 13.8. Check out the full PDF of Chahal’s bowling grid attached at the bottom of this post.
Can Chahal’s effective length balls flummox the Daredevils and help Bangalore snapped their losing streak?
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.
SAP HANA Academy