The table topping Chennai Super Kings will host the desperate Royal Challengers Bangalore in the 42nd Match of the 2014 Indian Premier Twenty20 tournament. Both clubs enter the clash on two match winning streaks with the Super Kings seeking to improve their playoff positioning while the Royal Challengers are dearly trying to secure a place in the top half of the table. By loading historical match data into SAP HANA we can preview Sunday afternoon’s clash by analyzing how these sides fair against each other last year by creating insight-laden graphics in SAP Lumira and SAP Crystal Reports.
In an intense chase the Super Kings successfully overhauled Bangalore’s total of 165 runs on the final ball. Needing two runs off of their last ball Bangalore’s PR Singh appeared to scalped Ravindra Jadeja to secure Bangalore’s defense. However, his foot landed beyond the line and the no ball followed by a single clinched a dramatic victory for the Super Kings. With SAP Crystal Reports we can create a worm chart that shows the cumulative number of runs each team scored and when their wickets fell. The four wickets the Super Kings took in the final four overs were vital in their limiting of Bangalore’s total.
With SAP Lumira we can easily create an area chart that plots the number of runs each Chennai batsman scored per ball. Evident in the visualization in lime green, teal, yellow, and purple are the 30 or more runs Suresh Raina, Subramaniam Badrinath, MS Dhoni, and Ravindra Jadeja, each scored in Chennai’s successful chase. Jadeja was awarded the Man of the Match honor as his unbeaten 38 runs was the highest total of runs scored for the victorious Super Kings.
Runs abounded in the rain-shorted return match a month later in Bangalore as both teams finished their eight over innings with run rates north of 10. In seven out of their eight overs the Royal Challengers scored more than 10 runs including three overs of 15 or more runs to finish with an impressive total of 106 runs. Check out the number of runs each team scored per over in the Manhattan chart we can easily build in SAP Lumira.
Bangalore’s unbeaten Virat Kohli was honored as the Man of the Match as he scored 56 runs on 29 balls by smashing six fours and mauling four maximums. With SAP Crystal Reports we can create a wagon wheel that details the distance and trajectory of Kohli’s 17 run scoring shots. Note that three of Kohli’s maximums were hit with straight drives in nearly the identical direction.
Which side will push their winning streak to three?
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