Analytics And Intelligent Systems

NUS ISS AIS Practice Group

REGIONAL FLAT RESALE STATUS OF SINGAPORE AND YEARLY TREND — May 31, 2017

REGIONAL FLAT RESALE STATUS OF SINGAPORE AND YEARLY TREND

Resale a flat is usually more expensive than buying a new flat directly from HDB. However, this is one of the most lucrative and profitable business for investors. This also affords one a greater flexibility to select a unit that suits his needs, such as choosing a well-renovated one to save him / her from taking a renovation loan, or one near your workplace. Buying a resale flat in the same town or within 2km also qualifies one for the CPF Housing Grant. Hence, in totality from a buyer’s perspective or from the perspective of a property agency, they are always eager to know the hidden factors behind buying a resale flat or the price fluctuation of resale flats by different regions.

Business Goal:

Our goal is to find the answers of some core problematic areas of property business in Singapore using dashboard and this can be referred by business users for both explanatory and exploratory purposes. In simple words this dashboard will give the business users an overview of flat resale facts.

Dashboard resale

Questions:

  1. What is the average resale price of a flat for a region ?
  2. What is the average resale price of a flat for a region with respect to locations, flat model and flat types ?
  3. What are the top five regions can a buyer should look for ?
  4. What are the best five model type with average resale price buyer should look for ?
  5. When is the best flat resale season ?

KPI:

We have divided the entire dashboard in two parts, first part will focus on explanatory analysis whereas the second part will be referred for exploratory analysis in which we share our key findings based on the available month and year based data for different regions in Singapore.

  • Regional Distribution by Average Resale Price [Explanatory Purpose]:

The goal of this metric is to demonstrate the regional average resale price value. And this will help business or future property investors to focus on these areas. Also by the color density one can identify the high resale price zones easily.

  • Regional Flat Resale by Flat Model & Flat Type [Explanatory Purpose]:

The goal of this metric is to demonstrate the regional flat resale prices by flat model and flat type. And this will help business or future property investors to understand which flat models and flat types are in high demand by each region. As there are more demand in specific locations the resale value will be more.

  • Top 5 Regions with High Average Resale Value [Explanatory Purpose]:

The goal of this metric is to identify top 5 regions across Singapore where the Avg. resale price is high. This will give an idea of the ground level trends of flat resale price. And investors can focus on these areas based on their personal need. And we also provide different filter option across the dashboard, which enables user to get the necessary information for specific filter criteria. Example: Top 5 regions with high resale price for a specific year.

  • Top 5 Flat Models with High Average Resale Value [Explanatory Purpose]:

The goal of this metric is to identify top 5 flat models across Singapore where the Avg. resale price is high. Investors and real estate agencies can get the idea the demand of specific flat models across Singapore community and investors can focus on these specific flat models to gain more profit in long run from the high resale price.

  • Flat Resale Seasonality [Exploratory Purpose]:

This metric is derived for exploratory purpose. The goal is to identify the flat resale seasonality based on the trends within the available data. The purpose of this metric is to help the property agents to get a complete idea on the seasonality of flat buy or resale events when majority of Singapore community is willing to invest money in buying / selling the flats. This will help business to plan their marketing strategies properly to get the maximum output and profitability.

Features and Techniques:

While developing the dashboard we majorly focused on few following key aspects:

  1. Use Singapore map and highlight the regions with different shades of same color to showcase the density of avg. flat resale price value fluctuation. And, kept the legends on top of the dashboard for easy understanding.
  2. We use hierarchy concept to traverse more granular level of the data and have introduced new variables in dashboard layer for effective slice and dice of the data.
  3. We kept all the color legends under filter criteria for easy reference and user friendly UI.

Data Collection and Other Refereences:

https://data.gov.sg/dataset/resale-flat-prices
http://www.storytellingwithdata.com/blog/2014/04/exploratory-vs-explanatory-analysis

Submitted By:

Team: THETA
Ayan Biswas [A0163340R], Saravanan Rajamanickam [A0163321U], Vivekananda.S [A0163268Y], Adarsh Kumar [A0163397U]

 

Fertility Rate Scorecard for Singapore — May 7, 2017

Fertility Rate Scorecard for Singapore

Goal: Identify the focus areas for interventions to improve lower fertility rate in Singapore.

dashboardimage-final

Total fertility rate refers to the number of children born to a woman in her childbearing years. It is important for any country to maintain the fertility rate at a certain level (2.1 for developed countries as recommended by the World Health Organization), so that the population of the country can replace itself. This is required to maintain a balance in the age distribution in the population. The problem of aging population refers to having more individuals in the senior age group and fewer individuals in the younger age groups. This is referred to as an inverted pyramid population distribution. A larger number of individuals in the senior age group implies higher healthcare costs for the government coupled with lower taxes collected from the productively employed working population.

This study attempts to identify the factors correlated with lower fertility rate where interventions can be recommended. The interactive dashboard is found here.

How does Singapore’s Total Fertility Rate (TFR) compare to other countries of similar socio-economic and human development levels?

Singapore’s total fertility rate is compared to other countries of similar socio-economic level and Human Development Index (HDI). Source data was obtained from the World Bank. The data shows that Singapore has one of the lowest fertility rates compared to other countries. Also, the fertility rate of Singapore is significantly lower than the recommended rate of 2.1 for developed countries.

What is the population distribution trend within Singapore?

Historically, Singapore’s population has followed a population pyramid, with a greater number of younger individuals than older individuals. However, the population trend has been shifting to an inverted pyramid — the number of younger individuals is declining relative to older individuals. This means that the country has an aging population. The projected population distribution for 2022 has also been estimated using Tableau and shows no change from the current trend. This aging population implies higher health expenditures for the country. There will also be fewer individuals in the younger age group with taxable income to support the healthcare requirements of the older age group.

What is the age-specific distribution of married couples without children? Must there be focus on this area to change the trend?

The number of couple-based households without children has been increasing for all age groups. Specifically, the number of households (without children) whose head is below 35 years of age started to increase again since 2013. If the trend for this age group does not change, the number of couple-based households above 35 years of age will grow rapidly in the coming years. This will result to the growth on aging couples with no children to care for them. Initiatives are necessary to change this trend and encourage Singaporean households to have children at an earlier stage of marriage. Reasons causing this trend must be investigated to provide the necessary interventions.

Is it affordable for households in Singapore to have children? Is the average gross monthly income of an average Singaporean adult growing fast enough to cope with the basic needs of having children? Where should the focus on economic incentives be?

The graph shows that the gross monthly income of Singaporean households is increasing at a greater rate than the increase in the cost of living index for the basic expenditures associated with a family, such as Food, Shelter, Health Care, Education and Clothing. This means that the average income of an average Singaporean household is growing fast enough to provide for the basic needs of a household. This trend suggests that the average Singaporean can afford to have a family. However, even with existing economic incentives, the fertility rate has not increased in several years. To reverse this trend, additional economic incentives may be explored targeted to raising the standard of living such as family travel, car ownership incentives, household help and child care services.

What is the age-specific marriage rate trend in Singapore? Should the cause of late marriages be investigated? Should relevant campaigns be created to address the causes of late marriages?

A shift towards later marriages occurred since 2007. Women of older age groups (above 30 years old) showed higher marriage rates than women of younger age groups (below 30 years old). According to these statistics, the population of women under 30 years old with high (university-level) educational qualifications are increasing. Similarly, female spouses holding managerial, administrative, technical and professional roles have increased over the past ten years. Both educational qualifications and occupation are clearly factors that demonstrate a linear correlation to late marriages. This trend calls for interventions to encourage women around this age bracket to marry and have children while at the same time preserving and supporting women’s educational and professional goals. In addition, infant mortality in high-income countries is lowest when maternal age is below 35 years (Flenady et al, 2011). This provides the maximum probabilities that the babies are healthy. Thus, for statistical and medical reasons, the targeting of the age bracket is justified.

Conclusion:

The lower fertility rate is prominent in the age group below thirty-five years. In addition, higher educational achievement and career advancement of women demonstrated a linear correlation to lower fertility rates. Indications of Singaporean households for a higher standard of living is also evident. Interventions through public campaigns or incentive programs for the population in this age group and focus areas may help to realize the country’s need to improve the population distribution.

Team Members: Liu Cong (A0163299R), Qi PengYu (A0163393B), Tagaan Rosalie (A0163455A), Tyagi Arti (A0163343L), Xian Sirui (A013435H)

Data Sources:  The World Bank, Singapore’s Public Data, Department of Statistics Singapore

Reference:  Vicki Flenady, Laura Koopmans, Philippa Middleton, J Frederik Frøen, Gordon C Smith, Kristen Gibbons, Michael Coory, Adrienne Gordon, David Ellwood, Harold David McIntyre, Ruth Fretts, Majid Ezzati. Major risk factors for stillbirth in high-income countries: a systematic review and meta-analysis, Lancet 2011; 377: 1331–40 DOI:10.1016/S0140- 6736(10)62233-7

Dashboard Visualisation of Average Monthly Household Energy Consumption Per Year in Singapore — April 28, 2017

Dashboard Visualisation of Average Monthly Household Energy Consumption Per Year in Singapore

The Visual Dashboard allows the user to see the level of energy consumption across Singapore and for a specific region. 

March 9 2017

Pranav Agarwal, Rohit Pattnaik, Snehal Singupalli, Ashok Kuruvilla Eapen and Abhilasha KumarDashboard Image

Pieces in Dashboard:

  1. MAP: The map allows the user to see the level of energy consumption across the country and for a specific region. After a region is selected the Graphs numbered 4,5 and 6 reflect information only for the selected region.
  2. Statistics: The Statistics for a year represent the range of energy consumptions (Minimum, Average and Maximum) for Singapore.
  3. Top N Consuming Regions: The Top N Consuming Regions shows the rank of highest energy consuming regions for the selected year (N = number selected by user)
  4. Electricity Consumption by Dwelling Type: Electricity Consumption by Dwelling Type line graph represents the amount of energy consumed by each dwelling type for the year selected by the user and the region selected in the map.
  5. Year on Year Change in Consumption (in %): Year on Year Change in Consumption bar graph represents the rate of increase or decrease of energy consumption for the selected region in the map. The colour depicts the rate of increase or decrease which is in line with colours highlighted in the map.
  6. Year on Year Change in Consumption by Dwelling Type (in %): Year on Year Change in Consumption by Dwelling Type line graph represents the rate of change of energy consumption for the region selected in the map split according to the dwelling type (1/2 Rooms, 3 Rooms, 4 Rooms and 5 Rooms). The colours of the line represent each dwelling type.

Interactive Features:

A) Select Energy- Type: The user can choose any of the below energy type from the drop-down menu.

1) Electricity  2) Gas  3) Electricity per capita population  4) Gas per capita population

B) Select Year: The user can select any year between 2005-2015 from the drop-down menu.

C) Select a Number: The user can enter a number, N, between 1-10 to identify the top N energy consuming regions.

The Dashboard would enable the user to answer the following Questions:

  • Do bigger Dwelling Types consume more energy?
  • Do high electricity consumers consume more gas too?
  • Does a yearly change in consumption suggest the advent of more energy efficient devices?
  • What has been the trend in energy consumption over the past few years?
  • Which regions are among the highest consumers of Energy?
  • What is the pattern in consumption across years, across dwelling types?
  • What is the impact of population on the level of energy consumption?

Link to view the Dashboard on Tableau Public:  View Dashboard

Estimating the Economic Health of Singapore for 2016 — March 18, 2017

Estimating the Economic Health of Singapore for 2016

Singapore is classified as one of the advanced economies of the world. It is currently the worlds no 2 investment friendly destination and considered as the gateway to Asia in terms of business opportunities and commodity trading. It is strategically well located for east west trading route and is one of the world’s busiest Business port. All of these factors have greatly contributed to the nation’s economic health.

In order to estimate the economic health of Singapore we adopted the GQM technique and have considered the following:

Goal :

To estimate the economic health of Singapore for the year 2016.

Questions:

  1. What is the GDP growth rate? Where does it stand against comparable developed countries?
  2. Identify the sectors which are contributing the most and least to the GDP to find avenues of improvement.
  3. Compare inflation of Singapore against comparable developed countries.
  4. Identify the biggest trading partners and their trading trend.
  5. To what extent are the job opportunities affecting the economic health of the country?

KPI:

  1. GDP Growth Trend with comparable countries
  2. Sector wise GDP
  3. CPI Trend with Comparable Countries
  4. Import and Export Volumes and Growth
  5. Unemployment Rate

The data for the dashboard was collected from the department of Statistics Singapore and International Monetary Fund.  Based on the KPIs mentioned above an exploratory analysis was done on 2 levels

To compare

  1. Singapore’s year on year performance
  2. Performance with respect to other advanced economies.

The dashboard visualization was done in Tableau.

Dashboard Observations:

GDP Growth Trend:

All the countries that we have considered have a positive GDP growth rate between 2-3 % except Japan.

GDP Growth- Sector wise:

For the year 2016, growth in Service Industry is a meagre 1 %. The Manufacturing Industry has however contributed the most to Singapore’s GDP with a growth rate of 3.6 %.

CPI Inflation Rate:

The CPI inflation rate has been negative for Singapore in the years 2015 & 2016 when compared to other countries although it was previously spiking till 2014 .  Excepting Singapore, all the countries  have a similar growth pattern.

Trade – Import and Export:

United States is the largest player for Singapore trade market. Singapore’s export to Japan is noticeably growing at 24.13 %

Unemployment:

Unemployment rate lies between 3-6 % roughly for all the countries. When compared to other countries, Singapore has the lowest unemployment rate.

Inference:

As an advanced economy, Singapore naturally has a limited scope for GDP growth. Global trend shows that countries classified alongside Singapore have also shown similar growth patterns with a dip in GDP growth in 2009 and a spike in 2010 which can be attributed to the Global financial crisis in 2008

Singapore, as characteristic of a developed country, is oriented towards a service industry driven economy. Growth in manufacturing industry relates to more demand for consumer goods and also opens up more employment opportunity. Hence, we are anticipating a decrease in the unemployment rate.

Singapore is largely dependent on the trading market. Any fluctuation in the trading market will directly impact Singapore’s economy.  As a country with limited resources Singapore is handicapped interms of its domestic export. Its advantage however lies in its transhipment potential to countries in southeast Asia.

The deflation in CPI post initial inflations suggests that the supply has overshot the demand. All other countries taken for comparison have a positive inflation which suggests higher demand. But despite a rather grim CPI stats, Singapore’s GDP growth is the second highest for 2016. These KPIs cumulatively indicate that Singapore’s economy is relatively healthy.

Data Visualization hence enables one to gain better insights on Singapore economy, by keeping track of its progress in interdependent metrics such as trade, GDP, and CPI.  It provides a holistic view of the economy and will enable us to act proactively to the volatile nature of global economic trends.

To view our Dashboard Click Here

Created By:

Abhinaya Murugesan [E0146975]

Allen Geoffrey Raj [E0146962]

Kavya Andakudi Kesavan [E0146814]

Preethi Jennifer Rajkumar [E0146754]

Saravanan Kalastha Sekar [E0146873]

 

 

 

 

 

 

 

 

 

Aging Problem of Singapore — March 17, 2017

Aging Problem of Singapore

27.pic

 Goal: 

The purpose to create this dashboard is to explore and monitor the aging process of Singapore. The dashboard has two parts. The upper part is about the current situation: Is Singapore experiencing aging problem now? What is the trend of aging process? The rest of the dashboard mainly focuses on two main themes: economy and health, because of our reading of report by the World Health Organization and many essays. The Singapore government can develop appropriate policies and regulations to deal with aging problems in time according to the dashboard.(The definition of elderly is people who are over 65)

 

Current situation:

  1. What is the distribution situation of elderly people in Singapore?

Geographical distribution data of elderly is shown on the map to help us learn the distribution of elderly from 2006 to 2015. Obviously, elder people gather in these districts: Tampines East,Bedok, Trafalgar, Aljunied and Hong Kah; and elder people are denser in the East than West, in the South than North. However, Trafalgar and Hong Kah are not as dense as in the past when time goes, and the nearby districts have become denser instead.

  1. How does age structure of Singapore change? How does the elderly support rate (ESR) change?

Demographic data from 2006 to 2015 is used to see the trend of aging process. The percentage of elder people has increased while the percentage of 0-4 year old infants has decreased, which means that Singapore is becoming an aging society. The elderly support rate represents the result of number of elder people divided by number of people between14-65. The ESR has decreased significantly, indicating the heavier burden of the aging society. Fewer young people need to support more elder people in the future. So Singapore government should pay more attention to the aging problem and take some action now.

 

Economy:

  1. Are elderly living under less or more economy pressure?

Work participation rate data of different ages in Singapore is combined with the income data to learn the degree of pressure. After comparison, we find that though the elderly’s work participation is not as high as that of young people, it has been increasing evidently these years, indicating that more and more elder people start to work. The income of elderly is not optimal: most elderly’s salary maintain below 2000 dollar. All these reflect that the economy situation of the elderly has become worse than before, and that more and more elderly need to work, most of whom have low income.

 

Health:

  1. Has the health condition of the elderly improved or not?

After comparing the growth of hospital admissions of total people and elder people, it can be found that the health situation of elderly has not improved since the growth of total hospital admissions is smaller than that of elder people after 2014. It can be seen that the growth rate of people over 65 has increased rapidly since 2014, which surpassed the growth rate of total hospital admission. Though the life expectancy of the elderly is better than before, the medical need is the key factor to measure the health condition. Higher the hospital admission is, worse the health condition is. It is acceptable that growth rate of hospital admission rate of elderly and total maintain at a same level. Once hospital admission rate of elderly has changed evidently, the government should pay attention to the health condition change of elderly.

 

Link to Tableau Public: Aging Problem of Singapore

Submitted by :

Chen Weibin     A0163249B

He Shangui       A0163348B

Liu Yizhe            A0163191J

Zou Yumeng     A0163394Y

 

Analysis on Workplace Injuries —

Analysis on Workplace Injuries

Untitled

The objective of this dashboard is to demonstrate different levels and types of injuries caused in the workplaces of Singapore.

 

Analysis on Workplace Injuries – Analytics And Intelligent Systems

Questions:

  1. In which industry majority of injuries occur?

Majority of injuries occur in the Construction and Manufacturing industry consistently over the years but in the year 2016, the injuries pertaining to “Accommodation and Food Services” has also risen.

  1. With the current scenario in workplaces, which type of injury occurs more frequently?

The number of minor injuries (94.9%) greatly exceeds the number of major (4.5%) and fatal (0.5%).

  1. Is there a trend seen in the number of injuries caused in the industries through the years 2014-2016?

The fatal and major injuries are consistent through the years, while the number of minor injuries dropped in 2015 and increased drastically in 2016.

  1. What are the common types of minor injuries across different industries?

Injuries caused by slips, trips and falls are the maximum across industries.  Injuries caused by cuts or stabs by objects is more at the Accommodation and Food services industries, while workmen at Construction and Manufacturing industries are more affected by moving objects.

  1. Why has minor injury increased drastically from 2015 to 2016 while fatal and major injuries are consistent?

A good measure has been taken to avoid the fatal injuries yet minor injuries have not decreased. This could be because of the conversion of fatal injuries to minor injuries.

 

Final Analysis

We can clearly see that fatal and major injuries are very low and steps have also been taken to reduce this further, there is still a rise in the minor injuries. This may be because the fatal injuries have been converted to minor injuries.

Struck by moving/falling objects is one of the common cause of minor injury in Construction as well as Manufacturing industry, so to suggest a common solution for this, we could make use of Wireless sensors (heat and motion) on the objects which make an alert sound when it reaches within 50 m of any human being. This way the people working at the site will be aware of any moving objects in their vicinity and move out of harm.

The injuries may be minor, but if the injuries occur simultaneously to multiple people, it may affect the overall productivity of the company.

 

Tableau Public link:

Workplace Injuries in Singapore(2011-2016)

Submitted by:

Pankaj Mitra (A0163319E)

Deepthi Suresh (A0163328E)

Neeraja Laitha Muralidharan (A0163327H)

Kriti Srivastasa (A0163206N)

Sindhu Rumesh Kumar

 

Making Singapore a Clean & Green Nation —

Making Singapore a Clean & Green Nation

Singapore_Solar_energy_3

Business Objective:

The objective of this dashboard is to promote renewable energy in Singapore. With its history of rapid growth and expanding demand for energy, Singapore is very reliant on an efficient and modern electrical system. The reliable supply of energy at a competitive price, influences the ability of Singapore industry to compete internationally, which in turn has a direct impact on its economy. Through this dashboard, we will understand how the energy is being produced from conventional methods and how much of that energy can be compensated by using Renewable Energy, especially Solar Energy.

Below are few questions that have been answered through this dashboard.

1.What are the major sources of power generation in Singapore?

  • Singapore’s geographical location is such that it limits the opportunity of using various form of renewable energy such as Wind Energy, Tidal Energy. Singapore’s wind speed is too low to harness its potential. On the other hand tidal range is narrow due to the calm seas. Solar energy is only the potential source of renewable energy available to Singapore.
  • Considering the Non-Renewable Energy resources, Natural Gas (Methane) is the major fuel source for generation of electricity followed by coal and petrol.

2.What is the effect of Current Power generation on the environment?

Most of Singapore’s power generated (say., 85%) is from Methane (Non-Renewable Energy resource). This causes serious effect to the environment and the society by emission of hazardous gases. For each kWh in a grid, certain amount of Methane is emitted to the environment. These energy sources are a potential burden on the economy of the country. They also take a major toll on the country’s air pollution index. Usage of Non-renewable resources should be replaced with renewable sources of energy resources for better and green future.

3.What is the contribution of each region of Singapore towards solar energy production?

The Solar Energy production has increased over the years in nearly all the 5 regions of the country. The West region has shown a steep increase in the solar energy production compared to all the other regions. However, the North region doesn’t have any considerable increase in the solar energy production.

4. How much Solar energy potential does Singapore have?

Singapore is situated very near to the equator, thus the average sunshine received by Singapore compared to other countries is relatively high. A large part of Singapore is still available for installation of solar panels. On an average, a square meter of solar panel will produce 150 watts per hour. Singapore enjoys an average sunshine hour of 5.5 hrs. per day. By installing more solar panels, energy generation will increase exponentially and contribute to the Singapore’s growing demand for energy/power.

Estimated daily output in Watts per day = Peak sun shine hours per day x PV systems rated output (Watts) x 0.85*

Reference: http://www.theecoexperts.co.uk/how-do-i-calculate-sun-hours

5.What is the impact of Solar energy on power tariff?

The increase in Solar Energy Production over the years has considerably reflected in reduction of general power tariff per kWh. Solar energy generation is a one-time installation set-up which would last for 10 years with minimal maintenance. Thus, compared to the other form of energy generation, cost invested in solar energy generation is negligible.

Data Source

  • The datasets related to Singapore Energy Consumption and Production are obtained from the Energy Market Authority of Singapore
  • https://www.ema.gov.sg/

Data Preparation

  • Different datasets related to energy were obtained from EMA
  • The datasets with different units were pooled together to have the their relative units for comparison

Link to Tableau Public

https://public.tableau.com/profile/publish/SolarEnergy_Singapore/SolarEnergyDashboard

Team Members

  • Aravind Somasundaram (A0163301X)
  • Mutharasan Anbarasan (A0163257A)
  • Raghavan Kalyanasundaram (A0163316L)
  • Ram Nagarajan (A0163247E)
  • Seshan Sridharan (A0148476R)
The Bubble Degree of Singapore’s HDB Resale Market —

The Bubble Degree of Singapore’s HDB Resale Market

The purpose of the dashboard is to define KPIs to measure the bubble degree of HDB resale market in Singapore. The dashboard covers the KPI from the following perspectives:

table

Q1. Price, trading volume and building age are three measurements in the first graph.

There are a few transaction records in the central area, though central area is considered as the most valuable places in Singapore. From centre to periphery, building age declines while trading volume increases. In addition, building age in periphery is much younger than that of the central area. We can deduce that Singapore government exploited new places to increase supply of houses because the demand keeps increasing. Even though it is far away from the centre, so many people still want to buy them. It signifies that resale HDB flats are still attractive for investors.

Q2. From 2013 to 2015, housing prices declined but volumes remained stable.

It means that people were less willing to buy HDB and the resale market became colder than before. Two policies, which were carried out in 2013, were highly related to the decline of prices. One is that additional buyer stamp duty was raised. Another is that new Singapore PR need to wait for 3 years before they are eligible to purchase resale HDB flats. In general, being stable is much better than having great changes in terms of housing property. Thus, we think the resale market is healthy because bubbles are not obvious now.

Q3. CPI is generally considered as an indicator to evaluate the inflation level and it is closely related to our daily life.

We can judge HDB resale market by making a comparison between CPI and growth rate. Prior to 2013, it is obvious that bubbles existed because growth rate was much higher than CPI. However, afterwards, it became better, we believe that current growth rate is reasonable. At least no significant bubbles.

Q4. We use a new measurement housing-price-to-income ratio to measure HDB resale market.

Based on international practice, the proper range of this ratio is between 3 and 6. If the ratio is higher than this, real estate bubble can be identified. When it comes to SG HDB resale market, this ratio remains around 4 during last 15 years.

During the global financial crisis period of 2008, rapid population increase, low interest rate, and high global liquidity contributed to the accelerated price increase of Singapore. However, from 2013, it declined, which means bubbles were forced out gradually.

Q5. The price-to-rent ratio is a well-established economic principle used for real estate valuation.

It is typically calculated by dividing the average list price by the average yearly rent price. At its most basic level, the price-to-rent ratio is a benchmark for understanding whether it is better to rent or buy a property. The ratio increased dramatically leading up to the 2008-2009 housing market crash. In retrospect, this was a red flag of a housing bubble. The cause of the rising price-to-rent ratio is not the increase of rental but the panic fall of housing price. In following years, the housing price gradually increased, but the rental market was relatively smooth and steady, that’s why the PR ratio fell. In summary, it indicates that Singapore HDB resale market still has potential because the rental yield is relatively high and PR ratio is rational.

Dashboard Screenshoot

Live Tableau Dashboard

Submitted by TANG ZE, ZHANG DONGXUE, JI YUNHE, ZHENG WEIYU, GAO RUOFEI

Singapore Labor Statistics 2015 —

Singapore Labor Statistics 2015

Picture1

The goal of making this dashboard is to study Singapore Labour Statistics and provide insights from the findings to Ministry of Manpower.

Following are the Questions which we are trying to explore through our dashboard :-

  1. Most attractive Industry segment of Singapore. Manpower demands in different industry sectors since 2000.

Singapore is a small country with total area of 719 Km2. Its Labour industry is divided into four major sectors Services, Construction, Manufacturing and Others. Due to its small size, there is no major scope of production which leads to a low trend in the job vacancies across Construction, Manufacturing and Other industries. The employee distribution in Singapore as per 2015 statistics is Service industry [72.9%] followed by Construction [13.7%], Manufacturing [12.7%] and Others [0.7%] which makes Service Industry as the most attractive employing industry. Singapore is the financial capital of Asia and one of the favourite tourist destination due to which Service industry has always been a prominent job market. But, it is not immune to economic unrests felt in other parts of the world. The journey of Singapore service industry has been nothing less than a roller coaster ride. The smart art given below explains the ups and downs of the Singapore Service industry since 2000: –

Picture2

  1. SG world ranking in terms of Unemployment rate. Detailed Study of Trends in Service Industry.

As per 2015 statistics, Singapore has global Unemployment rate of 2.1% and Employment Rank of 14thout of 208 countries. There are lot of jobs in Finance, Hotel and F&B market segments which keep it growing and emerging as the major job provider. The major vacancies were created in Community, Social and Personal services while real Estate, FSI and Infocom had the least number of vacancies.

  1. To find out the most & least preferred industry to work with based on Progressive Workplace indicators.

Progressive workplace indicators [Salary, working hours and Injuries] tells us the working conditions of a market segment. The job vacancy rate in Finance Services and Insurance Sector is relatively low since the jobs gets filled quickly because of handsome salary, lower workplace injuries and lesser working hours than the majority, making this segment the most desirable for job seekers. In Transport Services, the workplace injuries are the highest across all segments and the factors like lower average monthly salary and long working hours make Transport services the least preferred segment amongst the job seekers.

Owing to implementation of constructive policies by Ministry of Manpower for promoting the employment in Transport services, it has the lowest job vacancy rate despite harsh working conditions. The policies include government funded skill training, wage support to reduce the burden on employers and encouraging students to undertake Transportation as career path. Hotel and F&B, Admin and Support have the lowest average monthly salary, relatively longer working hours and unsafe working environment which leads to lot of high job vacancy rate.

  1. To suggest preventive measures to MOM for those industries which come under least preferred places to work.

Ministry of Manpower could bring certain reforms and regulations in these segments to attract more employees. Rules such as setting Higher Overtime Wage per hour can help indirectly increase average monthly salary. With higher pay eventually overtime reduces and the average working hours will be shorter.  Concluding, the major reforms in Work safety and Pay can help increasing the job vacancies in different Service segments which will further help in boosting country’s GDP.

The dashboard has been published on Tableau Public and the link to the dashboard is as follows: –

https://public.tableau.com/shared/NQ8GMN7JM?:display_count=yes

 

 

Submitted by: –

Team NUCLEUS

Praveen Tiwari (A0163322R)

Prashant Jain (A0163380J)

Praman Shukla (A0163239A)

Vicky Li Meiyao (A0163379U)

Pooja Gupta (A0163281J)

 

WORKPLACE SAFETY IN SINGAPORE —

WORKPLACE SAFETY IN SINGAPORE

WORKPLACE SAFETY IN SINGAPORE

Insights from Injury Statistics – A Dashboard for workplace safety in Singapore:

Singapore is a unique country, a developed nation yet ever-growing for industries like real estate, construction, manufacturing, mining, IT, finance. For a nation with a good growth rate as Singapore, workplace accidents and injuries gives friction to its wheels.  Workplace safety plays an important role in the smooth development of the country with higher efficiency.

One of the important indicators to understand the workplace safety & injuries scenario in a country is “occupational injury & death” statistics. Thus, the dashboard aims to provide various insights into the safety scenario of Singapore from its occupational injury and death statistics

WORKPLACE SAFETY

Goal:

To understand the workplace safety scenario in Singapore from its occupational injury data like Key safety indicators, incident type and industry wise effects of workplace injuries, a relative injury fatality standing against transport accidents and a global comparison of injury rates for the construction sector.

Questions and metrics:

Untitled

Definition of Metrics for Key Safety Measures:

  • Workplace Injury Rate:    

wir

  • Accident Frequency Rate: 

afr

  • Accident Severity Rate:      

asr         

Dashboard summary and Design perspective:

The dashboard was designed to emphasize on the key safety measures over other historical and statistical data without undermining their capability to give insights.

In the above safety measure rates, WIR and AFR have swinging trends hovering about an average value, which shows that Singapore has been putting continuous efforts to keep the rates in check by enforcing the safety regulations properly in it’s all expansions. The third-rate which is the Accident Severity Rate (A.S.R) is seen to have a slightly decreasing trend which is a good sign in terms of the country’s overall progress.

In comparison to transport accidents, over the years 2011-2015, the number of workplace accidents counted to nearly one-fourth and this has been an almost consistent observation. Also, while the number of transport accidents are decreasing over years, the number of workplace accidents have shown a slight increasing trend.  And among the various industry sectors manufacturing, construction, transportation and service sectors contribute to the most number of deaths while the prime causes of death being falls, slips, trips, struck by moving or falling objects etc.

On a global comparison, Singapore fares well especially w.r.t its neighbours in the Asia-Pacific like Hong Kong, Macau etc. as well as many European states and only falling behind Australia in Workplace Injury Rate.

References:

Data for the dashboard was collected from various sources like data.gov.sg, Workplace Safety and health (WSH) council (Singapore), International Labour Organization (ILO) and used to inform the metrics.

Link to Tableau Public : Workplace safety in Singapore

Submitted by :

Arun Kumar Balasubramanian    (A0163264H)
Devi Vijayakumar                             (A0163403R)
Pawaskar Sharvina Dileep            (A0163302W)
Pulavarthi Raghu Aditya               (A0163260N)
Sambit Kumar Panigrahi              (A0163285B)

[ISS EBAC 04 – 2017]