How to make your SAP Lumira Charts more interesting for free

To the most interesting teacher ever Tony de Thomasis

In this blog I will be discussing how you can make SAP Lumira visualizations look more interesting by using Esri Geo Maps instead of default Lumira maps. And Yes! It is totally free. SAP Lumira is one of the useful tools which I learned in Victoria University course BCO6181

Ingredients needed for this tutorial are:

• SAP Lumira  1.25 (free trial version can be downloaded from http://saplumira.com/download/)
• Esri account (just signup needed for a free trial account on https://accounts.esri.com/signup?redirect_uri=http%3A%2F%2Fwww.esri.com%2F)
• Dataset, we are using Nepal earthquake dataset for this tutorial (available for free from https://data.hdx.rwlabs.org/dataset/official-figures-for-casualties-and-damage)

Workshop

To start off, upload dataset on to SAP Lumira, in this tutorial we are using dataset “Key Government Figures – Nepal Earthquake.xlsx” available from above mentioned link. Use Tot_Deaths as a measure and convert the dimension ‘District’ into geographical hierarchy by names

On next screen, in ‘Sub-Region’ field, select ‘District’ and in Country field select None. The subsequent screen gives us error showing 71 locations were not found

We received this error because the Lumira built-in Navteq libraries only include locations with population above 100,000. To solve this issue I manually solved each location for its longitude and latitude values using website http://www.latlong.net/ and updated my excel sheet

Load the updated excel sheet on Lumira again. Convert ‘DISTRICT’ into geographical hierarchy by longitude and latitude

On the next screen select ‘Longitude’ dimension in Longitude field and ‘Latitude’ dimension in Latitude field and select Sub-Region in Geographical Level Field

Select Finish on next screen. Now if you select the newly created geographical hierarchy ‘DISTRICT_LongLat’ as dimension and Tot_Death as measure and select default Geo Bubble Chart from the charts option, the resulting graph will look like this

As we can see the above chart is not much detailed, we will try to introduce Esri Maps

Esri Maps Workshop

To use Esri Maps in Lumira you don’t need to download or install anything, just go to Esri.com and signup for a free trial account. Come back to your SAP Lumira Lumira, go to File > Preferences > Geo Map Service and sign in with your Esri credentials

Now on your SAP Lumira screen, click on Geographical Charts option and select ‘Geo Map’.

The Esri Map will be loaded automatically. Now select Tot_Deaths as measure and location by longitude and latitude as dimension. the resulting chart looks like this

As we can see the resulting chart is much more detailed and looks way better than the default one

In this blog we have discussed

• Where to download SAP lumira and a simple tutorial on using maps
• How to fix maps for smaller areas not showing on maps i.e. locations with population less than 100,000 people by using latitude and longitude
• And lastly, how to integrate Esri Geo Maps with SAP Lumira