[Cricket Match Preview] – 44th Match – Royals Seeking Second Straight Win When Hosting Mumbai – Rajasthan Royals V Mumbai Indians

The Rajasthan Royals will host in the Mumbai Indians in their last home match of the tournament. The Royals seek to firm up their playoff positioning while with only three wins from 10 matches the defending champions must win out the rest of their four games if they hope to even possibly make the playoffs. By loading historical match data into SAP HANA we can analyze how the Royals and Indians faired against each other last year by creating visualizations in SAP Lumira and SAP Crystal Reports to preview this afternoon’s match.


Rajasthan handily won the first meeting in last season’s tournament as they Royals’ attack shot out the Indians in only 110 balls to win by 87 runs. Unbeaten Ajinkya Rahane powered the Royals throughout their innings by opening the innings and then emphatically concluding them with three fours in the final over. See how we can visualize Rajasthan’s dominate performance by creating a Manhattan chart in SAP Lumira.

Screen Shot 2014-05-18 at 12.00.25 PM.png

All of the Royals bowled well in the match with none of their six bowlers finishing their overs with an economy above 8.33 and two leaving the pitch with sub 3.33 economies. With SAP Crystal Reports we can build a graphic that shows the line, length, and result of each ball that was delivered by one of Rajasthan’s great bowlers from that match, James Faulkner. A large portion of Faulkner’s balls were dots and he took three wickets with two coming from length balls.

Screen Shot 2014-05-18 at 12.06.18 PM.png

The Indians won the return match 28 days later in Mumbai by 14 runs when their attack successfully stymied the Royals lineup. With SAP Crystal Reports we can build a worm chart that shows each team’s cumulative score at every point in the match and when their wickets were taken. After an initial scalp in the first over the Indian’s attack continued to great limit the Royals’ batsmen and by the 6th over the Royals were only 29 for 4. From then on the Indians were easily able to keep the Royals under their pace to earn a vital two points.

Screen Shot 2014-05-18 at 12.22.36 PM.png

With SAP Lumira we can plot the number of runs each Mumbai batsman scored per ball in the match. Aditya Tare’s 59 runs on 37 balls is shown in blue below. Tare’s performance included eight fours and a maximum to earn the Indian wicketkeeper the Man of the Match honor.

Screen Shot 2014-05-18 at 12.25.32 PM.png

Will the Royals win their second straight match and virtual clinch a post season position? Or will the Indians keep their season alive?

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)

921 Views