The Kolkata Knight Riders set a tournament record by finishing the 2014 season with nine straight victories and after a three wicket victory over the Kings XI Punjab they won their second Indian Premier Twenty20 Championship in three years. During the player auction in February the Knight Riders used the blazing speed of SAP HANA to analyze all of the Cricketers available for the tournament with SAP Auction Analytics. After finishing in 7th place last season the Knight Riders largely revamped their squad using insights on player’s strengths and values they derived from SAP HANA. With ball by ball match data from both the 2013 and 2014 seasons processed by SAP HANA we can create informative visualizations with SAP Lumira to analyze how the moves the Knight Riders made in the auction paid tremendous dividends in their Championship campaign.


With SAP Lumira we can quickly build a pair of pie charts to compare the number of batting runs each member of the Knight Riders’ lineups scored during the 2013 and 2014 seasons. The Knight Riders retained the services of their three highest scorers from their 2013 squad as team Captain Gautam Gambhir, Yusuf Pathan, and Jacques Kallis all scored over 300 runs in their 16 innings last year. While Gambhir and Pathan, in teal blue and beige respectively below, both scored fewer runs this season, they did make impactful contributors to Kolkata’s offense with Pathan greatly improving his strike to 162.42, the third highest in the tournament. Two of Kolkata’s most impactful singings were Robin Uthappa and Manish Pandey and their incredible production in shown below in peach and blue respectively. Uthappa 660 runs was the highest aggregate score ever for an Indian National in the tournament and earned the opening batsman his first Orange Cap. Pandey was one of the 10 batsmen to scored over 400 runs in the tournament.

Screen Shot 2014-06-06 at 10.53.01 AM.png

The Knight Riders also used SAP Auction Analytics powered by SAP HANA to almost entirely re-tool their attack. With SAP Lumira we can compare the number of wickets the members of their attacks took in 2013 and 2014. Kolkata smartly chose to retain one of the world’s best bowlers, Sunil Narine. While Narine’s wickets, strike-rate, and economy all dipped a bit during this year’s tournament, the Trinidadian spinner was in contention for and wore the Purple Cap for much of the tournament as many lineups approached clashes with the Knight Riders believing they would only have 16 overs to score due to Narine’s consistent dominance. As evident from the chart, the four new bowlers Kolkata won in the auction, Piyush Chawla, Morne Morkel, Ahakib Al Hasan, and Umesh Yadav, each took 11 or more wickets for the Knight Riders this season.

Screen Shot 2014-06-06 at 11.15.52 AM.png

With SAP Lumira we can quickly create a storyboard to show a side by side comparison of KKR’s score in every match of their 2014 campaign with the batting runs scored in each match by the new additions to their lineup this season. As evident from the graphs, in a vast majority of Kolkata’s matches their newly acquired batsmen scored a large chunk of their batting runs. In a pair of vital victories during their surge into the playoffs on May 20th and May 22nd the new men in Purple and Gold scored a massive portion of the Knight Riders’ runs.

Screen Shot 2014-06-09 at 12.05.59 PM.png

Congratulations again to 2014 Indian Premier Twenty20 Cricket tournament Champions, the Kolkata Knight Riders. Using SAP Auction Analytics powered by SAP HANA, the Knight Riders were able to assemble the pieces necessary to raise the trophy for the second time in three years.

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

Follow @saphanaacademy

Follow @thomflanagan

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply