1718t1is428T13

From Visual Analytics for Business Intelligence
Revision as of 17:54, 26 November 2017 by Jianhua.wu.2014 (talk | contribs)
Jump to navigation Jump to search
DUOteamveglogo.jpg



PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER

 

Back to Other Groups


Introduction

Singapore has developed rapidly over the past few decades and part of this development is attributed to the Education System. Singapore Education System is known to be stressful and concerns have been raised about the need to change. Is the goal at the end of this rat race worth the stress?

The Graduate Employment Survey (GES) is conducted on a yearly basis to provide insights on the salary prospects of a course. The Ministry of Education (MoE) conduct these surveys yearly for Local Universities in Singapore. However, the results of these surveys are not interactive and do not provide any trends and insights with respect to the Labour Market demands.

Labour Market data such as Job Vacancy are collect by Ministry of Manpower (MoM) to provide insight and information of the labour market to the public. Data for Job Vacancy are pertaining to private sector establishment each with at least 25 employees and the public sector. However, those data are usually in tabular form and provide minimum insight to the public for analysis of the labour market.

This project aims to offer insights about the fresh graduate salary with respect to the Labour Market in Singapore and its changes over the years. We will be focusing on the vacancy rate of the labour market and the reason contribute to the vacancy, as it affects the fresh graduate employment indirectly.

Motivation

Our research and development efforts were motivated by the lack of easy to use web-based visualizations about the fresh graduate salary and labour market as these data are mainly published in table form which are hard to illustrate trends moreover gain insights.

In addition, as graduates who will be entering the job market soon, we want to better understand the industry outlook in the labour market. Ultimately, we hope that these visualizations would help other students from Junior Colleges and Polytechnics decide their career paths.

Objectives

In this research, we aim to accomplish the following objectives:

1. Visualise the fresh graduate salary with against employment rate overtime with respect to each course.
2. Visualise the ranking of each specific course throughout the years.
3. Visualise the changes in salary with respect to the labour market by industry over the years.
4. Visualise the overall Recruitment, Resignation and Vacancy Rate by Occupation Group
5. Visualise the possible reasons for Vacancy by Sector and Education

Dataset Description

DataSet Description
Ministry of Education (MoE) Graduate Employment Survey - NTU, NUS, SIT, SMU & SUTD

Source: https://data.gov.sg/dataset/graduate-employment-survey-ntu-nus-sit-smu-sutd
  • Graduate Employment Survey of local universities in Singapore for the year 2013 - 2015
GES data from 2008 - 2016

Source: https://docs.google.com/spreadsheets/d/1tVlxRwv5mSaGIdsdxMDcxpuAHZfgyJ20mWVVVkYuPc8/pubhtml
  • Provides Graduate Employment Survey of local universities in Singapore from 2008 onwards, as the data in data.gov.sg only provide 2013 onwards
MoM Data on Labour Market

Source: http://stats.mom.gov.sg/Pages/ExploreStatisticsPublications.aspx#PublicationSearch

Provide Data on :

  • Gross Montly Income
  • Job Recruitment, Resignation, Vacancy Rate
  • Job Vacancy Reason

Background Research and Survey of Related Work

Visualization Explanation
DUOteamV1.jpg

Source: http://ideasillustrated.com/blog/2011/11/28/earnings-and-unemployment-by-college-major/
  • A divergent bar chart provides useful insights with regards to a specific course and is useful in telling the distribution of salary. In addition, it offers a good comparison overview between majors.
DUOteamV2.jpg

Source: http://ideasillustrated.com/blog/2011/11/28/earnings-and-unemployment-by-college-major/
  • A scatter plot is extremely useful into displaying the employment rate and starting salary. It provides a good visualization to show the trends over the years and more information to be displayed with the size of the circle.
DUOteamV3.jpg

Source: http://pay.sgcharts.com/index.html
  • This time series bar chart is useful in showing the starting salary of various majors as well the a line graph as the employment rate by major. This graph essentially provides a good summary and comparison of the various degrees and majors

Key Technical Challenges

Key Technical Challenges Mitigation Plan
D3.js Programming & implementation
  • Attend Workshop in Week8
  • Self-learn through online platform for more in-depth content
Data Collections and Clean up
  • Decide as a team on what data to use and what to do with missing data(if any)
Visualization Tool Usage
  • Peer Learning
  • Self-learning through online platform


Tools & Libraries

  • Tableau
  • Microsoft Excel
  • Photoshop
  • D3.js & its related Library (amChart, highchart, plotly)
  • HTML, CSS & JavaScript
  • Github

Story Board

Story board are done to show the type of chart & data to display Graduate Employement Survey Data Look into the graduate employment survey data to find out:

  • Changes of Gross Monthly Salary of each degree over the year
DUO ges Overview.png

We intended to use Scatter Plot to show the different relationship between the salary, employment rate of each degree course. It show shows it's position among all the other courses from the different university school. We will be including a timeline slider, to change the data-point accrodingly to the specific year. This will help to show how it have changes over the years

  • Ranking of the salary across the degree:
DUO GES Rank.png

Next, we intend to perform a ranking of the degree by its salary. This help to shows the ranking of each course by the starting salary amount. Beside ranking, we will show the 25, 75 percentile as well to showcase the gaps between the salary despite being of the same university and school. This allows end-user to have a better gauge of the salary distribution.

Gross Monthly Income After knowing the salary of the different degree over the year, and the ranking. We want to look into the salary of different industry and sector. Hence, We want to find out

  • What’s the changes of salary of the Sector or Industry over the year
DUO Income.png

For this, we will be using a slope graph instead. As slope graph is able to show the ranking and better illustrate the change in salary between the two years.

Rates (Recruitment, Resignation, Vacancy) Knowing the Employment Rate from the GES, we want to look into the Recruitment, Resignation & Vacancy Rate. To find out:

  • Whether is there a relationship between the rates?
DUO Bullet.png

For this, we will be using a bullet chart. With the Vacancy Rate being the target, the Recruitment Rate as the actual value and Resignation as the additional information. This will illustrate whether the company is able to recruit based on the amount of vacancy it has.

Vacancy Reason After knowing about the vacancy rate of the different occupation group and industry. We are interested to know the reason behind the vacancy rate. Hence, we want to find out:

  • Which reason contributes most to the vacancy rate of the particular industry, and which reason contributes most based on Job Education Level. And how it has changed from 2015 to 2016
DUO Reason.png

Using a spider chart, it helps to better illustrate the different reason contribution to the vacancy. As each reason is a category itself, spider chart fits well in such situations.

Project Timeline

Duo Timeline.jpg

References

Comments

Feel free to give us comments!