Skip to Content
Author's profile photo Anson John Abraham

Cities with Best Quality of Living Analytics with SAP Lumira

In the 21st century, I think the heroes will be the people who will improve the quality of life, fight poverty and introduce more sustainability.” – Bertrand Piccard

Quality of living analytics focus on finding the cities all over the globe in providing best political, economic, environmental, personal safety, health, education, transportation and other public service factors. This analytics is done based on the information collected from Mercer Quality of Living Survey and it can be used by career aspirants to set their future goals and organizations to compensate their employees by placing them in the best cities for international assignments.

Action points

  1. Find the data source
  2. Extract the data
  3. Upload the data to Lumira
  4. Filter the data
  5. Visualize the data

Finding the data source

The data source is collected from the following source:

Extracting the data

Data collected from the source is saved to an excel file.

Uploading the data to Lumira

Excel data is uploaded to Lumira. Quality of living rankings of previous years is excluded during the upload.

Filtering the data

Data is filtered to consider only the top ranked cities for analytics.

Visualizing the data


  • Find the best cities based on the quality of living standards.
  • Find the best cities in Germany based on the quality of living standards.


Listing the cities based on quality of living rank

Funnel Chart

Visualizing the cities based on quality of living index rating

Network Chart

Find the best cities in Germany based on quality of living standards


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.