IS428 2016-17 Term1 Assign2 Yang Chengzhen

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Description

Abstract

Workplace Safety and Health has always been one of the top concern of Ministry of Manpower. To better manage MSH, MOM established Workplace Safety and Health (WSH) Council on 1 Apr 2008. WSH Concil coordinates with MOM to conduct research on workplace safety and health performance in Singapore. The WSH Institute conducts quality applied research and provides evidence-based information to Ministry of Manpower, WSH Council and industry stakeholders to improve WSH practices in Singapore. The data used were collated from incident reports made by employers, occupiers and medical practitioners.
This Assignment will generate analysis utilizing WSHI work place injuries data in year 2014 to gain insights of workplace safety and health situation in 2014.

Theme of Interest

In order to be more efficient in improving workplace safety and health situation, it is essential to find out the 'Vulnerable groups' and characteristics tied with different groups. Therefore MOM can provide customized plans in order to prevent the happens of injuries and react to injuries faster and smarter.
This assignment aims to find out the major vulnerable groups and peak period of workplace injury cases to facilitate MOM's customization of planning and policy-making.

Research Question

  • What characteristics do the 'more vulnerable' groups have?
  • What characteristics do the 'high injury rate' campanies have?
  • When is the peak period of accidents?
  • Does overtime play a important role in the causing factors of injuries?


Data Preparation

Attribute Selection

There are 48 columns in the raw data. After scanning through, I selected some attributes which are more relevant in identifying victim groups:

  • Accident Type Level 1 Category
  • Accident Type Level 2 Category
  • Accident Date
  • Nature of Injury
  • Major Industry
  • Sub Industry
  • Victim's Age
  • Victim's Gender
  • Informant's No of employees
  • Injured When Working Overtime

Data Preparation

Check Missing Values

Use JMP to find missing data pattern relating to the attributes selected in the previous section, only one missing data is found. I decided to ignore the record since it has no significant impact to the analysis.

150*150px

Check Distribution of Numerical Attribute

Data Exploration and Choice of Interactive Graph Tools

Implementation

Findings

Conclusion

Comments