Skip to Content

IPL Cricket Insights Screen Shot 2015-03-09 at 9.36.26 AM.png

For the 2014 IPL Twenty20 Cricket tournament (won by the SAP HANA powered Kolkata Knight Riders) the SAP HANA Academy composed daily blogs previewing fixtures and analyzing match results using the SAP BI tools, SAP Lumira and SAP Crystal Reports. Ball-by-ball XML files from Opta Sports for each match were loaded in SAP HANA using Data Services. Analytic views were created in SAP HANA Studio to enrich the data. After connecting to those analytic views with SAP Lumira we discovered insights about individual bowlers, batters, and teams by building visualizations and storyboards. SAP Luirma Cloud was used to create dynamic and engaging analytics of historical IPL data.

Screen Shot 2015-03-09 at 9.50.40 AM.png

Video Title Description SCN Blog
Cricket – Getting the Data How a FTP server receives ball by ball XML files from Opta Sports and how to convert them into DTD files so they can be loaded into SAP HANA for consumption by SAP BI Tools. [SAP HANA Academy Cricket Demo] – Video: Getting the Data & Sunrisers Hyderabad V Kings XI Punjab Match 39 Preview
Cricket – Loading the Data

How SAP Data services is used to convert XMl files to SAP HANA Columnar tables by using loop and conditional work flows to carry out the developmental tasks.Try-catch blocks are used to identify errors.

[SAP HANA Academy Cricket Demo] – Video: Loading the Data & Sunrisers Hyderabad V Royal Challengers Bangalore Match 46 Preview
Cricket – Exposing the Data How to build an Analytic view in SAP HANA Studio to expose the cricket data to SAP Lumria. The video shows how to modify and cleanse the data and how to set measures and dimensions. [SAP HANA Academy Cricket Demo] – Video: Exposing the Data & 1st Qualifier Preview – Kings XI Punjab V Kolkata Knight Riders
Cricket – Visualizing the Data

How to use an online connection to SAP HANA to build a map, pie, area and bar chart in SAP Lumira to preview an IPL match.

[SAP HANA Academy Cricket Demo] – Video: Exploring in Lumira & 2nd Qualifier Preview – Kings XI Punjab V Chennai Super Kings
Cricket – Putting the Data in the Cloud

How to build and animate an area chart, a correlation graph, and a pair of geographic maps overlaid with Cricket data in SAP Lumria Cloud.

[SAP HANA Academy Cricket Demo] – Video: Putting the Data into SAP Lumira Cloud

Make sure to regularly check this document for new SAP Lumira video tutorials from the SAP HANA Academy.


SAP HANA Academy over 900 free tutorial videos on using SAP HANA.


Follow @saphanaacademy

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