[Cricket Results] – SAP HANA Powered Kolkata Knight Riders Win Championship

The Kolkata Knight Riders won their second Indian Premier Twenty20 Championship in three years when they chased down the Kings XI’s 200 run target in an exciting conclusion to a electrifying 7th tournament. The Knight Riders used the blazing speed of SAP HANA to analyze players during the auction period and a few of their signing, including Robin Uthappa, who won the Orange Cap as the tournament’s highest scorer, and the final’s Man of the Match, Manish Pandey, were instrumental in Kolkata’s nine match winning streak. By loading ball by ball data from the match into SAP HANA we can create insight-laden visualizations with SAP Lumira and SAP Crystal Reports to analyze Kolkata’s three wicket Championship victory.


With SAP Crystal Reports we can create a worm chart that shows each teams’ exact score at any point in the match and when their wickets were taken. After the 10th over of their innings, the Kings XI were only 58 for 2, as they struggled to strike boundaries and were continuously dotted by KKR’s fierce attack. However, the Kings XI exploded in the final half of their overs scoring 141 runs and gouging Kolkata’s usually dominate spinner, Sunil Narine, for 44 runs in three overs. The Kings XI innings were lead by unbeaten Wriddhiman Saha, who scored 112 runs, the first century in the history of the tournament’s final match, and formed a 129 run partnership with Manan Vohra. With an asking rate of an even 10 runs, the Knight Riders’ lineup continuously scored a substantial number of runs per over and scored 10 or more runs in 10 of their overs. Manish Pandey’s 13 timely boundaries including three maximums struck right after wickets were taken, propelled Kolkata along the required pace. With four wickets falling late in their overs, the Knight Riders relied on their last capable batsman, Piyush Chawal to strike a pair of colossal boundaries to earn the golden cup.

Screen Shot 2014-06-02 at 10.07.01 AM.png

Even though it turned out to be in vain, Wriddhiman Saha’s historic century delighted the Bangalore crowed. In a match where Glenn Maxwell and David Miller only scored a single run combined, Saha carried the Kings XI to within three balls of their first Championship. With SAP Crystal Reports we can create a Wagon Wheel that show the length, line, and result of each of Saha’s 29 run scoring shots. Saha scattered his shots all across the pitch, sending balls to the boundary in seemingly every sector of the wheel. Saha did the most damage with pull shots, striking two maximums and a four and scoring 24 runs off of 8 pull shots.

Screen Shot 2014-06-02 at 11.03.58 AM.png

With SAP Lumira we can create an area chart that shows the number of runs each Knight Rider batsman scored during their Championship clinching chase. After Orange Cap man, Robin Uthappa was quickly dismissed after an opening ball four, the Chinnaswammy crowd was dazzled by the Manish Pandey show. By the time time Pandey’s wicket was finally taken in the middle of the 17th over the Knight Riders were only 32 runs shy of their target, as Pandey scored 94 runs off of 50 balls while striking seven fours and six maximums. Pandey, shown in green below, formed a pair of half-century plus partnerships with Gautam Gambhir and Yusuf Pathan. Perhaps the biggest shot of Kolkata’s innings was Piyush Chawla’s maximum at the end of the 19th over to knock their overhaul mark down to five, which he surpassed with a four three balls later.

Screen Shot 2014-06-02 at 11.33.58 AM.png

Congratulations to the 2014 Indian Premier Twenty20 tournament Champions, the Kolkata Knight Riders!

Keep your eyes peeled for more visualizations created in SAP Lumira and SAP Crystal Reports using historical Indian Twenty20 data processed by SAP HANA. Please check back for additional post season analysis. Also, watch out for our continuing series of tutorial videos on how we utilize SAP HANA in this Cricket demo.


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)

4518 Views