Analytics And Intelligent Systems

NUS ISS AIS Practice Group

Geo visualization of Age Dependency Ratio — November 19, 2016

Geo visualization of Age Dependency Ratio

Rajiv Krishna Prasad A0148542A

Sanjeev Kumar Chandran A0148398L

Mahendra Kumar KS A0148495N

Kotlanka Krishna Chaitanya A0150146R

_________________________________________________________________

Age dependency ratio (% of working-age population) data from 1960 till 2015 was used for the analysis, and was projected for 2016 and 2017.

Age dependency ratio is the ratio of dependents (people younger than 15 or older than 64) to the working-age population (ages between 15 and 64). Data is shown as the proportion of dependents per 100 working-age population.

The data obtained from the data source did not contain the latitude and longitude points for the countries. To incorporate these points, we obtained latitude and longitude data for all the countries from “http://www.csgnetwork.com/llinfotable.html”

We have converted countries into the signed degrees’ format (DDD.dddd), which are then used as markers on the map.
e.g.: Singapore into geographic coordinates latitude 1.290270 and longitude 103.851959

Findings/Insights:
1. Majority of the countries with least change in age dependency are from the European Union while those for increasing age dependency are from Africa
2. There was no general trend observed for countries with decreasing age dependency
3. There are more number of countries with decreasing age dependency (148) than countries with increasing age dependency (40)

Age dependency ratio for 1960:

adr-1960

Age dependency ratio for 2015:

adr-2015

Projected age dependency ratio for 2017:

adr-2017

In addition, the link to access the sheet published online is given below:

https://public.tableau.com/profile/publish/DA-Assignment/Geovisualization#!/publish-confirm

Advertisements
Smart Nation – Dashboard —

Smart Nation – Dashboard

Rajiv Krishna Prasad A0148542A

Sanjeev Kumar Chandran A0148398L

Mahendra Kumar KS A0148495N

Kotlanka Krishna Chaitanya A0150146

_________________________________________________________________

The objective of creating this dashboard was to prepare a comprehensive and actionable dashboard to measure the success of the Smart Nation initiative. The dashboard helps in answering the questions pertaining to Smart Nation Initiative. Below are few questions which can answered by the dashboard.

  1. With the Energy Consumption bound to increase, what steps are taken by the government to produce electricity with reduced pollution?

Energy consumption is expected to increase by 35% in 2035. The electricity generated is increasing over the years in Singapore and the carbon intensity while generating the electricity is reducing.

 

  1. The need for the talented resources will increase with the Smart Nation initiative, what measures are taken by the government to ensure that there is no scarcity for the talent?

Singapore is building a talent pool with the help of its top ranking universities. The Singapore government has increased the investment in development of education. The increase in investment over past 10 years can be observed from the chart.

 

  1. The need for transportation will increase, as the population increases and the need for travel will also increase, how will the government tackle the issue with the limited land and other resources?

There are already 1 Million personal cars in Singapore, and roads take up to 12% land space. The government is encouraging people to take up public transport, the chart shows that the people using Bus has increased by 33% and people using MRT has increased by almost 300% in the past 10 years.

 

  1. How is the government supporting the ecosystem needed to encourage R&D and Innovation enterprises, which will help achieve the goals of the smart nation?

The Singapore government has increased its investment in the field of R&D as seen in the graph. The number of start-ups too has increased by more than 100% in the last 10 years, and the government is setting up subsidiaries to foster the ecosystem.

 

  1. How will Smart Nation initiative help the ageing population of Singapore?

The ageing population in Singapore is estimated to be 900,000 in 2030 from 300,000 in 2016. It can be seen from the chart that the Singapore government has more than tripled its healthcare expenditure in the last 10 years, to setup infrastructure for future healthcare system.