In an electrifying runfest the Kings XI’s attack shakily but successfully defended their lofty 226 run total to advance to the 7th Indian Premier Twenty20 tournament final against the Knight Riders on Sunday. Punjab’s veteran opening batsman, Virender Sehwag, posted the highest score of the entire tournament to lead Punjab to their third total above 200 runs against the Super Kings this season. By loading ball by ball match data into SAP HANA we can create insight-laden visualizations with SAP Lumira and SAP Crystal Reports to analyze Punjab’s 24 run victory.
With SAP Crystal Reports we can create a worm chart that shows each team’s exact score at any point in their innings and when their wickets were taken. The Kings XI started their innings with a 110 run 64 ball partnership between Virender Sehwag and Monan Vohra. After Maxwell tacked on a pair of boundaries in his brief innings the Kings XI didn’t loss another wicket until the 19th over and finished with an impressive 226 run total. After losing a wicket in the first over, Suresh Raina put on a dazzling display of power by striking 18 boundaries in only 25 balls to lift the Super Kings to 100 for 2 after six overs. However, Raina was run out on the next ball and as clearly evident in the chart, the Super Kings scoring pace steered horizontally. After dropping three wickets in the 12th and 13th overs the Super Kings feel below Punjab’s pace. A lack of boundaries caused Chennai’s asking rate to soar to over 20 and then 40 runs in their final overs.
With SAP Lumira we can plot the number of runs each Kings XI batsman scored per ball during their innings. Sehwag amazing 122 runs on 58 balls performance is displayed in purple below. Sehwag hit 20 boundaries and had a nice 6, 4, 6, three ball string to cap the end of his innings. Glenn Maxwell in yellow, and David Miller in blue, each finished with strike-rates over 200 and Manan Vohra, in orange, added 34 runs. Note the 32 boundaries that Punjab bashed off of Chennai’s attack.
With SAP Crystal Reports we can dive even further into Sehwag’s spectacular innings by creating a wagon wheel that shows the line, length, and result of each of Sehwag’s 44 run scoring shots. Sehwag struck four of his eight maximums with lofted drives and launched five of his boundaries with beautiful reverse sweep shots.
Facing a tasked that has never been completed in Twenty20 Cricket history, overhauling a total of 226 runs, the Super Kings came out guns a blazing bashing boundaries to knock their asking rate down to 9.07 by the 6th over. With SAP Lumira we can create an area chart that shows the number of runs each Chennai batsman struck during their innings. Highlighted in yellow is the amazing performance of Raina, who finished with 87 runs on only 25 balls. Raina reach a half century in only 16 balls, the second quickest in league history, and finished his innings with a gargantuan strike-rate of 348. Note Raina’s amazing 33 run 6th over where he smashed a boundary on every ball. As evident in the chart, once Raina was dismissed in the 7th over the Super Kings struggled to strike boundaries as they only hit four in their next 12 overs, including a devastating four over boundary drought that skyrocketed their asking rate.
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