“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:

http://en.wikipedia.org/wiki/Mercer_Quality_of_Living_Survey

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

Objectives

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

Table

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

Map