The Delhi Daredevils will host the league’s best team, the Kings XI Punjab, in their final home match of the season at Ferozeshah Kotla Stadium in Delhi. The Daredevils have lost six straight matches and have yet to win on Indian soil. If Delhi hopes to snap their losing streak they will have to complete the herculean task of containing Glenn Maxwell and the rest of Kings XI’s elite lineup. By loading historical ball by ball match data into SAP HANA we can create insight-laden visualizations in SAP Lumira and SAP Crystal Report of the matches between these teams last season to preview tonight’s contest.
The Kings XI won the first match last season by five wickets when they successfully overhauled Delhi’s paltry total of 120 runs in only 17 overs. The Kings XI took seven wickets during their attack to severely limit the Delhi batsman. After losing a wicket in their first over the Kings XI had monster 2nd and 4th overs that jump started an easy overhaul. Check out the worm chart that we can build in SAP Crystal Reports that shows the cumulative score for each team during their innings and when their wickets were taken.
Harmeet Singh displayed some excellent bowling for the Kings XI and was awarded the Man of the Match honor for his three wicket performance. With SAP Crystal Reports we can create a graphic that shows the line, length, and result of each of the 24 balls Singh delivered in the four overs he bowled. The right handed Singh predominately delivered balls with an outside off stump line and earn took two of his wickets from outside off stump tosses. Singh’s only yorker of the night was very effective as it dismissed a Delhi batsman via a catch.
The Kings XI successfully defended their total in the return match in Dharamsala to defeat the Daredevils by seven runs. With SAP Lumira we can crate a Manhattan chart that shows the number of runs each team scored per over. In four overs the Kings XI scored 16 or more runs to set a formidable target of 171 runs. The Punjab attack then held the Daredevils at bay by bowling eight overs in which they conceded six runs or less. The Kings XI had the match well in hand and only a late Delhi flurry made the final score appear much closer than it actually was.
David Miller was honored as the Man of the Match as his unbeaten 44 runs on 24 balls were vital in the imposing total that the Kings XI set. With SAP Crystal Reports we can create a wagon wheel that shows the trajectory and length of each of Miller’s 15 run scoring shots. Miller drove a pair of boundaries towards practically the exact same spot with lofted drives and send a pair of sixes to his right and a pair of fours to his left.
Can the Daredevils shock the Cricket world and upset the Kings XI? Or will Maxwell, Miller, and the rest of Punjab’s potent lineup maul Delhi’s attack?
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