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.
|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.