[Cricket Match Preview] – Final – Best Bowling V Best Batting with Golden Cup on the Line – Kolkata Knight Riders V Kings XI Punjab

Tonight’s Championship match in Bangalore will feature a clash between the best bowling team and the best batting team. While the Kings XI have scored the most runs in the tournament the Knight Riders’ attack has held the potent lineup to less than 150 runs during their matches this season. Find out how in the 1st qualifier the Knight Riders’ attack was able to be be the first side to successfully defend a total against a Kings XI chase this season. After loading ball by ball match data from the 2014 Indian Premier Twenty20 tournament into SAP HANA we can create insightful visualizations with SAP Lumira to preview tonight’s Championship match.

Using SAP Lumira we can compare the number of runs each team’s batsman have scored this tournament by creating a pair of pie charts that shows each batsman’s run total as a percentage of the team’s batting runs. The Knight Riders’ lineup is lead by Robin Uthappa in peach below. While Uthappa’s 665 runs is highest total in the league, it is also the highest aggregate total for a season for any Indian national batsman ever in the tournament’s history. Kolkata’s Skipper, Gautam Gambhir, and Manish Pandey have each scored over 300 runs for the Knight Riders this season. As the tournament’s highest scoring team the Kings XI have gotten monster contributions all season from David Miller, Virender Sehwag, and Glenn Maxwell. The three have combined for 1,445 runs.

Screen Shot 2014-05-30 at 5.25.55 PM.png

With SAP Lumira we dive further into Punjab’s batting by creating a stacked bar chart that shows the number of their runs that resulted from boundaries per match. Quickly evident in the chart is the fact that Punjab has scored more than 150 runs in over 75 percent of their matches. In a vast majority of their matches the King XI scored a large portion of their runs via boundary shots. However, in their defeat at the hand of the Knight Riders in the 1st qualifier, the Kings XI scored just over half of of their runs from boundaries while in the 2nd qualifier the Kings XI scored nearly 70 percent of their 226 runs via boundaries.

Screen Shot 2014-05-30 at 5.49.05 PM.png

By creating a regional Geographic hierarchy we can depicted the percentage of the team wickets each individual Punjab and Kolkata bowler has taken during the tournament with pie charts overlaid on Punjab and West Bengal in a map of the Indian subcontinent. The Kings XI’s attack is lead by Akshar Patel (in blue below) who has taken 17 wickets and has a team best 6.19 economy. The Kings XI have taken the most wickets in the tournament. In addition to Patel, Sandeep Sharma, Mitchell Johnson, Rishi Dhawan, and Lakshmipathy Balaji have each recorded over 12 scalps. The Knight Riders’ attack has conceded the least amount of runs for any team in the tournament. They are lead by the arguably the best bowler in the tournament, Sunil Narine. Narine has taken 20 wickets and his 6.01 economy is the best for any bowler who regularly bowl for their team. As one can see from the pie chart on the map, the Knight Riders have four additional bowlers who have taken between 11 and 12 wickets during the season. Can the Knight Rider’s fantastic attack hold the Kings XI below 150 runs again?

Screen Shot 2014-05-30 at 5.32.20 PM.png

Will Punjab’s batting reign supreme or will Kolkata’s superb bowling lead to the Knight Riders’ second Golden Cup in three years?

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)

1215 Views