[Cricket Match Preview] – 49th Match – Must Win for Royal Challengers – Kolkata Knight Riders V Royal Challengers Bangalore

The scorching hot Kolkata Knight Riders, winners of five straight matches, will host the desperate Royal Challengers Bangalore this afternoon in a match with huge postseason implications. With a win, the Knight Riders will secure one of the two remaining playoff berths. Meanwhile the Royal Challengers must win their final pair of matches and get some help from other results to snag the final playoff spot. With an elimination atmosphere, KKR’s spinners will seek to flummox the dangerous yet underachieving Royal Challengers’ lineup. See how Bangalore’s chase was snuffed out by a spectacular match robbing catch from Chris Lynn earlier this season in Sharjah and find out how these sides faired against each other in their clashes last season. By loading ball by ball match data from this season’s action into SAP HANA we can preview this afternoon’s intense showdown by creating informative visualizations with SAP Lumira and SAP Crystal Reports.


With SAP Lumira we can show the the number of runs each team’s batsman have scored so far this season by creating a pair of bar charts. The Knight Riders’ lineup is anchored by Robin Uthappa, who’s 489 runs (towering above all else in pale yellow in the visualization below) are currently good for the second highest total in the tournament and the Indian right-handed batsman is only 44 runs behind Glenn Maxwell for the tournament’s Orange Cap. The Royal Challengers’ have struggled at the crease his year even though their lineup features two of arguably the worlds’ best Cricketers, the South African AB de Villiers, and the Jamaican Chris Gayle. AB de Villiers has been RCB’s best batsman, scoring 372 runs, while Gayle has struggled this season, scoring only 23.75 runs in the eight matches he has appeared in. Gayle, the tournament’s all-time century leader with four, has yet to post even a half-century this season.

Screen Shot 2014-05-21 at 8.30.41 AM.png

By creating a geographic hierarchy of each batting team’s region we can visualize the percentage runs each team has scored off of boundaries this season. Kolkata has scored a little over half of their runs from boundaries as they have 874 boundary runs and 804 non boundary runs. Meanwhile, Bangalore has relied heavily on boundary shots, as the Royal Challengers have scored 1,056 boundary runs and only 633 non boundary runs.

Screen Shot 2014-05-21 at 8.34.32 AM.png

With SAP Crystal Reports we can visualize the economies of the Royal Challengers’ most effective bowler, Yuzvendra Chanhal, and the strike-rates of the Knight Riders’ best batsman, Robin Uthappa, broken down by the line and length of the balls they have delivered and faced. Chahal’s length balls have been very effective as he has economies at or below 6.80 for every line of length ball tosses, with leg stump length balls yielding his best economy. Uthappa has struck excellently against most of the delivers he has faced but yorkers have really given him some trouble. Uthappa has sub 50.0 strike rates against the yorkers he has faced this season.

Screen Shot 2014-05-21 at 8.38.21 AM.png

Will Gayle finally showcase his incredible power and help to keep RCB’s season alive or will KKR treat the Eden Gardens faithful to their six straight win?

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.


-Tom Flanagan

SAP HANA Academy

VN:F [1.9.22_1171]
Average User Rating
Rating: 0.0/5 (0 votes cast)

658 Views